The following query can be used to count duplicated records in MySQL:
SELECT count(*) AS duplicate_count
FROM (
SELECT column_name FROM table
GROUP BY column_name HAVING COUNT(column_name) > 1
) AS t
MySQL: How to Count Duplicated Records
writing for living
