OriginalSunny Posted February 5, 2006 Share Posted February 5, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/3331-adding-a-new-column-to-a-row-in-mysql/ Share on other sites More sharing options...
fenway Posted February 5, 2006 Share Posted February 5, 2006 Double-post? Quote Link to comment https://forums.phpfreaks.com/topic/3331-adding-a-new-column-to-a-row-in-mysql/#findComment-11359 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.