fre 2002-12-27 klockan 22.34 skrev Martin Skjöldebrand: > 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? > ALTER TABLE `printers` CHANGE `ID` `ID` INT( 11 ) DEFAULT '1000' NOT NULL AUTO_INCREMENT
apparently wont do as I can't have a primary key incremented from a default value of 1000. I am going about this the wrong way, am I not. /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