varelov
Flight Engineer Flight Engineer
Flight Engineer
  • 771 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
  • 763 Views

Re: Pagers on MariaDB command line- are there any?

Jump to 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

 

View solution in original post

Reply
Loading...
1 Reply
NunoMartins
Flight Engineer Flight Engineer
Flight Engineer
  • 764 Views

Re: Pagers on MariaDB command line- are there any?

Jump to 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

 

View solution in original post

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