AutoNumber Question

2002-11-11 Thread Jessee Parker
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

Re: AutoNumber Question

2002-11-11 Thread Joshua J . Kugler
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