SELECT my_column, COUNT(*) as count FROM my_table GROUP BY my_column HAVING COUNT(*) > 1 ..... 转载请注明：谷谷点程序 » mysql查重复的语句