According to the book I'm working from right now, you can't do this directly. What it suggests is that you insert the first row in your table manually and insert the integer that you want to start at. AUTO_INCREMENT will then use this number as its starting point and continue upwards.
I haven't tried this yet, so I don't know if it works... Gavin Alexander ============================================================ From: [EMAIL PROTECTED] Date: Tue, 27 Aug 2002 06:22:23 -0600 To: [EMAIL PROTECTED] Subject: mysql auto-increment I would like to know if it is possible to configure mysql auo increment feild to start from a specific number or configure it to have a specific character such as a letter inserted infront of it. Thanks " I have no respect for reality as soon as it is acknowledged as such. I am interested in what I can do with unacknowledged reality. " Elias Canetti --------------------------------------------------------------------- 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
