MySQL console: Redirect standard output
Intro
MySQL client command must be common to you (mysql), with this small tip you should be able to redirect the output commands to any program?
Implementation
To do this, simply use the pager command, followed by the name of the program to redirect the output.
Example:
mysql>pager more PAGER set to 'more' mysql>
The next time the result of a command exceeds one page, you simply press the space bar to move from page to page:)
Reset default pager
To return to the default pager, use the command "nopager":
mysql> nopager PAGER set to stdout mysql>
Examples of use: (under Linux/Unix)
- In order to search an item, ... in the output:
-
mysql>pager vi -
-
- To view only the tables with a particular name (no case sensitive).
mysql>pager grep -i name
Related
- MySQL console: Redirect standard output
- MySQL console - Disable beep sound - How-To - Programming
- Redirect ping output to text file - How-To - Windows
- Php redirect to another page - How-To - PHP
- Gprs standard - Articles
- Rgss-rtp standard not found - How-To - Software
This document, titled « MySQL console: Redirect standard output », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).