Sometimes we want to see some data directly from database. MySQL command-line client allows to use external pager command like less or more. This feature is spupported by \P switch.
mysql> \P less PAGER set to 'less' mysql> select value from randoms; +----------------------+ | value | +----------------------+ | 0.701515919250917 | | 0.611940209392403 | | 0.697452277594667 | | 0.494860454923343 | | 0.0448477035806027 | | 0.921094222852117 | | 0.462315713485997 | :
MySQL client will display one page and wait for your interaction like a plain less tool.
Disabling pager:
mysql> \P Default pager wasn't set, using stdout. mysql>