Pagers on MariaDB command line- are there any?

[varelov]

Is there a way to page the output of an SQL command within MariaDB shell the way Bash offers paging via less?

Let's say you are at the MariaDB prompt and are inspecting the mysql database for all the columns it has:

<MariaDB[mysql]> show tables;

Output usually runs through and I'd like to put it through a pager like it is done in bash:

[root@lolzie]# some_command | less

[NunoMartins · Accepted solution]

You can do the following: 

mysql> pager less

or you can use the pager to send the output to a file or to a script 

mysql> pager /tmp/process_script