Server SQL Mode Quickref
This table shows the available Server SQL Modes. Please refer to the manual for details on the subject of the Server SQL Modes (4.1 and earlier, 5.0 and 5.1).
The simple modes are aligned along the vertical axis. The composite modes are aligned along the horizontal axis. A version number superscript is supplied for each individual mode, indicating the version that first implemented the mode.
The cells inside the table show the relationship between simple and composite modes. When a simple mode is included in a composite mode, the cell that intersects the simple mode's row and the composite mode's column contains the version number where this was first implemented. Sometimes, a simple mode was excluded in a later version; in that case, the cell also contains a strike-through version number indicating the first version where the simple mode was excluded.
| Server SQL Modes | ANSI4.1.1 | DB2 4.1.1 | MAXDB 4.1.1 | MSSQL 4.1.1 | MYSQL323 4.1.1 | MYSQL40 4.1.1 | ORACLE 4.1.1 | POSTGRESQL 4.1.1 | TRADITIONAL 5.0.2 |
|---|---|---|---|---|---|---|---|---|---|
| ALLOW_INVALID_DATES 5.0.2 | |||||||||
| ANSI_QUOTES 4.0.0 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | |||
| ERROR_FOR_DIVISION_BY_ZERO 5.0.2 | 5.0.2 | ||||||||
| HIGH_NOT_PRECEDENCE 5.0.2 | 5.0.2 | 5.0.2 | |||||||
| IGNORE_SPACE 4.0.0 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | |||
| NO_AUTO_CREATE_USER 5.0.2 | 5.0.2 | 5.0.2 | 5.0.2 | ||||||
| NO_AUTO_VALUE_ON_ZERO 4.1.1 | |||||||||
| NO_BACKSLASH_ESCAPES 5.0.1 | |||||||||
| NO_DIR_IN_CREATE 4.0.15 | |||||||||
| NO_ENGINE_SUBSTITUTION 5.0.8 | |||||||||
| NO_FIELD_OPTIONS 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | ||
| NO_KEY_OPTIONS 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | ||||
| NO_TABLE_OPTIONS 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | ||||
| NO_UNSIGNED_SUBSTRACTION 4.0.2 | |||||||||
| NO_ZERO_IN_DATE 5.0.2 | 5.0.2 | ||||||||
| NO_ZERO_DATE 5.0.2 | 5.0.2 | ||||||||
| ONLY_FULL_GROUP_BY 4.0.0 | 4.1.1, 4.1.11 | ||||||||
| PIPES_AS_CONCAT 4.0.0 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | 4.1.1 | |||
| REAL_AS_FLOAT 4.0.0 | 4.1.1 | ||||||||
| STRICT_TRANS_TABLES 5.0.2 | 5.0.2 | ||||||||
| STRICT_ALL_TABLES 5.0.2 | 5.0.2 |