Python 3 MySQL Syntax Error with Select Parameter

Question

I'm trying to execute the following via Flask's MySQLdb module:

cur.execute("SELECT post_id FROM tbl_post WHERE post_file_path = '%s'", (_filePath,))

Yet I get the following error:

1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'static/uploads/adc67db4-7d23-4bf1-a7ef-7e34dbed246a.jpg''' at line 1"

The query works fine via the command line so I'm fairly certain it's something to do with the way I'm providing my string argument. What am I doing wrong with it?

Eugene Yarmash · Accepted Answer · 2016-03-30 14:00:42Z

2

You shouldn't quote the placeholder %s, it's done by the database driver. This should work:

cur.execute("SELECT post_id FROM tbl_post WHERE post_file_path = %s", (_filePath,))

answered Mar 30, 2016 at 14:00

Eugene Yarmash

152k44 gold badges346 silver badges391 bronze badges

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

1 Comment

Hexodus Over a year ago

Had seen some examples using quotes, but this works perfectly thanks!

Collectives™ on Stack Overflow

Python 3 MySQL Syntax Error with Select Parameter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related