Change what order # to start with

[nrieger]

Hey,

I want to look like i have sold already 13724 orders, not like this would be my first order.

Where in the PHPmyadmin would i change that info to start with another order number other than 1??

 

Thanks in advance.

[Jack_mcs]

You can't just change it that way to do it properly. There are instructions in the Knowledge basehere.

 

Jack

[nrieger]

You can't just change it that way to do it properly. There are instructions in the Knowledge basehere.

 

Jack

 

 

I tried importing the file to change to another number.

This is what im getting.

 

SQL query:

 

ALTER TABLE osc_orders AUTO_INCREMENT =1245

 

MySQL said: Documentation

#1146 - Table 'db138094422.osc_orders' doesn't exist

[ Back ]

 

Please help, and guide me step by step. I dont want to touch the DB if i dont know what im doing.

[Jack_mcs]

Try it again but use

ALTER TABLE orders AUTO_INCREMENT =1245

Also, before you make any changes to the database, you should always go to admin->tools and do a backup. That way, if anything goes wrong you will be covered.

 

Jack

[nrieger]

Try it again but use

ALTER TABLE orders AUTO_INCREMENT =1245

Also, before you make any changes to the database, you should always go to admin->tools and do a backup. That way, if anything goes wrong you will be covered.

 

Jack

 

Jack

 

Thanks so much!!! You are the MAN...

 

Nat