mysql查询某字段重复数据

查询syncdisk表中，name字段值重复的数据及重复次数

select name,count(*) as count from tsfs.syncdisk group by name having count >1;