Remove duplicate records from MYSQL

Posted 4 years ago - updated 4 years ago mysql

Use IGNORE to remove duplicate records:

ALTER IGNORE TABLE github_info ADD UNIQUE INDEX url_id (url_id,name,email);

Note:

As of MySQL 5.7.4, the IGNORE clause for ALTER TABLE is removed and its use produces an error.

https://dev.mysql.com/doc/refman/5.7/en/alter-table.html