asked on
Starting number in MYSQL auto inc field
If someone inserts a record it starts at 1 and then every record there increases by one automatically so, 2, 3, 4 and so on. Is there a way to make it start at 17589 and then just auto inc from there ie: 17589 then next record will be 17590 and so on. If i try type 17589 as a default value for this column in the table it gives me an error and won't let me save it like that.
PHPMySQL Server
Last Comment
Vampireofdarkness
ASKER
It is a primary key though and won't let me do that?
Or another option
Run the following query:
SET insert_id = 17589;
INSERT INTO tablename VALUES ('blah', '...');
This will add the next record into as 17589.
The SET insert_id = #(where # is the next auto increment value you want to use) will reset the next auto increament value, the next query(INSERT) you run will use your choice of value.
Run the following query:
SET insert_id = 17589;
INSERT INTO tablename VALUES ('blah', '...');
This will add the next record into as 17589.
The SET insert_id = #(where # is the next auto increment value you want to use) will reset the next auto increament value, the next query(INSERT) you run will use your choice of value.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Ben