第一步:找最小的唯一id select min(id) as id from 表名 group by 要去重的字段 第二步:将唯一id取出 select temp.id from (select min(id) as id from 表名 group by 要去重的字段) as temp 第三步:将除唯一id之外的数据全部删除 delete from 表名 where id not in (select temp.id from (select min(id) as id from 表名 group by 要去重的字段) as temp)