title: Sqlite dynamic column names
body: <p>I have the following Sqlite setup trying to update <code>Tablename</code> table with  <code>Keys</code> items as both column name and value 
  The problem is that i want to add all <code>items</code> into single record where <code>Name</code> doesn't change but <code>Items</code> change to take all <code>Items</code> in <code>Keys</code></p>
  
  <p>My code will do this over for loop but with multiple records , All i want is a single records with all <code>Items</code></p>
  
  <pre><code>Keys=['a','b',etc]
  Tablename='Asfoor'
  Name='Deek'
      for item in keys:
          data=[Name,Item]
          cur.executemany("INSERT INTO "+Tablename+" (Name,"+Item+") VALUES(?,?)",(data,))
  </code></pre>
  
  <p>Complete code :</p>
  
  <pre><code>import sqlite3
  import sys
  tablename='asfoor'
  table_data=['Name','a','b','c']
  
  try:
      con = sqlite3.connect('dbtrials.db')
      cur = con.cursor()
      cur.execute("DROP TABLE IF EXISTS "+tablename+"")
      cur.execute("CREATE TABLE "+tablename+" (ID INTEGER PRIMARY KEY AUTOINCREMENT ,Name TEXT, "+table_data[1]+" TEXT, "+table_data[2]+" TEXT, "+table_data[3]+" TEXT )")
  
      keys=['a','b','c']
  
      name='deek'
      for item in keys:
          data=[name,item]
          cur.executemany("INSERT INTO "+tablename+" (name,"+item+") VALUES(?,?)",(data,))
      cursor = cur.execute("select * from "+tablename+" ")
      for row in cursor  :
            print(row)
  
  
  except sqlite3.Error as e:
  
      print ("Error %s:" % e.args[0])
      sys.exit(1)
  
  finally:
  
      if con:
          con.close()
  </code></pre>