Problem with incrementing

[thefreebielife]

This is how my "uId" table is set up:

 

<?php ALTER TABLE `users` CHANGE `uId` `uId` INT( 6 ) NOT NULL AUTO_INCREMENT ?> 

 

Currently its in the 7000's but i would like to bring it down to 2, 3, 4.. etc.

 

But whenever I change the last person's uId, the next person who registers still has an uId in the 7000's. I cannot figure this out.

[Wildbug]

From the MySQL manual on ALTER TABLE syntax:

 

To change the value of the AUTO_INCREMENT counter to be used for new rows, do this:

ALTER TABLE t2 AUTO_INCREMENT = value;

 

You cannot reset the counter to a value less than or equal to any that have already been used. For MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum plus one.

[fenway]

But whenever I change the last person's uId, the next person who registers still has an uId in the 7000's. I cannot figure this out.

 

Why on earth are you changing this???????

[thefreebielife]

Because for some reason users are getting the same numbers across 5 db's. Its hard to explain.

[fenway]

Because for some reason users are getting the same numbers across 5 db's. Its hard to explain.

 

Sounds like an auto-increment-increment issue.