title: Is join insert/update on MySQL an atomic operation?
body: <p>In a Mysql database with every table based on InnoDB with Autocommit enabled, will queries with subqueries and/or joins be atomic? </p>
  
  <p>Examples:</p>
  
  <ul>
  <li><p><code>INSERT INTO users SELECT (x,y,z) FROM users, comments WHERE users.id = comments.user_id;</code>  (joins)</p></li>
  <li><p><code>UPDATE users, comments SET users.x = x1 WHERE users.age &gt; 30;</code> (joins)</p></li>
  <li><p><code>UPDATE users, comments SET users.x = x1, comments.y = y1 WHERE users.age &gt; 30;</code> (joins)</p></li>
  <li><p><code>UPDATE users, comments SET users.x = x1, comments.y = y1 WHERE users.id IN (SELECT id FROM users WHERE age &gt; 30);</code> (subqueries)</p></li>
  </ul>