creating a table with auto increment mysql code example

Example: mysql add auto increment id existing table

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