How to take Out Duplicate entry from a Table in MYSql

By: Shailesh Singh | 28 Sep 2008 2:06 pm

Hi all,

I have to remove all duplicate entry from a table Pleas suggest me who do i do it

I have to clean the Table

Bye

One method of removing duplicate entry is by creating one more table with different name but same filed and select the data from old table with GROUP BY (filed u check for duplicate) and insert in the new Table

OR

USE

SELECT id FROM `fact` GROUP BY keyword_id, time_id HAVING count( * ) >1;

Bye

By: Shailesh Singh | 28 Sep 2008