<![CDATA[Heck's Blog]]> https://www.heckjj.com/index.php zh-cn https://www.heckjj.com/post// <![CDATA[MySQL 查询表中某字段值重复的数据]]> Heck <@hecks.tk> Thu, 09 Jul 2020 08:06:10 +0000 https://www.heckjj.com/post//
SELECT url, COUNT(*) AS sumCount FROM crawl_content GROUP BY url HAVING sumCount > 1;
说明：先用GROUP BY 对 url进行分组，同时使用COUNT（*）进行统计，再用HAVING来过滤大于1的，这样查找出来的就是重复的记录了。
Tags - , ]]> https://www.heckjj.com/post//#blogcomment <![CDATA[[评论] MySQL 查询表中某字段值重复的数据]]> <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 https://www.heckjj.com/post//#blogcomment