setting a collumn to be unique in existing table - 10-22-2006 , 11:01 AM
ive been looking on the mysql site but i cant find the syntax to set a
collumn in an existing table to be unique.
could someone please give an example of how to do this.
i believe it goes something like: alter table tblname add unique
but i could be wrong
Re: setting a collumn to be unique in existing table - 10-22-2006 , 11:45 AM
mcyi2mr3 (AT) googlemail (DOT) com wrote:
ALTER TABLE `my_table` DROP INDEX `my_field_index`
have a look at phpmyadmin