Modify an existing column to make it auto increment.
ALTER TABLE [table name] MODIFY [column] int NOT NULL AUTO_INCREMENT
Make an existing MySQL column auto_increment
Modify an existing column to make it auto increment.
ALTER TABLE [table name] MODIFY [column] int NOT NULL AUTO_INCREMENT
