CODEWITHSUNDEEP
pythonmysql
Ashwin DS
Ashwin DS

Reputation: 13

Correct syntax to use near '%s' error while selecting data using Python from MySQL database

Running this code

res = cursor.execute("SELECT `password` FROM `players` WHERE `username` = %s", usern)

I get this error:

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 '%s' at line 1

Upvotes: 1

Views: 2775

Answers (1)

kofemann
kofemann

Reputation: 4413

The parametrized queries expect a tuple as an argument:

query = """SELECT `password` FROM `players` WHERE `username` = %s"""
res = cursor.execute(query, (usern, ))

Upvotes: 3

Related Questions