Syntax

SET { [SESSION] variable_name } = value;

SET @@SESSION.variable_name = value;

SET {CHARACTER SET 'charset_name'};

SET PASSWORD FOR 'username'@'host' = PASSWORD('password');

Remarks

• variable_name is the name of the session variable.

• The @@SESSION.variable_name syntax is supported for compatibility with other database systems, such as MySQL.

• This command can be run on a master or child aggregator node to set sync variables, but otherwise must be run on the master aggregator.

• See the engine variables overview for information about other ways to set variables.

• The SESSION keyword is optional. Including it does not change this command’s behavior.

• charset_name sets session system variables character_set_client and character_set_results to the given character set, and character_set_connection to the value of character_set_server. It may be quoted or unquoted. The default character set mapping can be restored by using value DEFAULT.

• SET PASSWORD sets the user password. See SET PASSWORD topic for details.

• SET NAMES is non-operational in SingleStore and is included only for MySQL compatibility.

Examples

The following queries set the value of the session variable net_read_timeout to 5000.

SET net_read_timeout = 5000;
or
SET @@SESSION.net_read_timeout = 5000;

The following query retrieves the value of the session variable net_read_timeout.

SELECT @@net_read_timeout;

Refer to Assigning Expressions to Variables for more examples.

Related Topics

• Engine Variables Overview

• SET GLOBAL