Shell script for mysql query execution shows error

Question

I'm running the below script

mysql -u $_db_user -p$_db_password $_db << eof
INSERT INTO \`manufacturemap\`
(\`manufacture_id`\ `manufacture_name`\) VALUES (122,IBM)
eof
done
exit

but it shows the following Error

bad substitution: no closing "`" in `manufacture_name'\) VALUES    (122,IBM))

I've tried everything I know,Please help, kinda stuck here.

Sougata Bose · Accepted Answer · 2015-06-06 07:03:36Z

1

Missing , and wrong \s in ->

(\`manufacture_id`\ `manufacture_name`\)

Should be -

(\`manufacture_id\`, \`manufacture_name\`)

No escaping needed -

INSERT INTO manufacturemap (manufacture_id, manufacture_name) VALUES (122, 'IBM')

answered Jun 6, 2015 at 6:51

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

1 Comment

Thank you so much b0s3,You saved my day.More questions coming up ;)