Adding a new column to a row in mysql

[OriginalSunny]

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 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.

[fenway]

Double-post?