SQL Account ID

J

JoyRo

New member
Messages
120
Points
0
Location
Netherlands
Emulator
Hello,

Normaly when people make a account on the server the ID goes from 200000 to 200001 etc.
Now i changed 1 account to test to 3000020 and i changed it back now.
Now if there is a new account it keeps counting from 3000021 and up..
Is there a way to set the count back to normal.
Maybe there is a setting in the sql database.

Kind Regards Henry

 
i did it manualy but when it auto creates a account now it continue in the 30000+ range

and not in the 200000

 
@@JoyRo

Every table with AUTO_INCREMENT column (in your case - it's `id`) has it's own AUTO_INCREMENT counter.

Any row insert get this counter go +1.

By inserting row with `id` 3000020, counter went to 3000021.

If you don't have any row with `id` higher than 200001, you can change AUTO_INCREMENT counter back to 200001:

ALTER TABLE `test` AUTO_INCREMENT=200001;


So next row would be created with `id` 200001.

 
Last edited by a moderator:
You must log in or register to reply here.
Back
Top