SQL Modes Index

ALLOW_INVALID_DATES

Section 10.3, “Date and Time Types”
Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”

ANSI

Section 8.2.4, “Function Name Parsing and Resolution”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”

ANSI_QUOTES

Section 8.2, “Schema Object Names”
Description
Section 8.1.1, “Strings”

HIGH_NOT_PRECEDENCE

Section 11.2.1, “Operator Precedence”

IGNORE_SPACE

Section 4.5.1.1, “mysql Options”
Section 8.2.4, “Function Name Parsing and Resolution”

MAXDB

Section 10.3.1.1, “TIMESTAMP Properties”

NO_AUTO_CREATE_USER

Section 5.5.2, “Adding User Accounts”

NO_BACKSLASH_ESCAPES

Section 11.4.1, “String Comparison Functions”
Section 8.1.1, “Strings”

NO_DIR_IN_CREATE

Section 18.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 18.2.5, “Subpartitioning”

NO_UNSIGNED_SUBTRACTION

Section 10.2, “Numeric Types”
Section 10.1.1, “Overview of Numeric Types”
Section 18.5, “Restrictions and Limitations on Partitioning”

NO_ZERO_DATE

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.9, “Cast Functions and Operators”
Section 10.3, “Date and Time Types”

NO_ZERO_IN_DATE

Section 10.3, “Date and Time Types”

ONLY_FULL_GROUP_BY

Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”

PAD_CHAR_TO_FULL_LENGTH

Section 10.1.3, “Overview of String Types”
Section 10.4.1, “The CHAR and VARCHAR Types”

PIPES_AS_CONCAT

Section 11.2.1, “Operator Precedence”

REAL_AS_FLOAT

Section 10.2, “Numeric Types”
Section 10.1.1, “Overview of Numeric Types”

STRICT_ALL_TABLES

Section 5.5.2, “Adding User Accounts”
Section A.3, “MySQL 5.1 FAQ — Server SQL Mode”

STRICT_TRANS_TABLES

Section 5.5.2, “Adding User Accounts”
Section A.3, “MySQL 5.1 FAQ — Server SQL Mode”

TRADITIONAL

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