Csv file upload into database using shell script shows error

Question

I'm uploading a csv file using the script

values ()
{
cat "$@" | \
while IFS=, read  -r a b c d;do 

printf ' %s\n' "$c"

done | \
paste -sd,-
}

Inserting data using

printf 'INSERT INTO `manufacturemap`(`manufacture_name`)VALUES(%s)\n'     "$(values $_csv_files)" | \
  mysql -u"$_db_user" -p"$_db_password" "$_db"

I get the following error

 ERROR 1054 (42S22) at line 1: Unknown column 'c' in 'field list'

I've been stuck here for the past few hours,Please help me.

Here is the Input(csv file):

    a,b,c,d
1.01100156278101E+15,2014/07/08,2014/07/08,"Cash Withdrawal by Cheque-173320--TT1421957901"
1.01100156278101E+15,2014/07/08,2014/07/08,"Cheque Paid-173261--TT1421951241"
1.01100156278101E+15,2014/07/08,2014/07/08,"Cheque Paid-173298--TT1421951226"
1.01100156278101E+15,2014/06/08,2014/06/08,"Cash Withdrawal by Cheque-173319--TT1421858465"

Output of your function with your csv file: 2014/07/08, 2014/07/08- 2014/07/08, 2014/06/08 — Cyrus
– Cyrus, Commented Jun 7, 2015 at 5:55
I don't know. Your question lacks the upload part of your script. — Cyrus
– Cyrus, Commented Jun 7, 2015 at 5:58
@anubhava expected output? well I need to convert the csv data into a table format so that I can put the values under the column c to database. — Adrian Veidt
– Adrian Veidt, Commented Jun 7, 2015 at 6:19
Yes that is what expected output will be. Can you show those insert sql that you expect from above input. — anubhava
– anubhava, Commented Jun 7, 2015 at 6:23

anubhava · Accepted Answer · 2015-06-07 07:04:10Z

2

Better to use awk on your csv file like this to generate sql queries:

awk -F, 'NR>1{printf "INSERT INTO `manufacturemap`(`manufacture_name`) VALUES(\047%s\047)\n",
          $3}' file.csv
INSERT INTO `manufacturemap`(`manufacture_name`) VALUES ('2014/07/08')
INSERT INTO `manufacturemap`(`manufacture_name`) VALUES ('2014/07/08')
INSERT INTO `manufacturemap`(`manufacture_name`) VALUES ('2014/07/08')
INSERT INTO `manufacturemap`(`manufacture_name`) VALUES ('2014/06/08')

EDIT: To do that without awk you can do:

while IFS=, read -r _ _ c _; do
   [[ $((++i)) != "1" ]] && 
      printf 'INSERT INTO `manufacturemap`(`manufacture_name`) VALUES (\047%s\047)\n' "$c"
done < file.csv
INSERT INTO `manufacturemap`(`manufacture_name`) VALUES ('2014/07/08')
INSERT INTO `manufacturemap`(`manufacture_name`) VALUES ('2014/07/08')
INSERT INTO `manufacturemap`(`manufacture_name`) VALUES ('2014/07/08')
INSERT INTO `manufacturemap`(`manufacture_name`) VALUES ('2014/06/08')

edited Jun 7, 2015 at 7:04

answered Jun 7, 2015 at 6:35

anubhava

790k67 gold badges603 silver badges671 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Adrian Veidt Over a year ago

I know,but I'm supposed to do this with a shell script.

Adrian Veidt Over a year ago

Yes,it does help,But its also inserting in the header name.How to exclude that?

Collectives™ on Stack Overflow

Csv file upload into database using shell script shows error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related