sql help

[tbobker]

I want to add a column into a table but want to assign it to be primary key

i have

ALTER TABLE pages ADD username varchar(30)

how can i make it primary key

[examancer]

something like...

ALTER TABLE pages ADD username varchar(30) PRIMARY KEY

😉

though you may need to drop your previous primary key if one exists...

ALTER TABLE pages DROP PRIMARY KEY, ADD username varchar(30), ADD PRIMARY KEY (username)

or at least that SHOULD work...

[Houdini]

I suppose you would first

DROP PRIMARY KEY

then ALTER the table. Here is from the MySQL manual.

DROP PRIMARY KEY drops the primary index. Note: In older versions of MySQL, if no primary index existed, DROP PRIMARY KEY would drop the first UNIQUE index in the table. This is not the case in MySQL 5.0, where trying to use DROP PRIMARY KEY on a table with no primary key give rises to an error.

[tbobker]

thanks works fine.

I have totally forgotton how to write a simple login script that will just check values from the database and forward you onto a page and put the username into a session?