Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement