Alter Auto_increment Code Example
Example 1: auto_increment mysql
ALTER TABLE User AUTO_INCREMENT = 1; Example 2: alter table auto_increment
ALTER TABLE ALLITEMS CHANGE itemid itemid INT(10)AUTO_INCREMENT PRIMARY KEY;ALTER TABLE User AUTO_INCREMENT = 1; ALTER TABLE ALLITEMS CHANGE itemid itemid INT(10)AUTO_INCREMENT PRIMARY KEY;
Comments
Post a Comment