Re: auto-increment question
| From: | Dan Brunner | Date: | Tue, 23 Apr 2002 19:13:07 +0000 |
| Subject: | Re: auto-increment question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18763@lists.php.net to get a copy of this message | ||
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, dswensen@merid.org 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 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