Remove duplicate entries in your Database is fairly hardcore, and should be dangerous. Two easy possibilities allow to remove duplicate entries
Before, make a backup of your database. Now, The frist simple way, without modify the structure of your table, is to copy your table in a new one, by selecting only distinct rows :
INSERT INTO newtable SELECT DISTINCT uniqueid FROM duplicatetable GROUP BY uniqueid
Now, in newtable, you have distinct records of duplicatetable. You just have to empty duplicatetable and replace by records from newtable.
You can also simply alter your table, by adding a unique index. The other approach is to simply add a UNIQUE index to the current table and thereby let MySQL do the hardcore identification and deletion job.
ALTER IGNORE TABLE 'duplicatetable' ADD UNIQUE 'nameOfTheIndex' ( 'uniqueid' ( 255 ) )
That’s all, the table is clean