Hello!!
ALTER TABLE table1 AUTO_INCREMENT = 1000;
That should do it...
You can use that anytime..
Dan
On Tuesday, April 23, 2002, at 12:21 AM, [EMAIL PROTECTED] wrote:
> Hi all,
>
> I'm wondering if there is a way to start an auto-increment field at a
> number
> other than 1. I'm working on
This is more of a MySQL question, but you can set the column default for
the auto_increment column to something other than 1.
Look up the "SET DEFAULT" clause of the table create / alter table
calls.
-Szii
- Original Message -
From: "Dan Swensen" <[EMAIL PROTECTED]>
To: "php" <[EMAIL P