Variables and Modes

Explore MariaDB Server variables and modes. This section explains how to configure global and session variables, and how different SQL modes influence database behavior and compatibility.

Options, System & Status VariablesServer Status VariablesServer System VariablesNEW_MODEOLD_MODESQL_MODESQL_MODE=MSSQLDocumentation for the `MSSQL` SQL mode, which enables a subset of Microsoft SQL Server syntax and behavior compatibility in MariaDB, such as using brackets `[]` for quoting.SQL_MODE=ORACLEDocumentation for the `ORACLE` SQL mode, which provides extensive compatibility with Oracle Database PL/SQL syntax, data types, and sequences, facilitating migration.