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