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
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.
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
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,
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
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
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
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
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