/ Published in: SQL
This is the quick method and painless way to Remove duplicate entries from MySQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
CREATE TABLE new_table AS SELECT * FROM old_table WHERE 1 GROUP BY [COLUMN TO remove duplicates BY]; DROP TABLE old_table; RENAME TABLE new_table TO old_table;