Execute multiline mysql in shellscript

Question

When I attempt to execute a multi-line SQL in mysql via shell script:

mysql -uroot -ppass mydb <<<EOF
SELECT * INTO OUTFILE 'table.csv'
    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\n'
FROM mytable limit 1;
EOF

I get a syntax error:

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'EOF' at line 1

What's the right way to script it?

Answer 1

The syntax for bash heredoc is:

COMMAND <<InputComesFromHERE
...
...
...
InputComesFromHERE

So you have an extra <.

In order to prepare and test you can replace COMMAND (i.e. mysql -uroot -ppass mydb in this case) with cat to have a look at the exact SQL code that will be executed.