Thursday 15 July 2010

mysql - select last 25 records from SQL table -



mysql - select last 25 records from SQL table -

i want retrain lastly 25 entered records , delete remaining records according id.

delete * list id not in ( select * ( select * 'list' order id desc limit 25 ) rows )

delete * 'list' id not in ( select id 'list' order id desc limit 25 )

mysql sql

No comments:

Post a Comment