Use:
ALTER TABLE tbl_name AUTO_INCREMENT = 1000;
Note that if you set the auto_increment value and delete rows, the auto_increment value starts from 1 again. Delete the rows first, then set the auto increment value.
Twitter It!
Use:
ALTER TABLE tbl_name AUTO_INCREMENT = 1000;
Note that if you set the auto_increment value and delete rows, the auto_increment value starts from 1 again. Delete the rows first, then set the auto increment value.
Twitter It!