SQL query using %s in Python 3.3

Question

I'm trying to retrieve data from a MySQL-database.

A = "James"
query = ("SELECT * FROM DB.tblusers WHERE UserName = %s ")
c = mysql.connector.connect(user='root', password='',
                          host='127.0.0.1',
                          database='DB')
cur1 = c.cursor()
cur1.execute(query, A)

Gives the following error message:

mysql.connector.errors.ProgrammingError: 1064 (42000): 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 '%' at line 1

But the SQL works in the mySQL Workbench. Any ideas?

score 23 · Accepted Answer · 2013-12-29 09:44:48Z

23

A should be a tuple, try with A = ("James",)

see documentation of MySQLCursor.execute(operation, params=None, multi=False)

EDIT: added a comma, thanks to "swordofpain" (I learned something)

edited Dec 29, 2013 at 9:44

answered Dec 28, 2013 at 18:27

user180100

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

1 Comment

Enthuziast Over a year ago

Thanks a lot! Didn't work "alone", but added another criteria (department) and then it's ok.

Collectives™ on Stack Overflow

SQL query using %s in Python 3.3

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