From: Michal Zaschke
Date: April 15 1999 4:31am
Subject: Re: Alter Table - make column unique
List-Archive: http://lists.mysql.com/mysql/1877
Message-Id: <37156BBD.1121F6A6@suas.cz>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 7bit

What about:
alter table reviews change revr_nick revr_nick varchar(12) not null, add
unique (revr_nick);

Mike


Stephen F. Johnston Jr. wrote:
> 
> hello all-
> 
>         I am trying to execute this command, any idea why it does not work?
> 
> 'alter table reviews change column revr_nick UNIQUE revr_nick varchar(12)
> not null'
> 
> I have tried other permutations including...
> 
> 'alter table reviews change column revr_nick UNIQUE( revr_nick varchar(12)
> not null)'
> 
> and
> 
> 'alter table reviews change column revr_nick (UNIQUE revr_nick varchar(12)
> not null)'
> 
> anyway.. anyone out there have my silver bullet. I am probably just reading
> the docs wrong......