python将list导入到mysql

最新推荐文章于 2024-07-21 03:45:16 发布

zhiweiday

最新推荐文章于 2024-07-21 03:45:16 发布

阅读量6.6k

点赞数 2

CC 4.0 BY-SA版权

分类专栏： python 文章标签： python mysql

本文链接：https://blog.csdn.net/l2539469416/article/details/116399114

python 专栏收录该内容

2 篇文章

订阅专栏

数据请看前一篇文章
使用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()