Digging around today I found a query that will identify duplicate records in a MySQL database.
SELECT id, count(*) as n FROM table_name GROUP BY id HAVING n > 1
You must be logged in to post a comment.
