let old auto_increment value and get new one

admin

Administrator
Staff member
I have a table with an auto_increment field where range of goes from 1 to 1000. I want to set a new range for the id field so that it begins with 2000, without loosing the range before.
See

1-1000....2000
1, 2, 3, ... 1000,2000,2001,2002...

Thanks for any help
 
Back
Top