mysql set auto increment alter table code example

Example 1: mysql alter column auto increment

ALTER TABLE document MODIFY COLUMN document_id INT auto_increment

Example 2: auto_increment mysql

ALTER TABLE User AUTO_INCREMENT = 1;