python数据库特殊字符转义_Python MySQL转义特殊字符

我使用python在MySQL中插入一个带有特殊字符的字符串。

要插入的字符串如下所示：macaddress_eth0;00:1E:68:C6:09:A0;macaddress_eth1;00:1E:68:C6:09:A1

下面是SQL：UPGRADE inventory_server

set server_mac = macaddress\_eth0\;00\:1E\:68\:C6\:09\:A0\;macaddress\_eth1\;00\:1E\:68\:C6\:09\:A1'

where server_name = 'myhost.fqdn.com

当我执行更新时，会出现以下错误：ERROR 1064 (42000):

You have an error in your SQL syntax; check the manual that corresponds to your

MySQL server version for the right syntax to use near 'UPGRADE inventory_server

set server_mac = 'macaddress\_eth0\;00\:1E\:68\:C6\:09\' at line 1

python代码：sql = 'UPGRADE inventory_server set server_mac = \'%s\' where server_name = \'%s\'' % (str(mydb.escape_string(macs)),host)

print sql

try:

con = mydb.connect(DBHOST,DBUSER,DBPASS,DB);

with con:

cur = con.cursor(mydb.cursors.DictCursor)

cur.execute(sql)

con.commit()

except:

return False

如何原始插入此文本？