Does PyMySQL support Prepared Statements?

Question

Does PyMySQL support prepared statements? I am trying to connect to MySQL from a python module.

I have checked documentation at http://pymysql.readthedocs.io and didn't find anything useful.

No luck on skimming the source code either.

score 3 · Answer 1 · edited Dec 18 '17 at 14:42

3

PyMySQL does not support prepared statements yet. See PyMySQL issue 202

edited Dec 18 '17 at 14:42

Chirag Maliwal

answered Dec 18 '17 at 12:02

Daniel Milde

score 0 · Answer 2 · answered Jan 18 '21 at 12:38

0

No support for Prepared Statements will ever come to PyMySQL, I guess. Use Oracle's MySQL Connector for this. https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursorprepared.html

answered Jan 18 '21 at 12:38

akamac

score -2 · Answer 3 · answered Jun 17 '20 at 04:32

-2

The above answer is outdated: PyMySQL does now support prepared statements:

cur = con.cursor()

cur.execute("SELECT * FROM cities WHERE id=%s", myid) 

cid, name, population  = cur.fetchone()

Regards!

answered Jun 17 '20 at 04:32

sdsc81

3

WARNING: THIS IS WRONG. This does not use mysql prepared-statements, but rather it is native python string formatting. (i looked in the source code) – thelogix Feb 02 '21 at 14:16

3 Answers3