python 向mysql插入数据时有单引号双引号报语法错误的解决

 1064 - 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 '，14-马斯切拉诺，7-迪马利亚(79',17-古铁雷斯)；11-特维斯(69',8' at line 1

解决办法如下：

from pymysql import escape_string
import pymysql


conn = pymysql.connect(host='127.0.0.1', user='*****', password='****', port=3306, db='****',charset='utf8')
cur = conn.cursor()

sql_insert = "INSERT INTO data_thunews_sport (tno,title,tcontent) VALUES ('{}','{}','{}');".format(tno, escape_string(title), escape_string(tcontent))
cur.execute(sql_insert)
conn.commit()
cur.close()
conn.close()

 1、导入escape_string

from pymysql import escape_string

 2、对插入的字段中含有引号的使用escape_string

title = escape_string(title)
tcontent = escape_string(tcontent)