auto_increment problem

admin

Administrator
Staff member
HI folks,
I have a script that inserts 6 records into a MySQL DB with an auto_increment field.

When I run a function that DELETES all 6 records and then inserts them again I get an odd result:

The auto_inc values are *not* 1-6 as you would expect but like this
11
10
9
8
7
12

Why?

Cheers

Nick
 
Back
Top