title: sqlite3.programmingerror incorrect number of bindings supplied
body: <p>Python 2.7 and sqlite3</p>
  
  <p>I create a table like this:</p>
  
  <pre><code>#create table
  connector.execute('''CREATE TABLE mytable (
  column1,
  column2,
  column3
  ''')
  </code></pre>
  
  <p>Then I iterate through a <code>.csv</code> file like this:</p>
  
  <pre><code>with open("mycsv.csv") as f:
  for i in f:
      del splitted[:]
      del myData[:]
      splitted = i.split(",")
      for j in splitted:
          myData.append(tuple([j]))
  </code></pre>
  
  <p>which gives me this output:</p>
  
  <pre><code>print myData
  &gt; [('testtext1',), ('testtext2',), ('testtext3\n',)]
  </code></pre>
  
  <p>However, when I try to insert this into my <code>db</code> like so:</p>
  
  <pre><code>connector.executemany('''INSERT INTO mytable (
      column1,
      column2,
      column3
      ) VALUES (
      ?,?,?)''', myData) 
  </code></pre>
  
  <p>I get the error</p>
  
  <blockquote>
    <p>sqlite3.programmingerror incorrect number of bindings supplied. The
    current state uses 3, and tehre are 1 supplied.</p>
  </blockquote>