import pymysql# 1. 组织数据data_list = []for i in zip(chinese_names_list,english_names_list,numbers_list,locations_list,heights_list,weights_list,ages_list,qiu_lings_list): data_list.append(i)# 2. 连接数据库db = pymysql.connect(host='localhost',user='root', password='123456',port=3306, db='demo', charset='utf8')# 创建一个游标对象；cursor = db.cursor()# 3. 插入数据sql = 'insert into nba(chinese_names_list,english_names_list,numbers_list,locations_list,heights_list,weights_list,ages_list,qiu_lings_list) values(%s,%s,%s,%s,%s,%s,%s,%s)'try: cursor.executemany(sql,data_list) db.commit() print("插入成功")except: print("插入失败") db.rollback()db.close()切尔西赛事分析
