Deleting Duplicate Records in MySQL

Posted by admin

April 15, 2008

The command given below will check the columns written in brackets and delete duplicate records.

ALTER IGNORE TABLE mytable ADD UNIQUE KEY ( field1, field2,… ) ;

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.

If you enjoyed this post, please consider to leave a comment or subscribe to the feed and get future articles delivered to your feed reader.

Comments

No comments yet.

Leave a comment