I have a table in a MySQL database with one column
id, which has
auto_increment and the Primary Key. There's also a Unique constraint in this table, on different columns.
I noticed that when I try to add a record that violates the constraint, the
auto_increment value is still incremented. This seems weird to me, because it just means the value is getting higher while that isn't necessary.
I'm not asking for a way to work around this, but I'm just curious as to why this would be. Is this something that is useful in some cases?
I'm using Mysql 5.5.38-0ubuntu0.14.04.1.