add auto_increment column to existing table mysql
snippet in sql

add auto_increment column to existing table mysql

user4160

ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY

ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT UNIQUE FIRST