使用python将多个CSV文件导入mysql

import csv
import os
import pymysql

conn = pymysql.connect(host='数据库主机地址', port=3306, user='用户名', password='密码', db='数据库名', charset='utf8')
cursor = conn.cursor()

create_table_query = '''
CREATE TABLE IF NOT EXISTS 表名 (
    列1 数据类型,
    列2 数据类型,
    ...
)
'''
cursor.execute(create_table_query)

csv_folder = 'CSV文件夹路径'
for filename in os.listdir(csv_folder):
    if filename.endswith('.csv'):
        with open(os.path.join(csv_folder, filename), 'r', encoding='utf8') as file:
            csv_data = csv.reader(file)
            next(csv_data)  # 跳过CSV文件的标题行
            for row in csv_data:
                insert_query = '''
                INSERT INTO 表名 (列1, 列2, ...)
                VALUES (%s, %s, ...)
                '''
                cursor.execute(insert_query, tuple(row))
                conn.commit()

cursor.close()
conn.close()