python将list导入到mysql
数据请看前一篇文章使用pymysql库连接mysql数据库import pymysqlfrom excle.xls import MyList# 链表数据list=[]file_name = "school.xls"lists = MyList.getList(file_name)# 连接数据库conn = pymysql.connect(host='localhost',user='root',
·
数据请看前一篇文章
使用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()
执行结果
完
更多推荐
已为社区贡献1条内容
所有评论(0)