title: insert multiple rows in sqlite (with autoincrementing id numbers)
body: <p>I was most pleased to find <a href="https://stackoverflow.com/questions/1609637/is-it-possible-to-insert-multiple-rows-at-a-time-in-an-sqlite-database">this</a> technique, but using it seems to prevent me from having auto-incrementing id values in the rows.</p>
  
  <p>Is the only way to have id values to type them in the lines myself?</p>
  
  <pre><code>$db.execute("
                INSERT INTO 'students'
                SELECT 'Brett' AS 'first_name', 'Iton' AS 'last_name', 'M' AS 'gender', '1966-01-17' AS 'birthday', '415-879-54451' AS 'phone', DATETIME('now') AS 'created_at', DATETIME('now') AS 'updated_at'
          UNION SELECT 'Lady','Gaga', 'F', '1970-03-17', '213-879-4545', DATETIME('now'), DATETIME('now')
          UNION SELECT 'Former','Prince', 'F', '1966-04-17', '321-879-4545', DATETIME('now'), DATETIME('now')
              ")
  </code></pre>