title: MySQL Auto Increment Columns on TRANSACTION, COMMIT, and ROLLBACK
body: <p>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? </p>
  
  <p>Or should it?</p>
  
  <p>I am having some issues where the transaction data is being properly rolled back - but it looks like the table was auto incremented and not decremented in the rollback.</p>
  
  <hr>
  
  <pre><code># BOTH TABLES START OUT EMPTY // TABLE1 ID is **auto_increment** 
  
  START TRANSACTION;
  
  INSERT INTO `TABLE1` (`ID` ,`NAME`) VALUES (NULL , 'Ted');  # MySQL TABLE1 **ID** is Auto incremented to 1 
  
  INSERT INTO `TABLE2` (`ID` ,`WRONGVALUE`) VALUES (NULL , 'some value');  # error. This TRANSACTION will not succeed 
  
  COMMIT;  # Because of the error - this TRANSACTION is now rolled back and Ted is NOT added
  </code></pre>
  
  <h2><br /></h2>
  
  <p>Because MySQL will auto_increment the ID on the first table - regardless of if the transaction succeeds or fails - is the standard practice for this to decrement the table yourself?</p>