CREATE TABLE table_name (ID INT NOT NULL AUTO_INCREMENT = 10000 PRIMARY KEY, ... ); ---John Holmes... > -----Original Message----- > From: Gavin Nouwens [mailto:gnouwens@zip.com.au] > Sent: Monday, October 07, 2002 9:50 PM > To: php-db@lists.php.net > Subject: Auto Increment > > 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. > > > -- > 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
