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;

SELECT * FROM old_table WHERE 1 GROUP BY [column to remove duplicates by];


DROP TABLE old_table;



RENAME TABLE new_table TO old_table;

This is the quick method and painless way to Remove duplicate entries from MySQL

Remove duplicate entries / rows from mySQL

mysql

SQL