View Single Post
  #29  
Old 03-03-2006, 05:32 AM
 
uiterwyk uiterwyk is offline
 

Member
  
Join Date: Sep 2005
Location: Pennsylvania, United States
Posts: 15
 

Default

If you are running MySQL 5.0 or above, they introduced a new varaible with that called auto_increment_increment that does just what you want. The MySQL command to change it is:
Code:
SET @@auto_increment_increment=10;
(Or whatever other value besides 10 you might want.
__________________
Robert Uiterwyk
www.horseloverz.com
xcart version 4.0.17
(Heavily Modified and loaded with custom MySQL scripts)
Reply With Quote