Re: Auto Increment Fields

thanks ignatius, well i'm basically from MS SQL and Oracle platform... so was wondering if i can some of those tricks here. anyways this helps me a lot. thanks again... "Ignatius Reilly" <ignatius.reilly@free.fr> wrote in message news:072401c310a3$be0bbda0$0100a8c0@server... > 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 > > > > >