ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT UNIQUE FIRST
SET @auto_increment=0; SELECT @auto_increment := @auto_increment+1 AS `No`;