W3cubDocs

/MariaDB

Variables and Modes

The different variables and modes to use to affect how MariaDB works.

Title Description
Full List of MariaDB Options, System and Status Variables Complete alphabetical list of all MariaDB options as well as system and status variables.
Server Status Variables List and description of the Server Status Variables.
Server System Variables List of system variables.
OLD_MODE Used to emulate behavior from older MariaDB and MySQL versions.
SQL_MODE Used to emulate behavior from other SQL servers.
SQL_MODE=MSSQL Microsoft SQL Server compatibility mode.
SQL_MODE=ORACLE From MariaDB 10.3 MariaDB understands a subset of Oracle's PL/SQL language.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/variables-and-modes/