Sunday, April 17, 2005

How to alter mysql table column to AUTO_INCREMENT

mysql> set insert_id=7;
Query OK, 0 rows affected (0.00 sec)

mysql> alter table fixtures modify column id int auto_increment;
Query OK, 7 rows affected (0.01 sec)
Records: 7 Duplicates: 0 Warnings

2 comments:

com2kid said...

Awesomeness, thanks for the tip! :)

Anonymous said...

thank you!!!