如何一次导入多个.csv文件？

import mysql.connector
import os

# 数据库连接配置
config = {
    'user': 'your_username',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database'
}

# CSV 文件目录
csv_directory = '/path/to/csv/files'

# 连接到数据库
cnx = mysql.connector.connect(**config)
cursor = cnx.cursor()

# 遍历目录中的所有 CSV 文件
for filename in os.listdir(csv_directory):
    if filename.endswith('.csv'):
        file_path = os.path.join(csv_directory, filename)
        table_name = filename.replace('.csv', '')
        
        # 构建 SQL 语句
        sql = f"LOAD DATA INFILE '{file_path}' INTO TABLE {table_name} FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'"
        
        # 执行 SQL 语句
        cursor.execute(sql)

# 提交事务并关闭连接
cnx.commit()
cursor.close()
cnx.close()