查看重复的数据
SELECT id,COUNT(id) FROM `test` GROUP BY id HAVING(COUNT(id)>1)
查看重复的数据
SELECT MAX(id) FROM `test` GROUP BY id HAVING COUNT(*)>1
重复数据的id
SELECT * FROM (SELECT MAX(id) FROM `test` GROUP BY id HAVING COUNT(*)>1) a
SELECT GROUP_CONCAT(id) FROM (SELECT MAX(id) AS id FROM `test` GROUP BY id HAVING COUNT(*)>1) a
删除重复的id
DELETE FROM test WHERE id IN (151103,151104,151,151102,15)