how auto increment works in mysql at insert code example

Example: mysql add auto increment id existing table

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