Reseed MySQL Primary Key – AUTO_INCREMENT

If you want to reseed your primary key (i.e. change the value of the next primary key generated), use this handy MySQL function:

{code type=php} ALTER TABLE table_name AUTO_INCREMENT = 59446; {/code}

This is useful for when you are starting a new site and you want to disguise that fact. For example, if you sign up a new user and their user_id is 14 it is a giveaway that there are only a maximum of 13 other users.