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 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
