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.

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.