set auto_increment value mysql 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;ALTER TABLE users AUTO_INCREMENT=1001;ALTER TABLE ALLITEMS CHANGE itemid itemid INT(10)AUTO_INCREMENT PRIMARY KEY;