mysql set auto increament code example

Example: mysql add auto increment id existing table

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