Index a 'duplicated' field ?

[rab54]

Hi gurus -

What is the best way to put a unique index on a column that already has duplicate data in ?

Should I remove the dupes first ? then add the index or is there a better way ....

Maybe dump the table ,remove dupes with DISTINCT and re-import ?

cheers

Rab

 

[sleipnir214]

You must remove the duplicates first -- that is, after all, what a unique index is there to prevent.

How you remove the duplicates will depend on the structure of your table.


Want the best answers? Ask the best questions!

TANSTAAFL!!