1
DELETE FROM en_wiki
WHERE 1=1
AND `title` in (SELECT * FROM ( (SELECT `title` FROM en_wiki GROUP BY title HAVING COUNT(`title`)>1) ) a)
AND id not in (SELECT * FROM ( (SELECT MIN(id) ids FROM en_wiki GROUP BY title HAVING COUNT(`title`)>1) ) b)
2
DELETE FROM en_enterprise
WHERE 1=1
AND `title` in (SELECT * FROM ( (SELECT `title` FROM en_enterprise GROUP BY title HAVING COUNT(`title`)>1) ) a)
AND id not in (SELECT * FROM ( (SELECT MIN(id) ids FROM en_enterprise GROUP BY title HAVING COUNT(`title`)>1) ) b)
3 这条去重复的SQL比较简单
DELETE FROM test
WHERE id not in ( select * from (SELECT MIN(id) ids FROM test GROUP BY `name`) a);