>From the MySQL docs: If you delete the row containing the maximum value for an AUTO_INCREMENT column, the value will be reused with an ISAM, or BDB table but not with a MyISAM or InnoDB table. If you delete all rows in the table with DELETE FROM table_name (without a WHERE) in AUTOCOMMIT mode, the sequence starts over for all table types.
So this will depend on your table type and how you do your deletes. http://danconia.org ------------------------------------------------ On Mon, 11 Nov 2002 11:07:53 -0800, "Jessee Parker" <[EMAIL PROTECTED]> wrote: > In my script, I do the following: I insert x amount of records into a MySQL > table, process the information and then delete those records. One of the > columns is an autonumber type so it starts at 1 for instance. In my query > string I use placeholders. Now sometimes the field which is an autonumber > starts out at 1 while other times it starts out at whatever number it left > off at. Is that normal? I use the following: > > # Load into database > $query1 = "insert into data(USER_ID,NAME,etc) values(NULL,?, ?, > ?, ? > , ?,?,?,?)"; > $sth1 = $dbh->prepare($query1); > $rc1 = $sth1->execute($Name,$etc); > > TIA > > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]