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!
> -gav.


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".

Mark Nenadov,
Freelance Software Developer
web: www.freelance-developer.com

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to