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