title: How to insert a list of lists into SQLite with executemany
body: <p>I'm trying to insert a lot of rows into a sqlite table and so am seeking to use <code>executemany</code>.</p>
  
  <p>I have a setup like this:</p>
  
  <pre><code>data_list = [['apples',10,'red'],['bananas',5,'yellow']]
  
  dbc.executemany('
     insert into table
     (fruit, colour)
     values
     (?,?)',
     (data_list[0],data_list[2]))
  </code></pre>
  
  <p>As you can see, I don't want everything from the <code>data_list</code>, in this case, I don't want the number.</p>
  
  <p>The problem is, I get this error despite the fact I specified which items from the list to use:</p>
  
  <p><code>sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 2, and there are 3 supplied.</code></p>
  
  <p>How do I get my data into sqlite using executemany? I really don't want to have to massage the data into the correct length (and order?) list - is there a better way?</p>