set foreign_key_checks =0;
ALTER TABLE table_name modify COLUMN id INT auto_increment;
set foreign_key_checks =1;
set foreign_key_checks =0;
ALTER TABLE table_name modify COLUMN id INT auto_increment;
set foreign_key_checks =1;