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