String

Empty string

This option controls the way NULL values are written by the OUTPUT statement. Every time a NULL value is found in the result set, the string from this option is returned instead. This option affects only the TEXT, HTML, FIXED, and SQL output formats.

The following example changes the value that appears for NULL values to (unknown):

SET OPTION output_nulls = '(unknown)';

• SET OPTION statement [Interactive SQL]
• IFNULL function [Miscellaneous]