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