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 fields are controlled by the database, and should NEVER be altered by human hands.
They are used to identify records inside the database operations, and should never be displayed to the end-users in the first place.
