MySQL删除重复数据

delete from TableName where id in(

select id from(

select id   from TableName where  name  in (select name from TableName group  by name  having  count(name) > 1)
 and id not in(select id from TableName group by   name  having count(name )>1))t

 

)