Return to Snippet

Revision: 7861
at August 18, 2008 11:26 by jdbartlett


Initial Code
CREATE TEMPORARY TABLE bad_temp AS SELECT DISTINCT * FROM bad_table;
DELETE FROM bad_table;
INSERT INTO bad_table SELECT * FROM bad_temp;

Initial URL


Initial Description
Where bad_table is the name of the table containing duplicate rows.

Initial Title
Delete Dulicate Rows in MySQL

Initial Tags
mysql

Initial Language
SQL