MySQL Auto Increment Columns on TRANSACTION, COMMIT, and ROLLBACK
When using MySQL START TRANSACTION and the decision is made by MySQL to roll back –
In the case that a table had an AUTO_INCREMENT column – does the column get… decremented during the roll back?