mysql 数据表中查找重复记录



语句：

select col,count(*) as count from table group by col having count>1;