[SOLVED] I made a boo-boo

[Eiolon]

When I created a table I accidentally forgot to make the id a primary key and auto_increment.  Can I go back and make it this way or do I need to recreate the table?

 

 

WANTED

reply_id int not null primary key auto_increment

 

ENDED UP WITH

reply_id int not null default '0'

 

Thanks!

[nuxy]

Use this, just make sure you don't already have a primary key that's set to auto.

ALTER TABLE `table` CHANGE `reply_id` `reply_id` INT(10) NOT NULL PRIMARY KEY AUTO_INCREMENT

[fenway]

You can use MODIFY and then you won't have to specify the column name twice.

[Eiolon]

Thanks very much