mysql怎么删除表的重复数据只保留一条？

[asdffff_]

如题

[关山万里]

delete from 表名 where 字段ID in (select * from (select max(字段ID) from 表名 group by 重复的字段 having count(重复的字段) > 1) as b);