Re: unique

[Paul DuBois]

At 10:25 -0400 10/22/02, Ciprian I. Acatrinei wrote:
>Hi,
>
>I am having a hard time removing the unique property from a field...
>
>I set up a field as unique now I need to allow multiple values in that
>field. How do I take out the unique property of that field...

- Drop the unique index
- Add a non-unique index

You can't change a unique index into a non-unique index.

>
>PS: I couldn't figure it out from
>http://www.mysql.com/doc/en/ALTER_TABLE.html
>
>Thank you,
>Cip