Toggle nav
Posted 9 years ago - updated 9 years ago mysql
Use IGNORE to remove duplicate records:
IGNORE
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