Date: 11/27/07 (Java Web)    Keywords: mysql, database, sql

To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id’s to delete from the original table. Delete using the temporary can take two forms. First is the slow way: delete from target where id in (select id from temp); This can be [...]

Source: http://blog.taragana.com/index.php/archive/mysql-sql-delete-notes/