How to store multiline sql query in a shell variable?

Question

How can i hold multiline sql query in a shell variable?

SQL='Lets get CREATE TRIGGER STATEMENT'

How to hold it?

possible duplicate of How can I write a here doc to a file in Bash script? — Avinash Raj
– Avinash Raj, Commented Jul 9, 2015 at 5:51

Srini V · Accepted Answer · 2015-07-09 06:35:02Z

1

This worked well for me

  extract_sql="SELECT *
               FROM TABLE"

To run SQLs with command line tools like wxsubmit or sqlplus

 commandlinesqltool  -options << EOF > /dev/null 2>&1

    SET HEADER OFF

    UPDATE TABLE
    SET    A=1;

EOF

answered Jul 9, 2015 at 6:35

Srini V

11.5k15 gold badges70 silver badges93 bronze badges

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

Comments

koushik veldanda · Accepted Answer · 2015-07-09 06:32:02Z

0

Declare @sql nvarchar(max);

SET @sql='SELECT *'+char(13) +'FROM table'

Print(@sql);


result: SELECT *
        FROM table

In above query char(13) will hepls to write in next line.

Now @sql variable has two lines.

answered Jul 9, 2015 at 6:32

koushik veldanda

1,10710 silver badges23 bronze badges

Are you confusing MySQL with SQL Server? Though I see that the question isn't tagged MySQL, but the chat feeds the SQL to the mysql program.