mysql set primary key auto_increment value code example

Example 1: mysql set id auto increment

ALTER TABLE users AUTO_INCREMENT=1001;

Example 2: alter table auto_increment

ALTER TABLE ALLITEMS CHANGE itemid itemid INT(10)AUTO_INCREMENT PRIMARY KEY;