join auto increment result in mysql code example

Example: mysql add auto increment id existing table

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