October 29, 2019

Understanding the Behavior of the AUTO_INCREMENT Column in MySQL

Most of us are familiar with AUTO_INCREMENT, and have used it in at least one context. However, the following behavior is a little tricky, especially when we fail to observe — and most of the time it is not reproducible due to the behavior or MySQL. Consider the table that is created