On October 8, 2002 01:49 am, Gavin Nouwens wrote:
> Hi peoples,
> Just wondering if it's possible with mysql to start an auto-increment field
> at a specified number instead of 0001?
> I could always just code it in php to add another number onto it to get it
> to the right start point, but leaves areas for human error to creep in!
> Any help would be appreciated!
One way to approach this is to manual insert one record with the number you
So, just add a dummy field with an id of "49" for example.. Then the next
record you insert will be "50".
Freelance Software Developer
e-mail [EMAIL PROTECTED]
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php