Assigning unique key to mysql table

[hswaseer]

Hi,

I want to assign unique key to my database column so that all the duplicate records are deleted.

How should i write this query?

Thanks

HS

[hswaseer]

Hi,

I have read few articles and able to make the below query

ALTER IGNORE TABLE `abc` ADD UNIQUE(`name`);

want to know that, is this query is OK?.....

What i want is that it should delete all the duplicate names from my table.

HS