create table table_name
(
id int not null auto_increment,
primary key (id)
)
auto_increment = 1001
- Original Message -
From: "Steve Maroney" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 28, 2001 6:59 AM
Subject: [PHP] Not PHP but MYSQL
Sorry for the OT, but im trying to figure out something with mysql and
need some help.
Does anyone know how set the auto_increment value to some other number
than 0. I have an order_number coloumn and I want to start it at 1000.
So the first record would 1001.
Thank you,
Steve Maroney
2 matches
Mail list logo