mysql alter table set id auto increment mssql code example

Example: mysql add auto increment id existing table

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