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.