删除第9到14条记录
delete from table_name where id between 9 and 14; |
倒序之后删除最前面5条记录
delete from user_ order by id desc limit 5;
正序之后删除最前面5条记录
delete from user_ order by id asc limit 5;
删除第9到14条记录
delete from table_name where id between 9 and 14; |
倒序之后删除最前面5条记录
delete from user_ order by id desc limit 5;
正序之后删除最前面5条记录
delete from user_ order by id asc limit 5;