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