Variable substitution in SQLite Python

Question

I have the following Python code and it gives me errors when I execute it, the error says

sqlite3.OperationalError: near "%": syntax error

statement = "INSERT INTO %s (%s) VALUES " % (table,columns) + "(%s,%s,%s);"
cur.execute(statement, (index,fullpath,filename))

CL. · Accepted Answer · 2012-12-10 11:29:46Z

2

SQL parameters are handled by the database, not by Python, so the syntax is not necessarily the same as Python's.

In SQLite (and most other databases), parameters are marked with a ?:

statement = "INSERT INTO %s (%s) VALUES (?,?,?);" % (table,columns)
cur.execute(statement, (index,fullpath,filename))

answered Dec 10, 2012 at 11:29

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

thank you it worked, replacing the +"(%s,%s,%s);" with ? did the trick