MySQL删除一张表中某一字段值的重复记录

转载 MySQL删除一张表中某一字段值的重复记录

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)