title: How to insert data from a list to SQLite3 Database
body: <p>This is a list below imported the data from qwidgets.</p>
  
  <pre><code>list = ['2020/02/21', 'name', 'location', 'item1', 'item2', 'item3', 'item4', 'item5']
  </code></pre>
  
  <p>or</p>
  
  <pre><code>list = ['2020/02/21', 'name', 'location', 'item1']
  </code></pre>
  
  <p>or</p>
  
  <pre><code>list = ['2020/02/21', 'name', 'location', 'item1', 'item2', 'item3']
  </code></pre>
  
  <p>How to insert this list data in to SQLite3 database. I am using below database structure. </p>
  
  <pre><code>conn = sqlite3.connect('test.db')
  conn.execute("INSERT INTO \
      maintable(date,name,location,item1,item2,item3,item4,item5,item6, item7,item8, item9, item10) \
      VALUES ('{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}', '{}')
  </code></pre>