解决 查询重复id条数 SELECT id,COUNT(*) FROM tb_country GROUP BY id HAVING COUNT(*) > 1; 假设查询出来的多余数据条数为:243。 去掉多余条数 DELETE FROM tb_country WHERE id IN ( SELECT id FROM ( SELECT id,COUNT(*) FROM tb_country GROUP BY id HAVING COUNT(*) > 1 ) AS a ) LIMIT 243; 参考: Mysql删除id相同的重复数据