At 03:30 PM 9/18/2001 -0500, Jay Paulson wrote:
>What is the command in MySQL to grab the last item that was inserted into
>the database?
i'm 99% sure there isn't one.
a sql table is an unordered set. there is no concept of first or last. in
theory you could get the same SELECT statement returning rows in completely
different order each time (assuming you don't use an ORDER BY clause).
if you need to know when a row was created you should use a TIMESTAMP column.
-jsd-
---------------------------------------------------------------------
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
