Python - SQL: How do I insert these variables into a table in a database?

Question

the program must store these details in a table. I'm new to SQL and would like to know how to insert variables

    c.execute('''INSERT INTO userAcc(name, dob, age) VALUES(%s,%s,%s)'''(name1, dob1, age1))
    conn.commit()
    c.close()
    conn.close()

Please give a proper error description!

Klaus D.
– Klaus D.

2017-09-17 21:06:16 +00:00
Commented Sep 17, 2017 at 21:06 — Klaus D.
– Klaus D., Commented Sep 17, 2017 at 21:06

Christian Gabrisch · Accepted Answer · 2017-09-17 21:07:28Z

2

SQLite does not support the %s syntax as a placeholder (https://docs.python.org/3/library/sqlite3.html). Use question marks instead, and don't forget to insert a comma after the SQL string:

c.execute('''INSERT INTO userAcc(name, genre, artist) VALUES(?,?,?)''', (name1, genre1, artist1))

answered Sep 17, 2017 at 21:07

Christian Gabrisch

1136 bronze badges

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

Collectives™ on Stack Overflow

Python - SQL: How do I insert these variables into a table in a database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related