RE: [C2] mysql and auto-increment

2001-08-20 Thread Orgalist
doesn't work. send back 0 for each row there is in the table C. -Message d'origine- De : Alen Milkovic [mailto:[EMAIL PROTECTED]] Envoyé : lundi 20 août 2001 12:00 À : [EMAIL PROTECTED] Objet : Ang: [C2] mysql and auto-increment >>> "Orgalist" <[

Ang: [C2] mysql and auto-increment

2001-08-20 Thread Alen Milkovic
>>> "Orgalist" <[EMAIL PROTECTED]> 20.08.01 11:54 >>> >hello, >I have a mysql database with a table 'listes' which has >a column 'id' auto increment. >How can I get the last inserted row's id ? >(except using select max(id) from ) >thanks. Just use the LAST_INSERT_ID() function. SELECT LAST

[C2] mysql and auto-increment

2001-08-20 Thread Orgalist
hello, I have a mysql database with a table 'listes' which has a column 'id' auto increment. How can I get the last inserted row's id ? (except using select max(id) from ) thanks. C. - Please check that your question has no