alter table auto increment 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;
Example 3: how to alter auto increment in sql
INSERT INTO Persons (Personid,FirstName,LastName)
VALUES (seq_person.nextval,'Lars','Monsen');