Auto_increment

[akravets]

Hello,

If I created a table, but never set AUTO_INCREMENT for my primary key, how can I do this later?
Also, if I have two fields in table: ID and name, if I insert a record into this table: INSERT INTO myTable (ID,name) VALUES( .... what do I need to put for ID in VALUES() so it increment correctly -- ? ?

thanks,
Alex

[stolzyboy]

use the alter statement in a mysql command line

alter table table_name change col_1 col_1 int auto_increment primary key

where col_1 is your column name that you want incremented

[akravets]

when i do: alter table retailerInfo change ID ID int auto_increment primary key; I get error "Multiple primary key defined"

thanks,
Alex

[akravets]

ok, MODIFY instead of ALTER works...

[stolzyboy]

yeah i was going to tell you that, modify can be used in later versions of mysql, forgot to tell you that, sorry

[akravets]

cool, thanks