python 批量往数据库导入数据

代码如下：

# -*- 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();