How do I run a sql query using shell script for mysql server. I am new to shell scripting.

Question

Server : MySQL Query : SQL Requirement : Shell Script

How do I run a sql query using shell script for mysql server. This will help me in automating the task.

Possible duplicate of [How to execute a MySQL command from a shell script?](http://stackoverflow.com/questions/8055694/how-to-execute-a-mysql-command-from-a-shell-script) — dparoli, Mar 29 '17 at 20:13
I have to output of this query in an Excel File. What more do I add to this query? — Hansal, Mar 29 '17 at 21:29

score 0 · Answer 1 · answered Mar 29 '17 at 19:15

0

mysql -u USER -p PASSWORD -h MYSQLSERVERNAME -e 'select * from foo...' database-name

answered Mar 29 '17 at 19:15

Teja

I have to output of this query in an Excel File. What more do I add to this query? – Hansal Mar 29 '17 at 21:00

1 Answers1