On this page

OUTPUT

Core command

In a Script, hides routine output (QUIET) or shows it again (NORMAL, the default).

Syntax

OUTPUT QUIET|NORMAL

Arguments

Argument	Required	Values	Default
`QUIET` or `NORMAL`	Yes	`QUIET` hides the routine lines; `NORMAL` shows them again	`NORMAL` at the start of every Script

Examples

OUTPUT QUIET;
OUTPUT NORMAL;

Details

What QUIET hides

OUTPUT is allowed in Scripts only, and every Script run starts in NORMAL. QUIET hides:

the statement echo and the Found N queries line;
the variable value lines and the LET confirmations;
the row counts of inserts, updates and deletes, and the blank separator lines;
the final status line when the status is SUCCESS.

It never hides query results, ECHO messages, SHOW SCRIPT VARIABLES, the output of other commands, warnings, errors, or a final status other than SUCCESS.

Scope

The setting lasts until the end of the Script or the next OUTPUT statement; a Script it calls starts with the same setting. The activity log always receives everything, the hidden lines included.

Used in these how-tos

How do I write a report Script that stops at the first failure?

Last modified in release 5.5.0.

Found something wrong or unclear on this page? Tell us, with the page address.