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.

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

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,

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

simultaneus processes and it doesn't happen at all. Could be a problem with the architecture? Fix: Unknown fix Submitter-Id: Zeus Gomez Marmolejo Originator: Organization: Facultat d'Informatica de Barcelona [UPC] MySQL support: none Synopsis: MySQL error report Severity: serious

MySQL strange error: lost connection during query

simultaneus processes and it doesn't happen at all. Could be a problem with the architecture? Fix: Unknown fix Submitter-Id: Zeus Gomez Marmolejo Originator: Organization: Facultat d'Informatica de Barcelona [UPC] MySQL support: none Synopsis: MySQL error report Severity: serious

MySQL strange error: lost connection during query

with the architecture? Fix: Unknown fix Submitter-Id:Zeus Gomez Marmolejo Originator: Organization: Facultat d'Informatica de Barcelona [UPC] organization of PR author (multiple lines) MySQL support: none Synopsis:MySQL error report Severity:serious Priority:medium