mysql 1064 oython_Python mysql错误#1064

我试图通过编写pipeline将数据存储到MySQL中，但是出现了：_mysql_exceptions.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 'desc,pic)values ('xe4\xbe\x9b\xe5\xba.......' at line 1")

这是我的代码：def __init__(self):

#self.file = codecs.open('tutorial_data.json','wb',encoding='utf-8')

self.dbpool = adbapi.ConnectionPool('MySQLdb',

host = 'localhost',

port = 3306,

db = 'project',

user = 'root',

passwd = '',

cursorclass = MySQLdb.cursors.DictCursor,

charset = 'utf8',

use_unicode = True)

def process_item(self, item, spider):

query = self.dbpool.runInteraction(self._conditional_insert, item)

query.addErrback(self.handle_error)

return item

def _conditional_insert(self,tx,item):

tx.execute(

"INSERT INTO raw (title,area,date,sclass,desc,pic )\

VALUES (%s, %s, %s, %s, %s, %s)",

(item['title'][0],

item['area'][0],

item['date'][0],

item['sclass'][0],

item['desc'][0],

item['pic'][0])

)

我的MySQL版本是5.6.17，MySQL python版本是1.2.5\