SQL location for last created "order number"?

[HerrJones]

Can anyone point me to the location (table, etc) where the last created order number is stored?

 

Our new store currently generates order numbers starting at '1' which seems a bit silly towards the customer. We would like to reset it and have it start at 10,000 or so for the next placed order.

 

Best,

 

HJ

[♥Monika in Germany]

Can anyone point me to the location (table, etc) where the last created order number is stored?

 

Our new store currently generates order numbers starting at '1' which seems a bit silly towards the customer. We would like to reset it and have it start at 10,000 or so for the next placed order.

 

Best,

 

HJ

 

alter table orders auto_increment = 123456;

 

change it to your favorite number and run this in phpmyadmin

[HerrJones]

alter table orders auto_increment = 123456;

 

change it to your favorite number and run this in phpmyadmin

 

Thank you very much!

 

HJ