People, KISS principle!
Please research "Table Options" in 6.5.3 CREATE TABLE Syntax because this can be done when you set up/re-create or ALTER the table, without fuss... Regards, =dn ----- Original Message ----- From: "Peter Dunham" <[EMAIL PROTECTED]> To: "Mike Grabski" <[EMAIL PROTECTED]>; "'Jure Grom'" <[EMAIL PROTECTED]> Cc: "MySQL - List" <[EMAIL PROTECTED]> Sent: 17 January 2002 22:43 Subject: RE: ID in table > It's messy but you can also insert x rows, then delete x rows and the next > row inserted will have id x+1 assuming that you started with 0 rows. > > > ---------------------- > Peter Dunham > Ellipse Media > t. +44 (0)20 8656 0950 > ----------------------- > > -----Original Message----- > From: Mike Grabski [mailto:[EMAIL PROTECTED]] > Sent: 17 January 2002 21:24 > To: 'Jure Grom' > Cc: MySQL - List > Subject: RE: ID in table > > > I believe auto_increment uses the last highest value inserted into the > record. So if your first insert is 1000, it will count up from 1000 there on > after. Correct me if wrong. > > Mike > > -----Original Message----- > From: Jure Grom [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 17, 2002 3:56 PM > To: MySQL - List > Subject: ID in table > > > Is there any way to start Ids in table from some number for exampl 10000 > with function auto_increment and not from 1? > > > > tnx > > jure > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php