setting a collumn to be unique in existing table

#1

hi all

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
colname

but i could be wrong

#2

also the syntax to unset this would also be useful. thanks

#3

mcyi2mr3 (AT) googlemail (DOT) com wrote:

Quote:

also the syntax to unset this would also be useful. thanks

ALTER TABLE `my_table` ADD UNIQUE (`my_field`)

ALTER TABLE `my_table` DROP INDEX `my_field_index`

have a look at phpmyadmin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

setting a collumn to be unique in existing table

mailing.database.mysql mailing.database.mysql

setting a collumn to be unique in existing table - 10-22-2006 , 11:01 AM

Re: setting a collumn to be unique in existing table - 10-22-2006 , 11:02 AM

Re: setting a collumn to be unique in existing table - 10-22-2006 , 11:45 AM