Remove duplicate entry on mysql record

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

Satu pemikiran pada “Remove duplicate entry on mysql record”

Tinggalkan komentar

Situs ini menggunakan Akismet untuk mengurangi spam. Pelajari bagaimana data komentar Anda diproses