MySQL pager

I very liked to use psql command. Among different usability things, it uses less command to show query results. That was the thing I always wanted to have in mysql command. And was sure that's not possible, and till today was suffered in silence.

But today, quite unexpected for me, I found option pager for mysql command. This option let me set the program, I want to use to see query search results. So, to use less program, I was just need to start mysql with --pager parameter:

$ mysql --pager=less

or in mysql console:

mysql> pager=less

Now I'm happy to use it! And you should try too :)