SYNTAX ERROR in python sqlite3 INSERT statement

Question

I have been writing a small program for data entry and have been very frustrated because of a simple error. I am unable to figure it out. The Query is as follows:

query1= """
'INSERT INTO general_demographic 
(serial_number,district,mprpmu,ward,telephone,name,age,occupation,education)
VALUES(?,?,?,?,?,?,?,?,?)',
(str(SerialNumber.get()),
str(District.get()),
str(mprmmu.get()),
str(ward.get()),
str(telephone.get()),
str(name.get()),
str(age.get()),
str(occupation.get()),
str(c.get()))
"""

The error displayed is shown in the figure below: error

Please edit your question and paste the error message as text. — Selcuk
– Selcuk, Commented Sep 17, 2019 at 5:24

Trapli · Accepted Answer · 2019-09-17 09:39:08Z

1

Your query is invalid but you are on the right track.

Instead of q = "'SQL (?) ', param_tuple" you should do more like this:

q = "SQL (?)"
valz = param_tuple
cursor.execute(q, valz)

Actually the documentation of parameter substitution is quite good.

There are many examples here too.

edited Sep 17, 2019 at 9:39

answered Sep 17, 2019 at 5:57

Trapli

1,6272 gold badges17 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

SYNTAX ERROR in python sqlite3 INSERT statement

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related