使用bash将多个.csv文件导入mysql

#!/bin/bash

# 设置MySQL连接信息
MYSQL_HOST="localhost"
MYSQL_USER="your_username"
MYSQL_PASSWORD="your_password"
MYSQL_DATABASE="your_database"

# 遍历目录下的所有.csv文件
for file in /path/to/csv/directory/*.csv; do
    # 提取文件名（不包含扩展名）
    filename=$(basename "$file" .csv)
    
    # 导入CSV文件到MySQL表格
    mysql -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD $MYSQL_DATABASE -e "LOAD DATA INFILE '$file' INTO TABLE $filename FIELDS TERMINATED BY ',' IGNORE 1 LINES;"
done

bash /path/to/your/script.sh