title: START TRANSACTION and COMMIT not working in separate queries in MySQL
body: <p>When I send a multiple line semicolon separated query (i.e. 3 separate queries), it works fine, depending on whether I finish it with a <code>COMMIT</code> or <code>ROLLBACK</code>, it either inserts the values or rolls back. BUT when I enter them in three separate queries, one after another, now that's not gonna work. (I'm using PHP MyAdmin)</p>
  
  <p>The latter would have to make more sense, as I think this the whole point in transactions, to send queries in a session (transaction) and deciding only at the end whether we want to run them or discard changes to the table.</p>
  
  <p><code>START TRANSACTION;
  INSERT INTO x VALUES ('y');
  COMMIT;</code></p>