Mysql remove duplicates

mysql-remove-duplicates.sql

### SHORT WAY
DELETE n1 FROM names n1, names n2 WHERE n1.id > n2.id AND n1.name = n2.name

### FAST WAY
-- Create temporary table
CREATE TABLE temp_table LIKE table1;

-- Add constraint
ALTER TABLE temp_table ADD UNIQUE(category, image_set_id);

-- Copy data
INSERT IGNORE INTO temp_table SELECT * FROM table1;

-- Rename and drop
RENAME TABLE table1 TO old_table1, temp_table TO table1;
DROP TABLE old_table1;