You could consider to use zerofill, this would create ID's like 0001 0002
0003 etc.

-----Ursprüngliche Nachricht-----
Von: Dan Swensen [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 23. April 2002 7:22 AM
An: php
Betreff: [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



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to