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.
Adding a new column to a row in mysql
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users