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


----- Original Message ----- 
From: "Dan Swensen" <[EMAIL PROTECTED]>
Sent: Monday, April 22, 2002 10:21 PM
Subject: [PHP-DB] auto-increment question

> 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 a table meant to store large amounts of users, 
> each with their own unique ID, but my employer wants the UIDs to be a four-
> digit number, rather than starting at 1 -- but they still need to auto-
> increment. Can this be done, or do I need to find a workaround (and if so, 
> can anyone suggest anything?)
> Thanks in advance,
> Dan
> -- 
> PHP Database Mailing List (
> To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to