Jump to content
  • 0
Sign in to follow this  
JoyRo

SQL Account ID

Question

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

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

@@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 by Nebraskka

Share this post


Link to post
Share on other sites
  • 0

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

and not in the 200000

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.