command to add column to a table
Posted 05 February 2006 - 05:14 PM
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 table name add column name 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.
Posted 05 February 2006 - 06:08 PM
alter table table name add column name int(10) unsigned first not null auto_increment, add primary key (first);
Just make sure you remove any existing primary key index first.
Posted 05 February 2006 - 07:48 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users