【mysql】mysql查询重复记录并删除

mysql查询重复记录并删除

# 查重，包含重复的全部显示(md5为判断重复的依据)
select * from telRecord
where md5 in (select md5 from telRecord group by md5 having count(md5) > 1)

# 查重，显示需要删除的内容(id为自增长，MD5为判断重复依据)
select * from telRecord 
where md5 in (select md5 from telRecord group by md5 having count(md5) > 1)
and telRecordid not in (select min(telRecordid) from telRecord group by md5)

# 去重，删除重复的内容
delete from telRecord 
where telRecordid not in(
	select aa.telRecordid from (
		select min(a.telRecordid) telRecordid 
		from telRecord a 
		group by md5) aa )

参考文章：
总遇到1248错误：https://bbs.csdn.net/topics/120099129
1093错误：https://blog.csdn.net/rookie_ceo/article/details/48912873