SQL Modes Index

ALLOW_INVALID_DATES

Section 10.3, “Date and Time Types”
Section B.1.5.2, “Problems Using DATE Columns”
Section 5.1.8, “Server SQL Modes”
Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”

ANSI

Section 12.5.6.14, “SHOW CREATE VIEW Syntax”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 5.1.8, “Server SQL Modes”
Section 19.15, “The INFORMATION_SCHEMA VIEWS Table”

ANSI_QUOTES

Section 13.7.4.4, “FOREIGN KEY Constraints”
Section 8.2, “Schema Object Names”
Description
Section 1.7.4, “MySQL Extensions to Standard SQL”
Section 5.1.8, “Server SQL Modes”
Section 8.1.1, “Strings”

DB2

Section 5.1.8, “Server SQL Modes”

ERROR_FOR_DIVISION_BY_ZERO

Section 5.1.8, “Server SQL Modes”

HIGH_NOT_PRECEDENCE

Section 11.2.1, “Operator Precedence”
Section 5.1.8, “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.8, “Server SQL Modes”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

MAXDB

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

MSSQL

Section 5.1.8, “Server SQL Modes”

MYSQL323

Section 5.1.8, “Server SQL Modes”

MYSQL40

Section 5.1.8, “Server SQL Modes”

NO_AUTO_CREATE_USER

Section 12.5.1.3, “GRANT Syntax”
Section 5.5.2, “Adding User Accounts”
Section 5.1.8, “Server SQL Modes”

NO_AUTO_VALUE_ON_ZERO

Section 12.1.14, “CREATE TABLE Syntax”
Section 5.1.8, “Server SQL Modes”

NO_BACKSLASH_ESCAPES

Section 5.1.8, “Server SQL Modes”
Section 11.4.1, “String Comparison Functions”
Section 8.1.1, “Strings”

NO_DIR_IN_CREATE

Section 12.1.14, “CREATE TABLE Syntax”
Section 17.1, “Overview of Partitioning in MySQL”
Section 16.3.1.5, “Replication and DIRECTORY Table Options”
Section 16.3.1.28, “Replication and Variables”
Section 5.1.8, “Server SQL Modes”
Section 17.2.5, “Subpartitioning”

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.8, “Server SQL Modes”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

NO_FIELD_OPTIONS

Section 5.1.8, “Server SQL Modes”

NO_KEY_OPTIONS

Section 5.1.8, “Server SQL Modes”

NO_TABLE_OPTIONS

Section 5.1.8, “Server SQL Modes”

NO_UNSIGNED_SUBTRACTION

Section 10.2, “Numeric Types”
Section 10.1.1, “Overview of Numeric Types”
Section 17.5, “Restrictions and Limitations on Partitioning”
Section 5.1.8, “Server SQL Modes”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 6.0”

NO_ZERO_DATE

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.9, “Cast Functions and Operators”
Section 10.3, “Date and Time Types”
Section B.1.5.2, “Problems Using DATE Columns”
Section 5.1.8, “Server SQL Modes”

NO_ZERO_IN_DATE

Section 12.1.14, “CREATE TABLE Syntax”
Section 10.3, “Date and Time Types”
Section B.1.5.2, “Problems Using DATE Columns”
Section 5.1.8, “Server SQL Modes”

ONLY_FULL_GROUP_BY

Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
Section 5.1.8, “Server SQL Modes”

ORACLE

Section 5.1.8, “Server SQL Modes”

PAD_CHAR_TO_FULL_LENGTH

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

PIPES_AS_CONCAT

Section 11.2.1, “Operator Precedence”
Section 5.1.8, “Server SQL Modes”

POSTGRESQL

Section 5.1.8, “Server SQL Modes”

REAL_AS_FLOAT

Section 10.2, “Numeric Types”
Section 10.1.1, “Overview of Numeric Types”
Section 5.1.8, “Server SQL Modes”

STRICT_ALL_TABLES

Section 5.5.2, “Adding User Accounts”
Section 1.7.6.2, “Constraints on Invalid Data”
Section A.3, “MySQL 6.0 FAQ — Server SQL Mode”
Section 5.1.8, “Server SQL Modes”

STRICT_TRANS_TABLES

Section 5.5.2, “Adding User Accounts”
Section 1.7.6.2, “Constraints on Invalid Data”
Section A.3, “MySQL 6.0 FAQ — Server SQL Mode”
Section 5.1.8, “Server SQL Modes”

TRADITIONAL

Section 10.3.1.1, “TIMESTAMP Properties”
Section A.3, “MySQL 6.0 FAQ — Server SQL Mode”
Section 5.1.8, “Server SQL Modes”