Add auto increment column in Mysql table

Published On: 2011-11-24

Category: Jargon Jabberwocky

To add an auto increment column `id` to a table named `table`.
ALTER TABLE `table` ADD `id` INT UNSIGNED NOT NULL auto_increment PRIMARY KEY FIRST;