Posted on April 6th, 2009 at 08:01 PM by Corey Ballou
The MySQL 5.0 reference manual has very specific guidelines as to how auto incrementing is handled within the InnoDB storage engine. This can cause problems for individuals who have improperly created their tables. Perhaps you have made the following mistake and didn’t catch the error. I’ll demonstrate a simple way to create a table utilizing a composite key which will effectively trigger ON DUPLICATE KEY UPDATE on an INSERT statement. more »
