scrapy批量插入mysql

spider.py

sql='insert into tiebadata(publish_name,publish_time,publish_url,publish_content,comment_content,comment_time,comment_name,keyword,app_name,run_time)VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)'
data=(item['publish_name'], item['publish_time'], item['publish_url'], item['publish_content'], item['comment_content'], item['comment_time'], item['comment_name'], item['keyword'], item['app_name'], item['run_time'])
item['zong']=[sql,data]

items.py

storage_type = scrapy.Field()  # 存储类型
analysis_type = scrapy.Field()  # 解析网站
zong = scrapy.Field()#数据汇总

setting.py

MYSQL_DB_NAME='**'
MYSQL_HOST='**'
MYSQL_USER='**'
MYSQL_PASSW