Need Help with mySQL ALTER TABLE

[kktnguyen]

I want to create a table..Pls see the code below..but I would like to set the Username to unique or or primary key..scince I set AuthID to primary key already I can not make the Username to become primary key..Please help me out with this issue?
Thanks musch..

CREATE TABLE tblAuthenticates(
AuthID int(6) not null auto_increment,
Username varchar(32) not null,
Password varchar(128) not null,
Status tinyint not null,
AtypeID int(6),
FOREIGN KEY (ATypeID) REFERENCES tblAuthType(AtypeID),
PRIMARY KEY (Username)
PRIMARY KEY (AuthID));

[cnplnsk]

You may use alter table using command
ALTER TABLE
you can find help about this command on google search

[ronverdonk]

You may use alter table using command
ALTER TABLE
you can find help about this command on google search

Do not google when you can find the answer in the standard public MySQL documentation itself!

Look at Alter Table Syntax for your information.

Ronald :cool: