Change order ID value

[ianric]

Hi

 

I want to change my order_id to something higher. I have read posts and in the tips & tricks it says use

alter table osc_orders auto_increment = 1000;

 

but what it doesn't say is are the next id's 2000, 3000, 4000 because the increment is set to 1000 or if I change 1000 to 63, does it go up in 63s?

 

Thanks

 

Ian

[Velveeta]

Hi

 

I want to change my order_id to something higher. I have read posts and in the tips & tricks it says use

alter table osc_orders auto_increment = 1000;

 

but what it doesn't say is are the next id's 2000, 3000, 4000 because the increment is set to 1000 or if I change 1000 to 63, does it go up in 63s?

 

Thanks

 

Ian

 

It should increment by 1 no matter what you set it to, what you're setting there is the base value that it increments from, not the increment steps...

 

Richard.