Jump to content

Archived

This topic is now archived and is closed to further replies.

OriginalSunny

command to add column to a table

Recommended Posts

Hi,
i am fairly new to mysql. I need to add a new column to a table and it works fine when using the following command:

alter table [i]table name[/i] add [i]column name[/i] int(10) first;

however i wish to also make it the new primary key of the table and also to assign it an auto increment value. How do i go about doing this?? Thanks.

Share this post


Link to post
Share on other sites
Try the following:

[code]alter table table name add column name int(10) unsigned first not null auto_increment, add primary key (first);[/code]

Just make sure you remove any existing primary key index first.

Share this post


Link to post
Share on other sites
Post the "SHOW CREATE TABLE" for the table in question -- it's possible that you already have a primary key, and need to drop it first.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.