Python SQLITE insert into not working

Question

So I am trying to get a simple program to insert information into a sqlite db.

The line that is breaking is the cur.execute

sitename = "TEST sitename2"
siteusername = "TEST siteusername2"
sitepasswd = "TEST sitepassword2"
cur.execute("INSERT INTO mytable(sitename, siteusername, sitepasswd) VALUES(%s, %s, %s)", (sitename, siteusername, sitepasswd))

Error that I receive from Python:
sqlite3.OperationalError: near "%": syntax error

Pastebin for complete code: pastebin.com/GF12ty6g

triunenature
– triunenature

2013-09-13 22:38:47 +00:00
Commented Sep 13, 2013 at 22:38 — triunenature
– triunenature, Commented Sep 13, 2013 at 22:38

mechanical_meat · Accepted Answer · 2013-09-13 22:44:58Z

1

You simply have the wrong parameter style.

>>> import sqlite3
>>> sqlite3.paramstyle
'qmark'

Change your code to:

cur.execute("""INSERT INTO mytable(sitename, siteusername, sitepasswd) 
               VALUES (?, ?, ?)""", (sitename, siteusername, sitepasswd))

answered Sep 13, 2013 at 22:44

mechanical_meat

170k25 gold badges237 silver badges231 bronze badges

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

1 Comment

triunenature Over a year ago

Wow that worked! In 3 minutes once it unlocks I will mark this as correct. Thanks so much. Its always the small issues...

Collectives™ on Stack Overflow

Python SQLITE insert into not working

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related