MySQL Linux command line tool and properly formatted results [duplicate]

Question

Does anyone know of a good tool to use from the shell to query the database and get intelligible results?

On the command line, from SSH, I want to query the database using mysql but the results are pretty much unreadable because there is no formatting for the terminal screen.

If I run the following it is vary hard to make sense of the results.

use mydb; select * from db3_settings; 

I know I could use phpMyAdmin or the MySQLCC but I'm looking for a command-line solution.

Answer 1

You can obtain a vertically formatted output with \G.

This is the standard output:

mysql> select * from tblSettings; +-----------+----------------+---------------------+ | settingid | settingname    | settingvalue        | +-----------+----------------+---------------------+ |         1 | maxttl         | 30                  | |         2 | traceroutepath | /usr/bin/traceroute | |         3 | alertemail     | [email protected]         | +-----------+----------------+---------------------+ 3 rows in set (0.00 sec) 

And this is what the output looks like with \G:

mysql> select * from tblSettings \G; *************************** 1. row ***************************    settingid: 1  settingname: maxttl settingvalue: 30 *************************** 2. row ***************************    settingid: 2  settingname: traceroutepath settingvalue: /usr/bin/traceroute *************************** 3. row ***************************    settingid: 3  settingname: alertemail settingvalue: [email protected] 3 rows in set (0.00 sec)