Guest Posted September 20, 2005 Posted September 20, 2005 Hi guys, I'm ready to upload my shop. I just need to adjust the order_id (I want it to start at 1000). I went to my PHP Admin and did this query: ALTER TABLE orders AUTO_INCREMENT=1000 . OK. Query done... now I go and make an order... the id for my order is 1 instead 1000... If I do the query again and other order... then order_id = 2 and so on... I'm using MySQL 4.0.24-standard-log (InnoDB Engine) Help is appreciated. Thanks!
Guest Posted September 20, 2005 Posted September 20, 2005 Figured out! InnoDB engine doesn't support setting directly auto_increment. The workaround is insert a dummy row in orders with orders_id = 999. Thanks for reading guys! Sorry for posting! :blush:
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.