If your table has already been created with an auto-increment. so you can use
ALTER TABLE tbl AUTO_INCREMENT = 1000;
otherwise put the AUTO_INCREMENT = 1000;
in your CREATE TABLE
it goes before the final
);
If your table has already been created with an auto-increment. so you can use
ALTER TABLE tbl AUTO_INCREMENT = 1000;
otherwise put the AUTO_INCREMENT = 1000;
in your CREATE TABLE
it goes before the final
);