Re: Compiled C-language CGI-BINs with MySQL
-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 which use the C-language interface of MySQL? Does it work OK? Thanks. - -- Viele Grüße, Lars Heidieker [EMAIL PROTECTED] http://paradoxon.info - Mystische Erklärungen. Die mystischen Erklärungen gelten für tief; die Wahrheit ist, dass sie noch nicht einmal oberflächlich sind. -- Friedrich Nietzsche -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (Darwin) iD8DBQFFVbPLDAkIK9aNPuIRAosbAJ9HMk3tEB0DvRj8DokO0B/bugAWGACfc1/K oS2PB1x3Ax36uEHxbDttdbQ= =ZNmM -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MAX() and GROUP BY question
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 how to get the entire row where ID is maximum per given status_id Mysql 4.0.xx for example: id status_idnamedate 6 3 name0 date0 5 1 name1 date1 7 4 name3 date3 10 3 name2 date2 If I execute SELECT MAX(id), status, name, date FROM table_name WHERE status=3 GROUP BY staus_id or SELECT MAX(id), status, name, date GROUP BY staus_id only id and status_id will be returned correctly, while name and date can well be from another row for example: 10 3 name0 date0 Thanks a lot for any suggestions Yannis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error:1067 could not start mysql server
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 can get the backup.Please give me the solution asap thanks and regards, venu
Besoin d'aide urgent
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 mettant sur: C:\mysql\bin puis en entrant la commande suivante: mysqld-nt.exe mais celui ci ne se lance pas. Existe t'il une autre maniere d'aborder la situation??? Je vous remercie d'avance pour avoir une solution a ce probleme et j'aimerai savoir s'il existe un mode graphique pour cette version de mysql???. ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
check bugs.
please check bugs and please give the answer Bug ID=24216 and 24216 CPK
Re: MAX() and GROUP BY question
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 this using two queries: First will select a list of max record_id's: SELECT MAX(record_id) GROUP BY ticket_id Then using API I create a comma separated list of record_id's. Then I select the latest records of each ticket: SELECT * WHERE record_id IN () I just wonder if there is more optimised solution Thanks a lot - Original Message From: Tim Lucia [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, November 11, 2006 3:56:49 PM Subject: RE: MAX() and GROUP BY question 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 how to get the entire row where ID is maximum per given status_id Mysql 4.0.xx for example: id status_idnamedate 6 3 name0 date0 5 1 name1 date1 7 4 name3 date3 10 3 name2 date2 If I execute SELECT MAX(id), status, name, date FROM table_name WHERE status=3 GROUP BY staus_id or SELECT MAX(id), status, name, date GROUP BY staus_id only id and status_id will be returned correctly, while name and date can well be from another row for example: 10 3 name0 date0 Thanks a lot for any suggestions Yannis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: access full-text index
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 http://br.geocities.com./lgcdutra/ +55 (11) 9406 7191 mailto:[EMAIL PROTECTED] +55 (11) 2122 0302 xmpp:[EMAIL PROTECTED] ymsgr:sendIM?lgcdutra BRASIL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimize question
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 table whit all day ? That is what indexes are for. And last question, if I do a group by, I think the group by is faster on column as type INT Vs Varchar ? Not necessarily so. -- Leandro Guimarães Faria Corcete DUTRA+55 (11) 5685 2219 http://br.geocities.com./lgcdutra/ +55 (11) 9406 7191 mailto:[EMAIL PROTECTED] +55 (11) 2122 0302 xmpp:[EMAIL PROTECTED] ymsgr:sendIM?lgcdutra BRASIL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]