python将list导入到mysql

数据请看前一篇文章
使用pymysql库连接mysql数据库

import pymysql
from excle.xls import MyList

# 链表数据
list=[]
file_name = "school.xls"
lists = MyList.getList(file_name)

# 连接数据库
conn = pymysql.connect(
    host='localhost',
    user='root',
    password='toor',
    database='campusfleas',
    charset='utf8',
    # autocommit=True,    # 如果插入数据，， 是否自动提交? 和conn.commit()功能一致。
)

cursor= conn.cursor()

# 插入sql语句
sql = "insert into school (schoolId,schoolName,schoolNum,location,level,served) values (%s,%s,%s,%s,%s,%s)"

for list in lists:
    schoolId = int(list[0])
    schoolName = str(list[2])
    schoolNum = str(list[1])
    location = str(list[4])
    level = str(list[5])
    served = str(list[6])
    # 执行插入操作
    insert = cursor.execute(sql,(schoolId,schoolName,schoolNum,location,level,served))
cursor.close()
conn.commit()
conn.close()

执行结果

完