I believe it is CREATE TABLE{ id AUTOINCREMENT=1000, fld TYPE }
HTH JFernando ** sql ** -----Original Message----- From: Martin Skjöldebrand [mailto:[EMAIL PROTECTED]] Sent: December 27, 2002 16:34 To: MySQL epostlista Subject: start value in table Sorry for this newbie question (my MySQL-book is at work). I want my ID field to start with value 1000 and (preferably) auto-increment to 2000 is this possible to specify in my table somehow? (I know auto-increment, just how do I set the starting value). What would the appropriate SQL-sentence to update the table be? Cheers, Martin S. -- Martin Skjoldebrand http://www.skjoldebrand.org --------------------------------------------------------------------- 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