python MySQL : error inserting data

Question

这是我的代码

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

我遇到错误:

(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")

Answer 1

您正在使用 SQL 参数(耶!)，那些已经处理了正确的引用。您基本上用双引号引用了您的值(value)观。从查询中删除引号:

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