navicat中查重并删除
# 查询所有重复的数据
SELECT * FROM hao123 WHERE ir_url IN
(SELECT ir_url FROM `hao123` GROUP BY ir_url having count(ir_url)>1)
# 只显示某几个字段 提高查询速度
SELECT ir_title,ir_url FROM hao123 WHERE ir_url IN
(SELECT ir_url FROM `hao123` GROUP BY ir_url having count(ir_url)>1)
# 把查询出来的重复行删除 DELETE FROM `hao123` WHERE ir_url IN (SELECT ir_url FROM (SELECT ir_url FROM `hao123` GROUP BY ir_url having count(ir_url)>1)a) AND ir_id NOT IN (SELECT * FROM (SELECT min(ir_id) FROM `hao123` GROUP BY ir_url HAVING count(ir_url)>1)b);
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步