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