[snip]
I'm interesting to know what is the best way to select  last inserted
record.

This can do it  "ORDER BY id desc limit 5" .. but ..
[/snip]

That is generally best, but if you have an auto-increment field

SELECT MAX(auto-increment field), * FROM `table` 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to