用于 MySQL 的转义字符串 Python
我使用 Python 和 MySQLdb 下载网页并将它们存储到数据库中.我的问题是我无法在数据库中保存复杂的字符串，因为它们没有正确转义.
I use Python and MySQLdb to download web pages and store them into database. The problem I have is that I can't save complicated strings in the database because they are not properly escaped.
在 Python 中是否有一个函数可以用来为 MySQL 转义字符串?我尝试使用 '''(三重单引号)和 """，但没有用.我知道 PHP 有 mysql_escape_string()代码>，在 Python 中有类似的东西吗?
Is there a function in Python that I can use to escape a string for MySQL? I tried with ''' (triple simple quotes) and """, but it didn't work. I know that PHP has mysql_escape_string(), is something similar in Python?
谢谢.
推荐答案
conn.escape_string()
参见 MySQL C API 函数映射:http://mysql-python.sourceforge.net/MySQLdb.html
See MySQL C API function mapping: http://mysql-python.sourceforge.net/MySQLdb.html
相关文章