Hi, > Can naybody tell me how can i get the last 10 inserted record in the table > in MySql. Is MySql uses rowid like Oracle. Yep, you can use _rowid and a user variable to get what you want: select @startrow:=count(*)-10 from mytable
select * from mytable where _rowid>@startrow Greetings Lutz Maibach --------------------------------------------------------------------- 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