ITMISS
不幸的是,对于其他人给出的所有答案,您不能DELETE并且只能SELECT从同一查询的给定表中获得。DELETE FROM mytable WHERE id NOT IN (SELECT MAX(id) FROM mytable);ERROR 1093 (HY000): You can't specify target table 'mytable' for update in FROM clauseMySQL也不支持LIMIT子查询。这些是MySQL的局限性。DELETE FROM mytable WHERE id NOT IN (SELECT id FROM mytable ORDER BY id DESC LIMIT 1);ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'我能想到的最佳答案是分两个阶段进行:SELECT id FROM mytable ORDER BY id DESC LIMIT n; 收集ID,并将其放入逗号分隔的字符串中:DELETE FROM mytable WHERE id NOT IN ( ...comma-separated string... );(通常将逗号分隔的列表内插到SQL语句中会带来SQL注入的风险,但是在这种情况下,这些值不是来自不受信任的来源,因此它们是数据库本身的id值。)注意:尽管这不能在单个查询中完成工作,但有时更简单,“完成”的解决方案是最有效的。