remove dups

[raouleduke]

I forgot to add a primary key to my table before, I dumped in the data, is there an easy way to remove duplicates.
Thanks,

[swr]

Save the data somewhere, clear out the table, add the UNIQUE constraint you want, then re-insert the data. The constraint will prevent the dups from going back in.

[LordShryku]

Save a step by using a subquery create statement

CREATE TABLE new_table 
   SELECT DISTINCT field, field2
     FROM old_table