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

One thought on “Remove duplicate entry on mysql record”

Tinggalkan Balasan ke keersuddy Batalkan balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *

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