Python批量读取csv文件数据，存入mysql

 一、检测文件夹csv路径

import glob

csv_list = glob.glob(r'test\*.csv') 

print(csv_list)

 二、读取每一个csv文件数据

for i in csv_list:  
    filePath = i
    data = []
    with open(filePath,'r',encoding="utf-8") as f:
        reader = csv.reader(f)
        for row in reader:
            data.append(row)

    f.close()

 三、连接mysql数据库

import pymysql as mysql

conn = mysql.connect(host="localhost",port=3306,user="root",
                     passwd="123456",db="test",charset="utf8mb4")
mycursor = conn.cursor()
print("连接成功")

data = ['XX']

sql = "INSERT INTO test (name,user) \ VALUES (%s,%s)"
mycursor.executemany(sql,data)

conn.commit()
mycursor.close()

可参考完整程序 ：

​​​​​批量读取csv数据，写入mysql-MySQL文档类资源-CSDN下载