| ALLOW_INVALID_DATES | The DATE data type can have any value in the range from 1 to 31 in the day component, even if it is not a valid date. |
| ANSI_QUOTES | The " character becomes the identifier quote instead of the ` character. |
| EMPTY_STRING_IS_NULL | Empty strings are treated as NULL for Oracle compatibility. |
| ERROR_FOR_DIVISION_BY_ZERO | An error is thrown when dividing a number by zero. Otherwise, NULL is returned. |
| EXTENDED_ALIASES | Aliases work similarly to aliases in Sybase SQL Anywhere. Aliases are resolved in the SELECT list and WHERE clause. Aliases can be used in the SELECT list before the alias is defined. |
| HIGH_NOT_PRECEDENCE | The precedence of the NOT operator is increased so that NOT A BETWEEN B AND C is interpreted as (NOT A) BETWEEN B AND C. |
| IGNORE_BAD_TABLE_OPTIONS | Incorrect table options provided to the CREATE TABLE or ALTER TABLE statements result in warnings instead of errors. |
| IGNORE_SPACE | Spaces may be specified between function names and parentheses. In doing so, the names of built-in functions become reserved words. |
| NO_AUTO_CREATE_USER | The GRANT statement is prevented from automatically creating a user unless the statement also includes information such as a password or an authentication plugin. |
| NO_AUTO_VALUE_ON_ZERO | The value 0 is not interpreted in the same way as NULL for AUTO_INCREMENT columns, but is treated as an actual 0. |
| NO_BACKSLASH_ESCAPES | The use of the backslash character as an escape character within strings is not allowed. Instead, it's just a normal character. |
| NO_DIR_IN_CREATE | The DATA DIRECTORY and INDEX DIRECTORY table options are ignored in the CREATE TABLE and ALTER TABLE statements. |
| NO_ENGINE_SUBSTITUTION | A storage engine cannot be replaced with standard mode. If the specification is incorrect, an error is issued. |
| NO_FIELD_OPTIONS | Prevents the SHOW CREATE TABLE statement from printing MariaDB specific column options. |
| NO_KEY_OPTIONS | Prevents the SHOW CREATE TABLE statement from printing MariaDB-specific index options. |
| NO_TABLE_OPTIONS | Prevents the SHOW CREATE TABLE statement from printing MariaDB specific table options. |
| NO_UNSIGNED_SUBTRACTION | Signed data types are used for subtraction results even if the operands contain unsigned data types. |
| NO_ZERO_DATE | 0000-00-00 is forbidden as a valid value for the DATE data type. |
| NO_ZERO_IN_DATE | The DATE data type for the year component is prevented from having a non-zero value if the date for the month or day components has zero values. |
| ONLY_FULL_GROUP_BY | Columns can only be selected in SELECT ... GROUP BY statements if the column is in the GROUP BY clause or is in an aggregate function. |
| PAD_CHAR_TO_FULL_LENGTH | Columns of data type CHAR are filled to the full length of the column when selected. |
| PIPES_AS_CONCAT | The operator || functionally corresponds to the CONCAT() function and not to the OR operator. |
| REAL_AS_FLOAT | The REAL data type becomes an alias for the FLOAT data type instead of the alias for the DOUBLE data type. |
| SIMULTANEOUS_ASSIGNMENT | The server evaluates all assignments in the SET clause of an UPDATE statement at once, rather than from left to right. |
| STRICT_ALL_TABLES | Strict mode is enabled for tables that use transactional and non-transactional storage engines. Any statements that contain invalid or missing data generate errors instead of warnings. |
| STRICT_TRANS_TABLES | Enables strict mode for tables using transactional storage engines. Any statements that contain invalid or missing data generate errors instead of warnings. |
| TIME_ROUND_FRACTIONAL | Der Server rundet Sekundenbruchteile, wenn der Wert in einen Datentyp ohne Sekundenbruchteile konvertiert wird. |
| ANSI | Alias for REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE. |
| DB2 | Alias for PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS. |
| MAXDB | Alias for PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS, NO_AUTO_CREATE_USER. |
| MSSQL | Alias for PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS. |
| MYSQL323 | Alias for HIGH_NOT_PRECEDENCE. |
| MYSQL40 | Alias for HIGH_NOT_PRECEDENCE. |
| ORACLE | A subset of Oracle's PL/SQL stored procedure language is enabled. This also enables the following other modes: PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS, NO_AUTO_CREATE_USER, SIMULTANEOUS_ASSIGNMENT. |
| POSTGRESQL | Alias for PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS. |
| TRADITIONAL | Alias for STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION. |
| TIME_TRUNCATE_FRACTIONAL | TIME and TIMESTAMP values are rounded when inserted into a column of the same type if the fractional second has too many digits. |
