1  –  COMMENT

    Syntax options:

    COMMENT | NOCOMMENT

    Disables or enables the display of of comment text by other SHOW
    commands (for example, SHOW TABLE).

2  –  COUNTER

    Syntax options: ROW COUNTER | NO ROW COUNTER

    Enables the total count reported by SELECT, DELETE, INSERT, and
    UPDATE statements. Use NO ROW COUNTER to disable the trailing
    count message.

3  –  DEFAULT_NULL_STRING

    Reverts to using the text 'NULL'.

4  –  EDIT_STRING

    Syntax options:

    EDIT STRING | NO EDIT STRING

    Enables the usage of column edit strings to format values for the
    SELECT statement. Use NO EDIT STRING to disable the use of the
    column edit strings.

5  –  NULL_STRING

    Changes the way NULL values are displayed by interactive SQL.

6  –  QUERY_HEADER

    Syntax options:

    QUERY HEADER | NO QUERY HEADER

    Enables the printed header generated by the SELECT, CALL, FETCH,
    and PRINT statements. Use NO QUERY HEADER to disable this header.