Re: Compiled C-language CGI-BINs with MySQL

2006-11-11 Thread Lars Heidieker
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I tested that 4 Years ago and it worked pretty well, I don't see any reason why that should have changed On 11 Nov 2006, at 01:20, David T. Ashley wrote: Has anyone ever written C-language CGI-BIN programs (to be executed from Apache) and

RE: MAX() and GROUP BY question

2006-11-11 Thread Tim Lucia
How about select ID, X, Y, Z from USERS order by ID desc limit 1 Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 10, 2006 5:47 PM To: mysql@lists.mysql.com Subject: MAX() and GROUP BY question Hello everybody Can you explain me please

Error:1067 could not start mysql server

2006-11-11 Thread VenuGopal Papasani
Dear all, I am getting the following error when i m trying to start mysql server Error:1067:process terminated unexpectedly. I have tried stopping many services and start mysql but not successful.But i need to get my data backup.Is there any alternative to mysqldump command where i

Besoin d'aide urgent

2006-11-11 Thread Yannick Landry ANTONIO
Je viens au pres de vous solliciter une aide en ce qui concerne le demarrage du serveur mysql. J'ai installe sur ma machine la version mysql suivant: mysql-4.0.20a-win Je constate qu'il n'y a pas un racourcie pour la source graphique. J'ai tente de demarrer le server en ligne de commande en me

check bugs.

2006-11-11 Thread C K
please check bugs and please give the answer Bug ID=24216 and 24216 CPK

Re: MAX() and GROUP BY question

2006-11-11 Thread [EMAIL PROTECTED]
No, this won't work I actually have a table of support ticket records record_id ticket_id date name status department_id and other columns I must select an ordered list of ticket_id where each row is the most recent record of gived ticket: max(record_id) for given ticket_id I currently solved

Re: access full-text index

2006-11-11 Thread Leandro Guimarães Faria Corcete DUTRA
On Wed, 08 Nov 2006 18:51:20 -0800, Rares Vernica wrote: Is it possible to access the Full-Text Index structures from SQL? What do you mean exactly? SQL is not intended for physical structures. -- Leandro Guimarães Faria Corcete DUTRA+55 (11) 5685 2219

Re: Optimize question

2006-11-11 Thread Leandro Guimarães Faria Corcete DUTRA
On Wed, 08 Nov 2006 15:38:27 -0500, Francis wrote: If I do a select to get the log for this date 2006-01-01 : Select * from mytable where mydate = '2006-01-01' and mydate = '2006-01-01'. Do you think is more faster to do on table with have only one date or is the same think if I do it on