title: SQL Insert query from flask not working
body: <pre><code>db.execute('CREATE TABLE IF NOT EXISTS test (name TEXT)')
  print("Table created successfully")
  db.execute('INSERT INTO %s VALUES (%s)' % ('test', 'sample'))
  db.close()
  </code></pre>
  
  <p>I am using Python. The table is created successfully with a column of "name", but I am unable to insert anything.</p>
  
  <p>I get the error:</p>
  
  <pre><code>sqlite3.OperationalError: no such column: sample
  </code></pre>
  
  <p>Why?</p>