SHOW (session settings)

The SHOW statement can display the value of either one or all session setting variables. Some of these can also be configured via SET SESSION.

Note

The SHOW statement for session settings is unrelated to the other SHOW statements like e.g. SHOW TABLES.

Table of contents

Synopsis

SHOW { parameter_name | ALL }

Parameters

parameter_name:

The name of the session setting which should be printed. See Session settings for available session settings.

ALL:

Show the values of all settings.