A few words of thanks would be greatly appreciated.

MySQL console: Redirect standard output

Latest update on May 3, 2010 at 09:16 AM by deri58 .

Intro
Implementation
Reset default pager
Examples of use: (under Linux/Unix)

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:)

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 
```

mysql>show tables;

MySQL console: Redirect standard output
MySQL console - Disable beep sound - How-To - Programming
Rgss-rtp standard not found - How-To - Software
Unsupported signal check device output ✓ - Forum - Laptop
Network interface card is input or output device - Articles
Redirection php - How-To - PHP

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).

Illegal mix of collations (latin1_swedish_ci,IMPLICIT)

Backup/Restore MySQL database

Intro

Implementation

Reset default pager

Examples of use: (under Linux/Unix)

Subscribe To Our Newsletter!