SQL Account ID

[JoyRo 5]

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

[Nebraskka 4]

@@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.

Edited March 31, 2016 by Nebraskka

[Legend 43]

usually if i do changes in the sql, i did it manually.

[JoyRo 5]

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

and not in the 200000

[JoyRo 5]

thanx found it! 
Mine sql is in dutch so had to search abit ^^