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