SET Statements

Assign values to system variables. Learn to use the SET statement to configure GLOBAL and SESSION variables for tuning server behavior.

SET

Assign values to different types of variables. Learn the syntax for setting user-defined variables, system variables, and stored program variables.

SET CHARACTER SET

Map strings to a specific character set. This command updates the character set for the client, results, and connection to ensure correct data encoding.

SET GLOBAL SQL_SLAVE_SKIP_COUNTER

SET GLOBAL sql_slave_skip_counter skips the next N events from the primary to recover from replication stops, and is valid only while the replica threads are stopped.

SET NAMES

Configure the character set and collation for the current connection. This ensures the server correctly interprets data sent by the client application.

SET PASSWORD

Complete reference for SET PASSWORD in MariaDB. Complete syntax guide with all options, clauses, and practical examples with comprehensive examples and best.

SET PATH

SET PATH sets the list of schemas MariaDB searches when invoking stored routines and packages, available from MariaDB 12.3 via the @@path system variable.

SET SQL_LOG_BIN

Enable or disable binary logging for the current session. This statement allows administrators to perform operations without replicating them to replicas.

SET ROLE

Sets the current role for the session. Learn how to enable none, or a specific role to change your current privileges dynamically.

SET STATEMENT

Set a system variable for the duration of a single query. This statement allows temporary configuration changes that apply only to the immediate statement.

SET TRANSACTION

Define isolation levels and access modes for transactions. Learn to configure the behavior of the next transaction or the entire session for data consistency.

SET Variable

Assign values to user-defined variables. This guide explains how to store data in session-specific variables for reuse in subsequent SQL statements.