MySQL查询重复元素

1.查询重复元素

• url即为查询的重复元素，替换即可
• tb_photography为查询的表

select id,url,count(url) as c from tb_photography GROUP BY url having c>1;

如图所示

2.删除重复元素

DELETE FROM tb_photography 
	WHERE id NOT IN (
		SELECT temp.min_id FROM 
			(SELECT MIN(id) min_id FROM tb_photography GROUP BY url) AS temp
	);
select * from tb_photography ;

GROUP BY：按某字段分组
MIN()：筛选出某字段的最小值