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

Question

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

Learn to use parameters and never have a problem like this again! — Gordon Linoff
– Gordon Linoff, Commented Jul 15, 2020 at 17:58
Are you sure that's the right paramstyle for the library you're using? — jonrsharpe
– jonrsharpe, Commented Jul 15, 2020 at 17:58
sql = """SELECT password FROM players WHERE username = %s """ res = cursor.execute(sql, usern) print (res) gives me same error — Ashwin DS
– Ashwin DS, Commented Jul 15, 2020 at 18:02
replace comma with '%', like "SELECT password FROM players WHERE username = %s" % usern — kofemann
– kofemann, Commented Jul 15, 2020 at 18:02

kofemann · Accepted Answer · 2020-07-16 06:16:58Z

3

The parametrized queries expect a tuple as an argument:

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

edited Jul 16, 2020 at 6:16

answered Jul 15, 2020 at 18:10

kofemann

4,4831 gold badge38 silver badges43 bronze badges

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

3 Comments

jonrsharpe Over a year ago

Note that's not a tuple.

kofemann Over a year ago

Why not? Tuple can have only one member.

jonrsharpe Over a year ago

They can indeed, but that's not the syntax for it. The comma is the important part of the tuple, a one-tuple looks like (value,).

Collectives™ on Stack Overflow

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

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related