代码如下:
# -*- coding: UTF-8 -*-
import pymysql
connect = pymysql.connect(host="localhost", port=3306, user="root", password="111111", database="wuba",
charset="utf8")
cur = connect.cursor()
#remark=['101','102','103','104','105','106','107','108','109','110']
#name=['诸葛亮','刘备','周瑜','张飞','关羽','吕布','貂蝉','黄忠','马超','典韦']
#conn.executemany("INSERT INTO users(name, remark) VALUES(?,?)",persons)
json = [{"time": 1605868916, "kw": "携程"},
{"time": 1605868992, "kw": "丽江"},
{"time": 1605869065, "kw": "c6179"},
{"time": 1605869267, "kw": "丽江景点"},
{"time": 1605869312, "kw": "女童误服近40粒降压药不幸身亡"},
{"time": 1606112160, "kw": "python爬虫请求头"},
{"time": 1606112420, "kw": "useragent"},
{"time": 1606112494, "kw": "手机useragent"},
{"time": 1606112849, "kw": "谷歌浏览器useragent"},
{"time": 1606114944, "kw": "百度贴吧"}]
#data=((remark[i],name[i]) for i in range(0,len(remark)))
data =((json[i]['time'],json[i]['kw']) for i in range(0,len(json)))
sql='INSERT INTO users(name, remark) VALUES(%s,%s)'
cur.executemany(sql,data)
connect.commit()
cur.close();
connect.close();