Delete Dulicate Rows in MySQL - SQL Snipplr Social Repository

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