At 3:30 PM -0500 9/18/01, Jay Paulson wrote:
>What is the command in MySQL to grab the last item that was inserted into
>the database?
>
>thanks...
>jay
If you mean the last record, there's no such command.
If you mean the most recent AUTO_INCREMENT value what was generated
during your current session with the server, it's
SELECT LAST_INSERT_ID()
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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