Bash scripting - Complex MYSQL statements

Question

So I am trying to take this:

SELECT  'cran_juniper' AS `set`, c.*
FROM    cran_juniper c
WHERE   ROW(c.device_fqdn, c.device_ip, c.interface, c.admin_state, c.link_state, c.description) NOT IN
        (
        SELECT  device_fqdn, device_ip, interface, admin_state, link_state, description
        FROM    cran_juniper_baseline
        )
UNION ALL
SELECT  'cran_juniper_baseline' AS `set`, b.*
FROM    cran_juniper_baseline b
WHERE   ROW(b.device_fqdn, b.device_ip, b.interface, b.admin_state, b.link_state, b.description) NOT IN
        (
        SELECT  device_fqdn, device_ip, interface, admin_state, link_state, description
        FROM    cran_juniper
        )
into outfile 'today.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';
;

And insert it into a bash script. Considering there's a SLEW of special characters all over this query, I am having a hard time finding a way to go about this. Any assist would be magical.

Gilles Quénot · Accepted Answer · 2016-10-10 18:26:51Z

2

1st solution using here-doc :

mysql -h 127.0.0.1 <<'EOF'
SELECT  'cran_juniper' AS `set`, c.*
FROM    cran_juniper c
...
;
EOF

2nd solution using a separate file

mysql -h 127.0.0.1 < file.sql # you will put all of your query within this file

Check

man bash | less +/here-doc

answered Oct 10, 2016 at 18:26

Gilles Quénot

188k43 gold badges232 silver badges229 bronze badges

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

1 Comment

Andy D'Arata Over a year ago

That was the one, and a lot easier than I thought it'd be. Thank you!

Collectives™ on Stack Overflow

Bash scripting - Complex MYSQL statements

1 Answer 1

1st solution using here-doc :

2nd solution using a separate file

Check

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1st solution using here-doc :

2nd solution using a separate file

Check

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related