>>> "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_INSERT_ID() will return the latest inserted id.
*****************************************************************
This footnote confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
*****************************************************************
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>