List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 22 2002 3:05pm
Subject:Re: unique
View as plain text  
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

Thread
uniqueCiprian I. Acatrinei22 Oct
  • re: uniqueEgor Egorov22 Oct
  • Re: uniquegerald_clark22 Oct
  • Re: uniquePaul DuBois22 Oct
Re: uniqueScott Pippin22 Oct