擅长:python、mysql、java
<p>你不可能把这个分开吗?例如,您可以这样做:</p>
<pre><code>import urllib2
def main():
# omitted all the connection stuff...
query = "INSERT INTO metadb (name, type , year ) values ( %s, %s, %d)"
params = (escape_string("Valentine's day"), "movie", 2010)
cursor.execute(query, params)
def escape_string(str):
return urllib2.quote(str).replace("%","%%")
if __name__ == "__main__":
main()
</code></pre>
<p>然后选择您必须从文档中转义字符串:</p>
<p>请注意,传递给execute()的查询字符串中的任何文字百分号都必须转义,即%%</p>
<p><a href="https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html" rel="nofollow">https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html</a></p>
<p>希望对你有帮助。你知道吗</p>
<p>//丹尼尔</p>