mysql随机删除数据

想要飞的小乌龟转载数据库 2022/08/04 10:56:38 237 阅读约 5 分钟

摘要: delete from  table where id in(select * from (SELECT id FROM table ORDER BY RAND() LIMIT 10000)

delete from table where id in(select * from (SELECT id FROM table ORDER BY RAND() LIMIT 10000) a)

237 阅读 ← 返回技术栈