import pymysql
import time
conn = pymysql.connect( host='localhost', user='root',password='123456',db='db',charset='utf8')
cur = conn.cursor()
def run():
# 批量插入方法
s = time.time()
data_list = [(i,j) for i in range(1000) for j in range(10000)]
sql = "insert into auth_group (name,age) values(%s,%d)"
total_count = cur.executemany(sql, data_list)
conn.commit()
cur.close()
conn.close()
e = time.time()
print(total_count)
print(e - s)
if __name__ == '__main__':
run() # 166.7s
最后插入2个字段1000万条数据大概用时166.7s,小伙伴对这个速度满意吗?