OriginalSunny Posted April 14, 2006 Share Posted April 14, 2006 Hi,I am trying to add a new column to my table and making it the primary key. The problem is that i already have a primary key in the table. I cant seem to delete the column which is already the primary key and i cant seem to add the new column as i want to make it the primary key, and there is already a primary key in the table. So how do i do this??Here is what i have tried and none of it works:[i]alter table emp add column ID int(5) auto_increment first; (empID is the new column i want to make the new primary key)alter table emp drop index username; (username is the present primary i want to change)[/i]Thanks Link to comment https://forums.phpfreaks.com/topic/7444-how-to-add-a-new-column-to-table-and-make-it-pri-key/ Share on other sites More sharing options...
fenway Posted April 16, 2006 Share Posted April 16, 2006 Having already added the new column, you need to issue an ALTER TABLE statement with DROP PRIMARY KEY, ADD PRIMARY <yourNewCol> together, AFAIK. Link to comment https://forums.phpfreaks.com/topic/7444-how-to-add-a-new-column-to-table-and-make-it-pri-key/#findComment-27535 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.