SQL Modes Index
Prev
Next
SQL Modes Index
A
|
D
|
E
|
H
|
I
|
M
|
N
|
O
|
P
|
R
|
S
|
T
A
[
index top
]
ALLOW_INVALID_DATES
Section 13.7, “Date and Time Functions”
Section 12.3, “Date and Time Types”
Section B.5.4.2, “Problems Using DATE Columns”
Section 6.1.8, “Server SQL Modes”
Section 12.3.1, “The DATE, DATETIME, and TIMESTAMP Types”
ANSI
Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section 10.2.4, “Function Name Parsing and Resolution”
Section 6.1.8, “Server SQL Modes”
Section 14.7.5.13, “SHOW CREATE VIEW Syntax”
Section 24.30, “The INFORMATION_SCHEMA VIEWS Table”
ANSI_QUOTES
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 27.8.7.56, “mysql_real_escape_string_quote()”
Section 5.5.4, “
mysqldump
— A Database Backup Program”
Section 9.9.3, “Optimizer Hints”
Section 10.2, “Schema Object Names”
Section 6.1.8, “Server SQL Modes”
Section 10.1.1, “String Literals”
Section 14.1.18.5, “Using FOREIGN KEY Constraints”
D
[
index top
]
DB2
Section 6.1.8, “Server SQL Modes”
E
[
index top
]
ERROR_FOR_DIVISION_BY_ZERO
Section 13.21.3, “Expression Handling”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 13.21.5, “Precision Math Examples”
Section 6.1.8, “Server SQL Modes”
Section 1.4, “What Is New in MySQL 5.7”
H
[
index top
]
HIGH_NOT_PRECEDENCE
Section 10.5, “Expression Syntax”
Section 13.3.1, “Operator Precedence”
Section 6.1.8, “Server SQL Modes”
I
[
index top
]
IGNORE_SPACE
Section 14.1.16, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 10.2.4, “Function Name Parsing and Resolution”
Section 5.5.1.1, “mysql Options”
Section 6.1.8, “Server SQL Modes”
M
[
index top
]
MAXDB
Section 12.1.2, “Date and Time Type Overview”
Section 6.1.8, “Server SQL Modes”
Section 12.3.1, “The DATE, DATETIME, and TIMESTAMP Types”
MSSQL
Section 6.1.8, “Server SQL Modes”
MYSQL323
Section 6.1.8, “Server SQL Modes”
MYSQL40
Section 6.1.8, “Server SQL Modes”
N
[
index top
]
NO_AUTO_CREATE_USER
Section 14.7.1.4, “GRANT Syntax”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 6.1.8, “Server SQL Modes”
Section 1.4, “What Is New in MySQL 5.7”
NO_AUTO_VALUE_ON_ZERO
Section 14.1.18, “CREATE TABLE Syntax”
Section 12.2.5, “Numeric Type Attributes”
Section 6.1.8, “Server SQL Modes”
Section 4.6.9, “Using AUTO_INCREMENT”
NO_BACKSLASH_ESCAPES
Section 13.16.4, “Functions That Modify JSON Values”
Section 27.8.7.55, “mysql_real_escape_string()”
Section 6.1.8, “Server SQL Modes”
Section 13.5.1, “String Comparison Functions”
Section 10.1.1, “String Literals”
Section 12.6, “The JSON Data Type”
NO_DIR_IN_CREATE
Section 14.1.18, “CREATE TABLE Syntax”
Section 18.4.1.11, “Replication and DIRECTORY Table Options”
Section 18.4.1.38, “Replication and Variables”
Section 6.1.8, “Server SQL Modes”
Section 22.2.6, “Subpartitioning”
Section 6.4.4, “The Binary Log”
NO_ENGINE_SUBSTITUTION
Section 14.1.8, “ALTER TABLE Syntax”
Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section 14.1.18, “CREATE TABLE Syntax”
Section 6.5.2, “Installing and Uninstalling Plugins”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 6.1.8, “Server SQL Modes”
Section 16.1, “Setting the Storage Engine”
Section 18.3.3, “Using Replication with Different Master and Slave Storage Engines”
Section 1.4, “What Is New in MySQL 5.7”
NO_FIELD_OPTIONS
Section 6.1.8, “Server SQL Modes”
NO_KEY_OPTIONS
Section 6.1.8, “Server SQL Modes”
NO_TABLE_OPTIONS
Section 6.1.8, “Server SQL Modes”
NO_UNSIGNED_SUBTRACTION
Section 13.6.1, “Arithmetic Operators”
Section 13.10, “Cast Functions and Operators”
Section 12.1.1, “Numeric Type Overview”
Section 12.2.6, “Out-of-Range and Overflow Handling”
Section 22.6, “Restrictions and Limitations on Partitioning”
Section 6.1.8, “Server SQL Modes”
NO_ZERO_DATE
Section 12.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.10, “Cast Functions and Operators”
Section 14.1.18, “CREATE TABLE Syntax”
Section 13.7, “Date and Time Functions”
Section 12.3, “Date and Time Types”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section B.5.4.2, “Problems Using DATE Columns”
Section 6.1.8, “Server SQL Modes”
Section 1.4, “What Is New in MySQL 5.7”
NO_ZERO_IN_DATE
Section 14.1.18, “CREATE TABLE Syntax”
Section 13.7, “Date and Time Functions”
Section 12.3, “Date and Time Types”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section B.5.4.2, “Problems Using DATE Columns”
Section 6.1.8, “Server SQL Modes”
Section 1.4, “What Is New in MySQL 5.7”
O
[
index top
]
ONLY_FULL_GROUP_BY
Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section 4.3.4.8, “Counting Rows”
Section 13.19.2, “GROUP BY Modifiers”
Section 13.20, “Miscellaneous Functions”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 13.19.3, “MySQL Handling of GROUP BY”
Section 6.1.8, “Server SQL Modes”
Section 1.4, “What Is New in MySQL 5.7”
ORACLE
Section 6.1.8, “Server SQL Modes”
P
[
index top
]
PAD_CHAR_TO_FULL_LENGTH
Section 6.1.8, “Server SQL Modes”
Section 12.1.3, “String Type Overview”
Section 12.4.1, “The CHAR and VARCHAR Types”
PIPES_AS_CONCAT
Section 10.5, “Expression Syntax”
Section 13.3.1, “Operator Precedence”
Section 6.1.8, “Server SQL Modes”
POSTGRESQL
Section 6.1.8, “Server SQL Modes”
R
[
index top
]
REAL_AS_FLOAT
Section 12.1.1, “Numeric Type Overview”
Section 12.2, “Numeric Types”
Section 6.1.8, “Server SQL Modes”
S
[
index top
]
STRICT_ALL_TABLES
Section 1.8.3.3, “Constraints on Invalid Data”
Section 13.21.3, “Expression Handling”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 6.1.8, “Server SQL Modes”
Section 18.4.3, “Upgrading a Replication Setup”
STRICT_TRANS_TABLES
Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section 1.8.3.3, “Constraints on Invalid Data”
Section 13.21.3, “Expression Handling”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 6.1.8, “Server SQL Modes”
Section 18.4.3, “Upgrading a Replication Setup”
Section 1.4, “What Is New in MySQL 5.7”
T
[
index top
]
TRADITIONAL
Section 12.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.21.3, “Expression Handling”
Section 14.2.6, “LOAD DATA INFILE Syntax”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 6.1.8, “Server SQL Modes”