How to limit query results scrolling off the screen
Answer:
If you have a query which return a very large result, and you want to use a pager such as less to control, you can use the following command in the mysql client.
mysql> pager less;
PAGER set to 'less'
mysql> select * from very_large_table;
To turn off the pager
mysql> nopager;
PAGER set to stdout
