I am curently running MySql and I have an ID field which is the primary key field, whenever I add new data it auto increments which it is meant to do but recently it has it has jumped up about 20000 is there anyway of making the database re-auto increment the ID numbers for the whole database without having to reenter al the data, please reply if you know the answer, cheers
AUTO INCREMENT
- Thread starter admin
- Start date