@[TOC](pymysql插入数据时出现: pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; ))
在使用爬虫取得数据后使用pymysql插入数据时出现如下错误
pymysql.err.ProgrammingError: (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 'index) values ('李沁挽张若昀','http://www.baidu.com/baidu?cl=3&tn=SE_baidu' at line 1")
多次尝试后发现是由于在mysql中使用index作为字段。
以此作为记录