最近遇到一条需求,要求MySQL数据表保留最新10000条数据,经过查找和试验,总结出最初正确语法如下:
DELETE FROM tablename WHERE keycol NOT in (SELECT temp.keycol FROM (SELECT keycol FROM tablename ORDER BY keycol DESC LIMIT 10000) AS temp);
有需要的可以借鉴
最近遇到一条需求,要求MySQL数据表保留最新10000条数据,经过查找和试验,总结出最初正确语法如下:
DELETE FROM tablename WHERE keycol NOT in (SELECT temp.keycol FROM (SELECT keycol FROM tablename ORDER BY keycol DESC LIMIT 10000) AS temp);
有需要的可以借鉴