Recipe 1.18. Selecting Tabular or Tab-Delimited Query Output Format


Problem

mysql produces tabular output when you want tab-delimited output, or vice versa.

Solution

Select the desired format explicitly with the appropriate command option.

Discussion

When you use mysql noninteractively (such as to read statements from a file or to send results into a pipe), it writes output in tab-delimited format by default. Sometimes it's desirable to produce tabular output instead. (These formats are described in Section 1.17.) For example, if you want to print or mail statement results, tab-delimited output doesn't look very nice. Use the -t (or --table) option to produce tabular output that is more readable:

% mysql -t cookbook <                  inputfile                  | lpr  % mysql -t cookbook <                  inputfile                  | mail paul              

The inverse operation is to produce batch (tab-delimited) output in interactive mode. To do this, use -B or --batch.




MySQL Cookbook
MySQL Cookbook
ISBN: 059652708X
EAN: 2147483647
Year: 2004
Pages: 375
Authors: Paul DuBois

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net