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