title: MySQL Transaction/Commit Query
body: <p>Just a quick question which I need to ask, my MYSQL table is using MYISAM storage engine and looking at some previous questions they say queries under this engine are automatically committed (No transactions allowed only auto-commit).</p>
  
  <p>Now, does that mean, if I do the following query:</p>
  
  <pre><code>UPDATE `ExampleTable` SET `ExampleField` += '50' WHERE ...; 
  UPDATE `ExampleTable2` SET `ExampleField2` -= '50' WHERE ...;
  </code></pre>
  
  <p>It will either succeed (and autocommit/update both) or fail and update neither?</p>
  
  <p>Or is my definition of query incorrect and MYISAM will only autocommit one command at once? -So I cannot do the above query reliably under MYISAM?</p>
  
  <p>(Bonus question) If so, I have heard of INNODB engine which supports transactions. could I use that instead? How much speed would I be losing in return for reliable queries?</p>
  
  <p>Thanks for any help.</p>