patternMinor
MySQL: Show list of tables with paging in Terminal
Viewed 0 times
showtablespagingterminalwithmysqllist
Problem
I am using MySQL Ver 14.14 Distrib 5.5.44 for debian-linux-gnu.
How can I show my tables page wise in a terminal?
How can I show my tables page wise in a terminal?
Solution
You can use the pager (see docs) command in MySQL console or use the --pager startup option (docs again) to redirect the output of your commands to an external executable.
To use the pager command and list the tables try this:
You can also start MySQL to send all your output to an external executable like this
To use the pager command and list the tables try this:
mysql> pager less
mysql> show tablesYou can also start MySQL to send all your output to an external executable like this
mysql --pager=/usr/bin/lessCode Snippets
mysql> pager less
mysql> show tablesmysql --pager=/usr/bin/lessContext
StackExchange Database Administrators Q#111897, answer score: 8
Revisions (0)
No revisions yet.