mysql查重 | 织梦先生

mysql数据库查重、去重

查重一：

SELECT COUNT(*),`name`,`data` FROM `setting` GROUP BY `name` HAVING count(*) > 1;

0	SELECT COUNT(),`name`,`data` FROM `setting` GROUP BY `name` HAVING count() > 1;