Reseed MySQL Primary Key – AUTO_INCREMENT
Last Updated on: September 16, 2022
If you want to reseed your primary key (i.e. change the value of the next primary key generated), you can do it like this:
ALTER TABLE table_name AUTO_INCREMENT = 59446;
This is useful for starting a new site, and you don’t want to leave hints that you have just launched.
For example, if you sign up a new user whose user_id is 3 and they can see it (e.g. in the URL), then they can easily figure out you are new.
This is increasingly important for eCommerce, where customer confidence is essential. Re-seed your invoice/order numbers if they are based on primary keys, and it will look like you have been in business for years.
Yeh, but the most of the readers are using phpMyAdmin.. and they could just click “Operations” -tab .. and set the AUTO_INCREMENT -value.
Good advice, I am personally not a fan of phpMyAdmin. Much prefer to do as much as I can in pure sql.