Problemmysql produces tabular output when you want tab-delimited output, or vice versa. SolutionSelect the desired format explicitly with the appropriate command option. DiscussionWhen 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. |