使用脚本批量导入mysql数据(.cvs后缀)

ip=172.168.1.*
port=3307
root=root
pass=***
database=***

touch $(pwd)/import.sql
for name in $(mysql -h $ip -P$port -u$root -p$pass -e "use $database;show tables"|awk 'NR>1{print $1}');
do
        echo $name
          if [ "$(echo `ls|grep ${name}.csv|wc -l`)" -eq "1" ]
                then
            echo "正在操作${name}.csv"
cat<< EOF > $(pwd)/import.sql
load data local infile '$(pwd)/${name}.csv'
into table ${name}
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
IGNORE 1 ROWS;
EOF
## 使用 < 导入.sql 命令
mysql -h $ip -P$port -u$root -p$pass -D $database  < import.sql && echo "${name}.csv 导入成功"
          fi
done;