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.7, “Server SQL Modes”
Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”

ANSI

Section 12.4.5.14, “SHOW CREATE VIEW Syntax”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 5.1.7, “Server SQL Modes”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”

ANSI_QUOTES

Section 13.6.5.4, “FOREIGN KEY Constraints”
Description
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 8.2, “Schema Object Names”
Section 5.1.7, “Server SQL Modes”
Section 8.1.1, “Strings”

DB2

Section 5.1.7, “Server SQL Modes”

ERROR_FOR_DIVISION_BY_ZERO

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

HIGH_NOT_PRECEDENCE

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

IGNORE_SPACE

Section 4.5.1.1, “mysql Options”
Section 12.1.12, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 5.1.7, “Server SQL Modes”

MAXDB

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

MSSQL

Section 5.1.7, “Server SQL Modes”

MYSQL323

Section 5.1.7, “Server SQL Modes”

MYSQL40

Section 5.1.7, “Server SQL Modes”

NO_AUTO_CREATE_USER

Section 12.4.1.3, “GRANT Syntax”
Section 5.5.2, “Adding User Accounts”
Section 5.1.7, “Server SQL Modes”

NO_AUTO_VALUE_ON_ZERO

Section 12.1.14, “CREATE TABLE Syntax”
Section 5.1.7, “Server SQL Modes”
Section 3.6.9, “Using AUTO_INCREMENT

NO_BACKSLASH_ESCAPES

Section 5.1.7, “Server SQL Modes”
Section 11.5.1, “String Comparison Functions”
Section 8.1.1, “Strings”

NO_DIR_IN_CREATE

Section 12.1.14, “CREATE TABLE Syntax”
Section 18.1, “Overview of Partitioning in MySQL”
Section 17.4.1.7, “Replication and DIRECTORY Table Options”
Section 17.4.1.32, “Replication and Variables”
Section 5.1.7, “Server SQL Modes”
Section 18.2.6, “Subpartitioning”
Section 5.2.4, “The Binary Log”

NO_ENGINE_SUBSTITUTION

Section 12.1.6, “ALTER TABLE Syntax”
Section 12.1.14, “CREATE TABLE Syntax”
Section 5.1.3, “Server Options for Loading Plugins”
Section 5.1.7, “Server SQL Modes”
Section 13.3, “Setting the Storage Engine”
Section 17.3.2, “Using Replication with Different Master and Slave Storage Engines”

NO_FIELD_OPTIONS

Section 5.1.7, “Server SQL Modes”

NO_KEY_OPTIONS

Section 5.1.7, “Server SQL Modes”

NO_TABLE_OPTIONS

Section 5.1.7, “Server SQL Modes”

NO_UNSIGNED_SUBTRACTION

Section 11.6.1, “Arithmetic Operators”
Section 11.10, “Cast Functions and Operators”
Section 10.6, “Out-of-Range and Overflow Handling”
Section 10.1.1, “Overview of Numeric Types”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section 5.1.7, “Server SQL Modes”

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.7, “Server SQL Modes”

NO_ZERO_IN_DATE

Section 12.1.14, “CREATE TABLE Syntax”
Section 10.3, “Date and Time Types”
Section C.5.5.2, “Problems Using DATE Columns”
Section 5.1.7, “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.7, “Server SQL Modes”

ORACLE

Section 5.1.7, “Server SQL Modes”

PAD_CHAR_TO_FULL_LENGTH

Section 10.1.3, “Overview of String Types”
Section 5.1.7, “Server SQL Modes”
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.7, “Server SQL Modes”

POSTGRESQL

Section 5.1.7, “Server SQL Modes”

REAL_AS_FLOAT

Section 10.2, “Numeric Types”
Section 10.1.1, “Overview of Numeric Types”
Section 5.1.7, “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.7, “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.7, “Server SQL Modes”

TRADITIONAL

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