SQL Insert query from flask not working

Question

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()

I am using Python. The table is created successfully with a column of "name", but I am unable to insert anything.

I get the error:

sqlite3.OperationalError: no such column: sample

Why?

Answer 1

I think you need something like:

INSERT INTO test (name)
VALUES
  ('sample');

Translated into python:

db.execute('INSERT INTO %s (name) VALUES (\'%s\')' % ('test', 'sample'))

Answer 2

You forgot the column name?

db.execute('CREATE TABLE IF NOT EXISTS test (name TEXT)')
print("Table created successfully")
db.execute('INSERT INTO %s (name) VALUES (%s)' % ('test', 'sample')) 
db.close()