shell 导入csv到mysql

方法一：整个文件导入

#/bin/bash
export_sql="LOAD DATA INFILE '$1'
            INTO TABLE $3
            CHARACTER SET utf8
            FIELDS TERMINATED BY ','
            ENCLOSED BY '\"' "
mysql -h127.0.0.1 -P3306 -uroot -proot $2 -e "${export_sql}"

执行：

[root@xiaofei ~]# /home/xiaofei/test/test.sh  /usr/soft/t_config.csv psi t_config

方法二：一行一行读取然后导入

shell脚本内容如下

#!/bin/sh
#The username of mysql database
USER="root"

#The password of mysql database
PASS="dragonwake"

#The datebase name will be created
DATABASE="SmartCare"

TABLE="sct_Province"

TABLE_DATA="prov.csv"

if [ -f ${TABLE_DATA} ]; then
	
	echo "File ${TABLE_DATA} Existed."
	
el