【シェルスクリプト】CSVファイルを読み込んでMySQLでデータベースに保存

## insert_csv.sh
#!/bin/sh

CSVFILE="filename.csv"

# passwordは先頭に-pを付ける
MYSQL="mysql -vvv -u username -ppassword database"

while read LINE
do
  COL1=$(echo $LINE | cut -d "," -f 1)
  $MYSQL <<EOF
    INSERT INTO table_name (col_name1) VALUES ('$COL1');
EOF
done < $CSVFILE
	#!/bin/sh

	CSVFILE="filename.csv"

	# passwordは先頭に-pを付ける
	MYSQL="mysql -vvv -u username -ppassword database"

	while read LINE
	do
	COL1=$(echo $LINE \| cut -d "," -f 1)
	$MYSQL <<EOF
	INSERT INTO table_name (col_name1) VALUES ('$COL1');
	EOF
	done < $CSVFILE