title: Insert into SQLite table by column name?
body: <p>Is there a way to pass a list such as</p>
  <pre><code>PersNr_List = ['00001', '00002','00003']
  </code></pre>
  <p>into the first column of an SQLite table, in this case called 'PersNr'?
  I can SELECT from a column, but can I also pass into a specific column?</p>
  <p>Sorry if that's confusing. Right now I just want to achieve this:</p>
  <pre><code>PersNr    columnName1    columnName2 .....
  00001
  00002
  00003
  00004
  </code></pre>
  <p>I tried looping but couldn't make it work:</p>
  <pre><code>PersNr_List = ['00001', '00002','00003']
  
  for x in PersNr_List: 
      cursor.executemany('INSERT INTO payroll_details VALUES (?)', PersNr_List)
  </code></pre>
  <p>Thanks so much for any help!</p>