mysql 删除重复数据

表结构

删除重name 等于repeat重复的记录

delete from student where name = 'repeat' and id not in (select * from ( select min(id) from student where name = 'repeat') as s2);

删除所有重复的记录

select id from ( select min(id) as id from student  GROUP BY name HAVING COUNT(name) > 1) as s2

delete from student where  id not in (select id from ( select min(id) as id from student  GROUP BY name HAVING COUNT(name) > 1) as s2);