SQL Modes Index

A

[index top]

ANSI

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”

Section 8.2.3, “Function Name Parsing and Resolution”

Section 5.1.6, “Server SQL Modes”

ANSI_QUOTES

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”

Section 8.2, “Database, Table, Index, Column, and Alias Names”

Section 13.2.5.4, “FOREIGN KEY Constraints”

Section 1.9.4, “MySQL Extensions to Standard SQL”

Section 4.5.4, “mysqldump — A Database Backup Program”

Section 5.1.6, “Server SQL Modes”

Section 8.1.1, “String Literals”

D

[index top]

DB2

Section 5.1.6, “Server SQL Modes”

I

[index top]

IGNORE_SPACE

Section C.1.21, “Changes in MySQL 4.1.5 (2004-09-16)”

Section 8.2.3, “Function Name Parsing and Resolution”

Section 4.5.1.1, “mysql Options”

Section 5.1.6, “Server SQL Modes”

M

[index top]

MAXDB

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”

Section 5.1.6, “Server SQL Modes”

Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”

Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”

MSSQL

Section 5.1.6, “Server SQL Modes”

MYSQL323

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”

Section 5.1.6, “Server SQL Modes”

MYSQL40

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”

Section 5.1.6, “Server SQL Modes”

N

[index top]

NO_AUTO_VALUE_ON_ZERO

Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”

Section C.1.20, “Changes in MySQL 4.1.6 (2004-10-10)”

Section 12.1.5, “CREATE TABLE Syntax”

Section 5.1.6, “Server SQL Modes”

Section 3.6.9, “Using AUTO_INCREMENT”

NO_BACKSLASH_ESCAPES

Section C.1.6, “Changes in MySQL 4.1.20 (2006-05-24)”

NO_DIR_IN_CREATE

Section 14.7.3, “Replication and DIRECTORY Table Options”

Section 5.1.6, “Server SQL Modes”

NO_FIELD_OPTIONS

Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”

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 C.2.30, “Changes in Release 4.0.2 (01 July 2002)”

Section 10.1.1, “Numeric Type Overview”

Section 10.2.5, “Out-of-Range and Overflow Handling”

Section 5.1.6, “Server SQL Modes”

O

[index top]

ONLY_FULL_GROUP_BY

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”

Section 11.15.2, “GROUP BY Modifiers”

Section 11.15.3, “MySQL Handling of GROUP BY”

Section 5.1.6, “Server SQL Modes”

ORACLE

Section 5.1.6, “Server SQL Modes”

P

[index top]

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”

R

[index top]

REAL_AS_FLOAT

Section 10.1.1, “Numeric Type Overview”

Section 10.2, “Numeric Types”

Section 5.1.6, “Server SQL Modes”