Re: auto-increment question

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" <dswensen@merid.org> To: "php" <php-db@lists.php.net> 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 (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php