Pagination in mysql CLI

Ever wonder how to scroll upwards in mysl resultset ?

What if your terminal doesn’t allow scrollback or the scrollback buffer is somehow set to sreen lines ?

How to use MORE or LESS unix commands in mysql which would allow to scroll using ‘return’ or ‘spacebar’

Follow the steps given below:

[Invoke mysql using the --page command]

1. mysql --page uuser -p  

[set the pager to use less]

2. mysql> pager less

[run your query]

3. mysql> select * from table_name

This also  works under the unix ‘screen’ terminal emulation