SQL Modes Index

ALLOW_INVALID_DATES

Section 11.7, “Date and Time Functions”
Section 10.3, “Date and Time Types”
Section C.5.5.2, “Problems Using DATE Columns”
Section 5.1.6, “Server SQL Modes”
Section 10.3.1, “The DATE, DATETIME, and TIMESTAMP Types”

ANSI

Section 12.7.5.14, “SHOW CREATE VIEW Syntax”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 5.1.6, “Server SQL Modes”
Section 19.28, “The INFORMATION_SCHEMA VIEWS Table”

ANSI_QUOTES

Section 13.3.5.4, “FOREIGN KEY Constraints”
Description
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 8.2, “Schema Object Names”
Section 5.1.6, “Server SQL Modes”
Section 8.1.1, “String Literals”

DB2

Section 5.1.6, “Server SQL Modes”

ERROR_FOR_DIVISION_BY_ZERO

Section 11.18.3, “Expression Handling”
Section 11.18.5, “Precision Math Examples”
Section 5.1.6, “Server SQL Modes”

HIGH_NOT_PRECEDENCE

Section 8.5, “Expression Syntax”
Section 11.3.1, “Operator Precedence”
Section 5.1.6, “Server SQL Modes”

IGNORE_SPACE

Section 4.5.1.1, “mysql Options”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 5.1.6, “Server SQL Modes”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

MAXDB

Section 10.3.1.1, “TIMESTAMP Properties”
Section 5.1.6, “Server SQL Modes”

MSSQL

Section 5.1.6, “Server SQL Modes”

MYSQL323

Section 5.1.6, “Server SQL Modes”

MYSQL40

Section 5.1.6, “Server SQL Modes”

NO_AUTO_CREATE_USER

Section 12.7.1.3, “GRANT Syntax”
Section 5.5.2, “Adding User Accounts”
Section 5.1.6, “Server SQL Modes”

NO_AUTO_VALUE_ON_ZERO

Section 12.1.17, “CREATE TABLE Syntax”
Section 5.1.6, “Server SQL Modes”
Section 3.6.9, “Using AUTO_INCREMENT

NO_BACKSLASH_ESCAPES

Section 5.1.6, “Server SQL Modes”
Section 11.5.1, “String Comparison Functions”
Section 8.1.1, “String Literals”

NO_DIR_IN_CREATE

Section 12.1.17, “CREATE TABLE Syntax”
Section 17.1, “Overview of Partitioning in MySQL”
Section 15.4.1.7, “Replication and DIRECTORY Table Options”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.6, “Server SQL Modes”
Section 17.2.6, “Subpartitioning”
Section 5.2.4, “The Binary Log”

NO_ENGINE_SUBSTITUTION

Section 12.1.7, “ALTER TABLE Syntax”
Section 12.1.17, “CREATE TABLE Syntax”
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 5.1.6, “Server SQL Modes”
Section 13.1, “Setting the Storage Engine”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 15.3.2, “Using Replication with Different Master and Slave Storage Engines”

NO_FIELD_OPTIONS

Section 5.1.6, “Server SQL Modes”

NO_KEY_OPTIONS

Section 5.1.6, “Server SQL Modes”

NO_TABLE_OPTIONS

Section 5.1.6, “Server SQL Modes”

NO_UNSIGNED_SUBTRACTION

Section 11.6.1, “Arithmetic Operators”
Section 11.10, “Cast Functions and Operators”
Section 10.1.1, “Numeric Type Overview”
Section 10.2.6, “Out-of-Range and Overflow Handling”
Section 17.5, “Restrictions and Limitations on Partitioning”
Section 5.1.6, “Server SQL Modes”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

NO_ZERO_DATE

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.10, “Cast Functions and Operators”
Section 10.3, “Date and Time Types”
Section C.5.5.2, “Problems Using DATE Columns”
Section 5.1.6, “Server SQL Modes”

NO_ZERO_IN_DATE

Section 12.1.17, “CREATE TABLE Syntax”
Section 10.3, “Date and Time Types”
Section C.5.5.2, “Problems Using DATE Columns”
Section 5.1.6, “Server SQL Modes”

ONLY_FULL_GROUP_BY

Section 11.16.3, “GROUP BY and HAVING with Hidden Columns”
Section 3.3.4.8, “Counting Rows”
Section 5.1.6, “Server SQL Modes”

ORACLE

Section 5.1.6, “Server SQL Modes”

PAD_CHAR_TO_FULL_LENGTH

Section 5.1.6, “Server SQL Modes”
Section 10.1.3, “String Type Overview”
Section 10.4.1, “The CHAR and VARCHAR Types”

PIPES_AS_CONCAT

Section 8.5, “Expression Syntax”
Section 11.3.1, “Operator Precedence”
Section 5.1.6, “Server SQL Modes”

POSTGRESQL

Section 5.1.6, “Server SQL Modes”

REAL_AS_FLOAT

Section 10.1.1, “Numeric Type Overview”
Section 10.2, “Numeric Types”
Section 5.1.6, “Server SQL Modes”

STRICT_ALL_TABLES

Section 5.5.2, “Adding User Accounts”
Section 1.8.6.2, “Constraints on Invalid Data”
Section 11.18.3, “Expression Handling”
Section 5.1.6, “Server SQL Modes”

STRICT_TRANS_TABLES

Section 5.5.2, “Adding User Accounts”
Section 1.8.6.2, “Constraints on Invalid Data”
Section 11.18.3, “Expression Handling”
Section 5.1.6, “Server SQL Modes”

TRADITIONAL

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.18.3, “Expression Handling”
Section 5.1.6, “Server SQL Modes”