The correct behavior is the number starting at the last number used. If you are using MyISAM tables, you should see this behavior. If you are using the old style ISAM tables, it will restart at 1 every time.
j----- k----- On Monday 11 November 2002 11:41, Jessee Parker wrote: > I have a script that inserts records into a MySQL table, does the > processing and > then deletes those records. The field name that is autonumber is called > BID. When I run the script again, the BID will sometimes start out at 1 and > other times it will start at the last number. What is the correct > behavior?? TIA > > Jessee -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 --------------------------------------------------------------------- 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
