Use less as pager for mysql

When selecting huge chunks of data from a mysql database, you usually have to scroll up with the mouse to view the top entries. To keep your hands on the keyboard, and even on the home row is good.

mysql> pager less

If you wanted to manipulate the data, or copy something, you could use vim/emacs/nano as the pager

March 13, 2011