Re: Auto Increment Fields

Hi Guru, Please note that the appropriate ML for this question is at MySQL. Now: - manually insert a row with id column "999" - manually delete this row - your next auto_increment will be 1000 Note: you should avoid to embed any meaning in an auto_increment field (if that's what you're trying to do). This should be an id, and nothing else. If the use is to make your invoice nb start at 1000 to suggest your company is doing big business, then it's a perfectly legitimate (from a MySQL point of view) use of this trick... HTH Ignatius ____________________________________________ ----- Original Message ----- From: "Guru P Chaturvedi" <bangboy2k2@hotmail.com> To: <php-windows@lists.php.net> Sent: Friday, May 02, 2003 2:04 PM Subject: [PHP-WIN] Auto Increment Fields > Hi there.... > > ho can i create a integer field in a MySQL table that starts with a initial > value 1000 anc increments by 1 further... > > please help me out. > > with Warm Regards, > Guru. > --------------------------------------- > Phone: (+91)9845290270 > URL: www.gangarasa.com > Yahoo IM: guru4vedi > MSN: guru4vedi@gangarasa.com > --------------------------------------- > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >