Remove duplicate entry on mysql record

Posted on

When I have very lot of duplicate entry in my database, I searching on the net about how to eliminate unnecessary entry on my Database.

Here’s the magic command I found on the net.

CREATE TABLE new_table AS
SELECT * FROM old_table WHERE 1 GROUP BY [COLUMN TO remove duplicates BY];
Many thanks to Justin for this great magic trick

One thought on “Remove duplicate entry on mysql record

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.