Here is an SQL example of how you do this:
ALTER TABLE table_name AUTO_INCREMENT = 1001
Published: February 1st pm28 1:18pm EstEST
MySQL Auto Increment
If you're launching a store or an online order system there is a good chance that your first order id will be 1. This might not be the best way to ensure confidence in your first hundred or so customers. Instead you can set your order tables AUTO INCREMENT value to something slightly higher.
Here is an SQL example of how you do this:
ALTER TABLE table_name AUTO_INCREMENT = 1001
Here is an SQL example of how you do this:
ALTER TABLE table_name AUTO_INCREMENT = 1001