表结构
删除重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);