"How do I ..." SQL question

Hi there: I have a "How do I..." SQL question regarding selecting distinct values from a field not included in an aggregated query when LIMIT is in effect, illustrated by the following example: Table a contains the names of individuals, the places they have visited and the year in which they were

grant tables update backward compatibility

Hi there, I have been using mysql 3.23.58, and I want to upgrade to 4.0.20. My question is this: after I run the script to upgrade the grant tables to support the new privilgeges, can I then revert back to 3.23.58 seamlessly or will I need to readjust the grant tables. Thanks in advance. -Bo

data disappeared in mysql on XP

Hi all, I have just installed mysql 4.0 on my XP. I inserted data into the db by java. Then I used 1) command prompt to select from the table 2) MysqlCC 3) JDBC to retrieved the inserted data. It's ok. However, after a while (like rebooting my notebook, or hibernate my notebook... but not repe

table design of multi-lingual content

Hi all , I want to design a table, say T_PRODUCT { PRD_ID, NAME, DESCRIPTION, PRICE } where I want NAME and DESCRIPTION to have multi language inputed. I searched before where found two solutions : 1) T_PRODUCT {PRD_ID, PRD_DETAIL_ID, PRICE} T_PRODUCT_DETAIL { PRD_DEATIL_ID, LANG, NAME, DESCRIP

Query formulation question

Hi there, I have some experience with SQL, but I'm drawing a blank on this one. I have a table with these fields: Location Unit StartDate StopDate I want to construct a SELECT statement to get to a report that looks something like this: Location1Location2 Location3 ... Date1

safe_mysqld bind-address

Hi all , I am trying to do the following : [root@xxx bin]# ./safe_mysqld --bind-address=192.168.1.222 Starting mysqld daemon with databases from /usr/local/mysql/var but when I telnet xxx 3306, the mysqld have the following response: ./safe_mysqld: line 1: 12325 Segmentation fault nice -

MySQL strange error: lost connection during query

reports: 'Database not selected' maybe because after a bad query the connection to the database has been lost? I have tested this code in a linux machine with 15 simultaneus processes and it doesn't happen at all. Could be a problem with the architecture? >Fix: Unknown

MySQL strange error: lost connection during query

ut it doesn't work. Sometimes reports: 'Database not selected' maybe because after a bad query the connection to the database has been lost? I have tested this code in a linux machine with 15 simultaneus processes and it doesn't happen at all. Could be a problem w

MySQL strange error: lost connection during query

ut it doesn't work. Sometimes reports: 'Database not selected' maybe because after a bad query the connection to the database has been lost? I have tested this code in a linux machine with 15 simultaneus processes and it doesn't happen at all. Could be a problem w

Altering Table Fields Place on the table

Hi there, I'm rather new to mySQL and I have some questions to ask : How can I alter my table field to move before another table field ? Chua Zhi Hon aka. Zeus - Founder, Frozened.com "Your site for technology news, SUMMARISED!" http://w