mysql 怎么删除多个数据

发布网友发布时间：2022-04-07 14:52

共7个回答

热心网友时间：2022-04-07 16:22

这么试试
delete from tb where id in (select * from (select id from tb order by id desc limit 20) as tmp);

热心网友时间：2022-04-07 17:40

delete from tb order by id DESC limit 20;
delete from tb order by id DESC limit 0,20;
delete * from tb where id in (select id from tb order by id DESC limit 20);
delete * from tb where id in (select id from tb order by id DESC limit 0,20);

热心网友时间：2022-04-07 19:14

是这样的啊！！你的sql 语句是没问题的，放心用！

热心网友时间：2022-04-07 21:06

好像少了个什麼吧delete from tb order by id DESC limit 0 20这样看看

热心网友时间：2022-04-07 23:14

MYSQL好久没用了这个不行你可以试试rownum<=20

热心网友时间：2022-04-08 01:38

你的写法是正确的。

热心网友时间：2022-04-08 04:20

楼主正解~有什么问题吗？