Python MySQL: error inserting data

Question

Here is my code

qry = " INSERT INTO transactions(transaction_id,listing_id) VALUES ('%s','%s')"
cursor.execute(qry, ('123', '456',))
db_con.commit()

I am getting error:

(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '123'',''456'')' at line 1")

I think that is supposed to be VALUES (%s, %s)

khelwood
– khelwood

2017-03-29 12:50:52 +00:00
Commented Mar 29, 2017 at 12:50 — khelwood
– khelwood, Commented Mar 29, 2017 at 12:50
@khelwood That's correct.

Rafael
– Rafael

2017-03-29 12:52:02 +00:00
Commented Mar 29, 2017 at 12:52 — Rafael
– Rafael, Commented Mar 29, 2017 at 12:52

Martijn Pieters · Accepted Answer · 2017-03-29 12:51:15Z

3

You are using SQL parameters (yay!), and those already take care of proper quoting. You essentially double-quoted your values. Remove the quotes from the query:

qry = " INSERT INTO transactions(transaction_id,listing_id) VALUES (%s,%s)"

answered Mar 29, 2017 at 12:51

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

Comments

user4079229 · Accepted Answer · 2017-03-29 12:57:37Z

0

Remove the double-quoted quotes from the query:

qry = " INSERT INTO transactions(transaction_id,listing_id) VALUES (%s,%s)"

answered Mar 29, 2017 at 12:57

user4079229

Collectives™ on Stack Overflow

Python MySQL: error inserting data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related