title: Will these two sql transactions deadlock? (/Resolve with 1 rollback)
body: <p>Say I had a purchase transaction doing something like this:</p>
  <pre><code>START TRANSACTION;
  UPDATE `USER` SET `Money` = `Money - '100';
  UPDATE `ITEMS` SET `Item` = `Item` + '1';
  COMMIT;
  </code></pre>
  <p>And unfortunately at the same time a cron ran, giving interest on everyone's existing balance:</p>
  <pre><code>UPDATE `USER` SET `Money` = `Money` + '50';
  </code></pre>
  <p>(either wrapped in a transaction or just a single autocommit)</p>
  <p>Would that cause a deadlock in any case? (Which may be resolved by a rollback of one by the dbms).</p>