add auto_increment to a row when table is already created

[futrose]

I have already created my table and I forgot to add AUTO_INCREMENT to my ID row.  I can't seem to find the SQL command to put it in.  I think it is something like

alter table elders modify extra auto_increment...

I'm not sure how to specify that it should only add it to the ID row and not all of them.

By the way I'm using the command line, I don't have phpmysqladmin installed at the moment.

Thanks.

[bh]

You have to modify the column:

ALTER TABLE table_name MODIFY COLUMN column_name INT AUTO_INCREMENT;

 

[futrose]

worked beautifully... Thanks a lot.