Tag Archives: sql
Finding Duplicate Records in MySQL
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
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