Make an existing MySQL column auto_increment

January 23, 2009
Snippet

Description

Modify an existing column to make it auto increment.

Snippet

ALTER TABLE [table name] MODIFY [column] int NOT NULL AUTO_INCREMENT

Post new comment

The content of this field is kept private and will not be shown publicly.