how to get output of sql queries in Linux terminal?

Question

I wrote sql queries on terminal. I am not able to find out the output of that query. Can anyone help me from where I will get the output .

could you give an example of a MYSQL command you used that didn't return anything? — user3608589
– user3608589, Commented Jun 8, 2016 at 13:19

Nishu Tayal · Accepted Answer · 2016-06-08 12:47:51Z

1

You can run queries on terminal like this:

mysql -u user -p -e 'Your SQL Query Here' <database-name>

answered Jun 8, 2016 at 12:47

Nishu Tayal

20.9k8 gold badges53 silver badges105 bronze badges

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

Comments

Pavel Katiushyn · Accepted Answer · 2016-06-08 13:17:53Z

0

When you are in mysql terminal use:

mysql> \T /tmp/query.out
Logging to file 'query.out'

All queries output will be stored in /tmp/query.out file.

answered Jun 8, 2016 at 13:17

Pavel Katiushyn

8255 silver badges10 bronze badges