CHANGE COLUMN unique 1

[soundmind]

Hi, I'm trying to change a column type to unique.

I tried the following but got some interesting error msgs.
Please help!

Here's what I tried:

ALTER TABLE number CHANGE COLUMN date unique
ALTER TABLE number CHANGE ADD unique(date)
ALTER TABLE number CHANGE date ADD unique (date)

Thanks!

 

[sleipnir214]

"Unique" is not a property of a column, but rather a property of an index on a column. So you don't want to change the column but rather add a unique index on that column.

Look for the text "ADD UNIQUE" on the MySQL online manual page which covers ALTER TABLE,

http://www.mysql.com/doc/en/ALTER_TABLE.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!