Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 General help me questions
 reset customerid or customer number		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

RomanVictor
Starting Member

USA
1 Posts
Posted - April 22 2009 :  13:21:07  Show Profile  Visit RomanVictor's Homepage  Reply with Quote
I know there is a way to reset the order number using a script but is there a similar facility to set the starting customer number. I am running under MySQL.

Roman Victor, Software Developer
RVPM Designs
8 Coach Ln
Amherst, MA 01002
413 253-6547
www.rvpmdesigns.com

g3nnin
VP-CART Super User

209 Posts
Posted - April 30 2009 :  13:43:30  Show Profile  Reply with Quote
Hi,

I believe you could use the following query:

ALTER TABLE tablename AUTO_INCREMENT = 1

You might want to check this page:

http://www.liewcf.com/blog/archives/2004/04/mysql-reset-auto-increament-number/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty