mysql 数据表中查找重复记录（条数）

SELECT 字段,COUNT(*) AS COUNT FROM 表名 GROUP BY 字段 HAVING COUNT>1;