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