mysql change auto_increment code example
Example 1: mysql alter column auto increment
ALTER TABLE document MODIFY COLUMN document_id INT auto_increment
Example 2: mysql set id auto increment
ALTER TABLE users AUTO_INCREMENT=1001;
Example 3: mysql change innodb to myisam
ALTER TABLE table_name ENGINE = MyISAM;
Example 4: mysql update auto
ALTER TABLE tbl AUTO_INCREMENT = 100;
Example 5: mysql add auto increment id existing table
ALTER TABLE `users` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY