MySQL删除一张表中某一字段值的重复记录
delete from 表名 where id in (
select * from (
select id from 表名 where 字段名
in (
# 查找字段值重复的信息
select 字段名 from 表名 group by 字段名 having count(1)>1
) and id not in (
# 查找最小id记录
select min(id) from 表名 group by 字段名 having count(1)>1
)
) as 表名_copy
);
如果是两个字段值重复 写法是(字段名1, 字段名2)