The RESET statement resets a session variable to its default value for the client session.

Required Privileges

No privileges are required to reset a session setting.

Synopsis

RESET SESSION session_var

Parameters

Parameter Description
session_var The name of the session variable.

Example

Tip:
You can use SET .. TO DEFAULT to reset a session variable as well.
> SET default_transaction_isolation = SNAPSHOT;
> SHOW default_transaction_isolation;
+-------------------------------+
| default_transaction_isolation |
+-------------------------------+
| SNAPSHOT                      |
+-------------------------------+
(1 row)
> RESET default_transaction_isolation;
> SHOW default_transaction_isolation;
+-------------------------------+
| default_transaction_isolation |
+-------------------------------+
| SERIALIZABLE                  |
+-------------------------------+
(1 row)

See Also



Yes No