title: sqlite3: multiple updates in one transaction
body: <p>I've learned how to put multiple INSERTs into one transaction using SELECT UNION as in this example</p>
  
  <pre><code>var newQuery = true, query = '';
  for (i=0; i&lt;locations_length; i++) {
      if (newQuery) {
          query = 'INSERT INTO myTable (id, name, code)';
          newQuery = false;
      }
      else {
          query += ' UNION';
      }
  
      query += ' SELECT "'+values[i][0]+'", "'+values[i][1]+'", "'+values[i][2]+'"';
  
      if (i!=0 &amp;&amp; i%499==0) {
          db.execute(query);
          newQuery = true;
      }
  }
  </code></pre>
  
  <p>but it doesn't seem to work for multiple UPDATEs.</p>
  
  <p>Is there any way I can put multiple UPDATEs into one transaction?</p>
  
  <p>Also, is there a way to put mixture of INSERTs and UPDATEs into one transaction?</p>
  
  <p>I'm working with Python 2.7 by the way.</p>
  
  <p>Thank you so much in advance.</p>