entry just made in mysql table

2002-09-03 Thread mixo 

sql,query

Is there a way to find out what the value of the last entry just made
in a mysql table where the field is being auto incremented?




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: entry just made in mysql table

2002-09-03 Thread Paul DuBois 

At 17:10 +0200 9/3/02, mixo wrote:
sql,query

Is there a way to find out what the value of the last entry just made
in a mysql table where the field is being auto incremented?

SELECT LAST_INSERT_ID();


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php