14/10/15

How to analyze long output of a MySQL query?

Using MySQL in command line mode can be a problem when you have to analyze query result that have long lines.

If you use Linux for you can set the pager option of mysqlclient

mysql> pager less -n -i -S

If you want to make it permanently you can setup your my.cnf with this:

[client]
pager = less -n -i -S

Ref: http://stackoverflow.com/questions/4285664/how-to-adjust-display-settings-of-mysql-command-line