python 读取 txt文本写入mysql_python 读取txt写入mysql-CSDN博客

本文链接：https://blog.csdn.net/qq_37137713/article/details/112745716

本文介绍了一个使用 Python 进行 MySQL 数据库操作的例子，包括从文本文件读取数据并将其插入到 MySQL 数据库中。该过程涉及打开指定路径的文本文件、逐行读取并解析数据项、将这些数据项存储在不同的列表中以及最后将它们写入数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import mysql.connector

titlelist = []
backCateNamelist = []
phonelist = []
addresslist = []
avgpricelist = []
avgscorelist = []
def readtxt():
txtfile = open(‘D:\picture\myhuoguo.txt’,‘r’,encoding=‘utf-8’)
line = txtfile.readline()
#######
while line:
content = line.split()
title = content[0]
backCateName = content[1]
phone = content[2]
address = content[3]
avgprice = content[4]
avgscore = content[5]
######
titlelist.append(title)
backCateNamelist.append(backCateName)
phonelist.append(phone)
addresslist.append(address)
avgpricelist.append(avgprice)
avgscorelist.append(avgscore)
######
line = txtfile.readline()
txtfile.close()

def writemysql():
mydb = mysql.connector.connect(host=“ip”,port=‘3306’,user=“root”,passwd=“psd”,database=“zaizai”)
##########
mycursor = mydb.cursor()
count = len(open(‘D:\picture\myhuoguo.txt’,‘r’,encoding=‘utf-8’).readlines())
#print(count)
# mycursor.execute(“create table if not exists vivian (title text not null, backCateName text not null, phone text not null, address text not null, avgprice text not null,avgscore text not null)CHARACTER SET utf8;”)
#######
sqlinsert = “insert into vivian(title,backCateName,phone,address,avgprice,avgscore) values(’%s’,’%s’,’%s’,’%s’,’%s’,’%s’)”
# sqlselect = “select * from demo;”
for i in range(count):
value = (titlelist[i],backCateNamelist[i],phonelist[i],addresslist[i],avgpricelist[i],avgscorelist[i])
mycursor.execute(sqlinsert % value)
mydb.commit()
mydb.close()

readtxt()
writemysql()