79514

InnoDB Notes

For InnoDB tables, be careful if you modify the column containing the auto-increment value in the

middle of a sequence of insert statements. For example, if you use an update statement to put a

new, larger value in the auto-increment column, a subsequent insert could encounter a “Duplicate

entry" error. The test whether an auto-increment value is already present occurs if you do a DELETE

followed by morę insert statements, or when you commit the

transaction, but not after an update

statement.