[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]