[PHP-DB] auto-increment question

2002-04-23 Thread Dan Swensen
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

Re: [PHP-DB] auto-increment question

2002-04-23 Thread szii
] 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

Re: [PHP-DB] auto-increment question

2002-04-23 Thread Dan Brunner
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 a