解决
查询重复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;
参考: