如何从python mysql查询中转义％ [英] How do I escape % from python mysql query

问题描述

如何从python中的mysql查询中逸出％.

How do I escape the % from a mysql query in python.

例如

query = """SELECT DATE_FORMAT(date_time,'%Y-%m') AS dd
FROM some_table
WHERE some_col = %s
AND other_col = %s;"""

cur.execute(query, (pram1, pram2))

给我一​​个"ValueError:不支持的格式字符'Y'".

gives me a "ValueError: unsupported format character 'Y'" exception.

如何使mysqldb忽略％?在任何文档中都看不到.

How do I get mysqldb to ignore the %? Can't see this in any of the docs.

推荐答案

直接转义. rel ="noreferrer">文档:

Literal escaping is recommended by the docs:

请注意，传递给execute()的查询字符串中的任何文字百分号都必须转义，即%%.

Note that any literal percent signs in the query string passed to execute() must be escaped, i.e. %%.

这篇关于如何从python mysql查询中转义％的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！