> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands.md).

# SET Statements

{% columns %}
{% column %}
{% content-ref url="/pages/4tuQQRFC5tgMVGTeeQzr" %}
[SET](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Assign values to different types of variables. Learn the syntax for setting user-defined variables, system variables, and stored program variables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Js5aWV8Bpgcg9MiKHCT9" %}
[SET CHARACTER SET](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-character-set.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Map strings to a specific character set. This command updates the character set for the client, results, and connection to ensure correct data encoding.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/x7ig2zkLB5Pk40BF2irK" %}
[SET GLOBAL SQL\_SLAVE\_SKIP\_COUNTER](/docs/server/reference/sql-statements/administrative-sql-statements/replication-statements/set-global-sql_slave_skip_counter.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Ld5ePiTX0FeCqjVUey86" %}
[SET NAMES](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-names.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Configure the character set and collation for the current connection. This ensures the server correctly interprets data sent by the client application.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/TfaL3k4x5x7bFuE9e6Dl" %}
[SET PASSWORD](/docs/server/reference/sql-statements/account-management-sql-statements/set-password.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete reference for SET PASSWORD in MariaDB. Complete syntax guide with all options, clauses, and practical examples with comprehensive examples and best.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/QjtbDfdYztZFJhxGmd64" %}
[SET PATH](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-path.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/X0Jj1Cwctcn3GaM77WbU" %}
[SET SQL\_LOG\_BIN](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-sql_log_bin.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Enable or disable binary logging for the current session. This statement allows administrators to perform operations without replicating them to replicas.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/BXecw1iZYqgUJrtCJZq3" %}
[SET ROLE](/docs/server/reference/sql-statements/account-management-sql-statements/set-role.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Sets the current role for the session. Learn how to enable none, or a specific role to change your current privileges dynamically.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/slKN3a86t7B8murH895k" %}
[SET STATEMENT](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-statement.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Set a system variable for the duration of a single query. This statement allows temporary configuration changes that apply only to the immediate statement.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/K2chRt8V6EIV0ZaKcqVf" %}
[SET TRANSACTION](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-transaction.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Define isolation levels and access modes for transactions. Learn to configure the behavior of the next transaction or the entire session for data consistency.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/KcP6CbawYrzTJWGSkRhD" %}
[SET Variable](/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-variable.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Assign values to user-defined variables. This guide explains how to store data in session-specific variables for reuse in subsequent SQL statements.
{% endcolumn %}
{% endcolumns %}