David A. Desrosiers wrote:
On Tue, 2007-11-27 at 12:51 -0500, Sandy Rozhon wrote:
After deleting a slew of spam registrations, the next User ID will be a high number. Is there a way to reset it to my own value? If so, where is it stored?
ALTER TABLE foo AUTO_INCREMENT = 0;
A little note - this will define the value from which we continue incrementing. So probably you will not want to set it to null. :) Use n+1 (n=last user id) instead of that.