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
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