mysql 删除相同数据

delete from student where id not in (select minid from (select min(id) as minid from student group by name) b)