SQL query within BASH

Question

I have a BASH script like the below:

#!/bin/bash

email_template="Subject: Subject
From: [email protected]
To: %s

%s
%s
%s
"

cat test.out | while read num email limit orders; do
    echo "Sending mail to '$email'"
    printf "$email_template" "$email" "$num" "$limit" "$orders" |
    sendmail -oi -t
done

Also there is a .sql file with a SQL query contained within that does a SPOOL to test.out with results. How can I make it so that this is all done within the BASH script above (SQL in BASH script, no cat etc.)?

Try the following: sqlplus <user>/<password> @file-with-sql-1.sql Source: stackoverflow.com/questions/1467846/… — Yiannis Nennes
– Yiannis Nennes, Commented Aug 9, 2013 at 14:14

dtorgo · Accepted Answer · 2013-08-09 13:56:15Z

0

Without seeing the .sql file it is more difficult to say but here are some possibilities:

Add the .sql inline and store it in a bash variable:

mysqlquery="select * from foo;
selct * from baz;
select * from bar;"

echo "${mysqlquery}"|mysql

If you keep the .sql file separate then you can do something like:

mysql < /path/sqlFile.sql

answered Aug 9, 2013 at 13:56

dtorgo

2,1261 gold badge16 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

SQL query within BASH

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related