mysql删除重复的数据

select  field ，count()1  from   table group by filed  having count(1)>1  t
查找出你要删除的数据
delect from table where filed not  in  
select  t.field
(
 (select  field  from   table group by filed  having count(1)>1 )t
）