How to limit query results scrolling off the screen
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
PAGER set to stdout