varelov
Flight Engineer Flight Engineer
Flight Engineer
  • 1,354 Views

Pagers on MariaDB command line- are there any?

Jump to solution

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
Labels (2)
0 Kudos
1 Solution

Accepted Solutions
NunoMartins
Flight Engineer Flight Engineer
Flight Engineer
  • 1,346 Views

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

 

View solution in original post

1 Reply
NunoMartins
Flight Engineer Flight Engineer
Flight Engineer
  • 1,347 Views

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

 

Join the discussion
You must log in to join this conversation.