Guest Posted July 6, 2006 Posted July 6, 2006 Hi Probably one of the more simple questions. All i need to do is change the order number to start at 100000 rather than 1. At the moment the next order will have an order number of 5, if i can make this 100005 (for example, that'd be grand. Thanks in advance. Pete
Guest Posted July 6, 2006 Posted July 6, 2006 execute the following query ALTER TABLE `orders` AUTO_INCREMENT =100005
Guest Posted July 6, 2006 Posted July 6, 2006 Excellent Done that and its worked a treat. Cheers enigma1
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.