SQL Modes Index
Prev
Next
SQL Modes Index
A
|
E
|
H
|
I
|
N
|
O
|
P
|
R
|
S
|
T
A
[
index top
]
ALLOW_INVALID_DATES
Section 12.7, “Date and Time Functions”
Section 11.3, “Date and Time Types”
Section B.6.4.2, “Problems Using DATE Columns”
Section 5.1.11, “Server SQL Modes”
Section 11.3.1, “The DATE, DATETIME, and TIMESTAMP Types”
ANSI
Section 9.2.4, “Function Name Parsing and Resolution”
Section 5.1.11, “Server SQL Modes”
Section 13.7.6.13, “SHOW CREATE VIEW Syntax”
Section 25.35, “The INFORMATION_SCHEMA VIEWS Table”
ANSI_QUOTES
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 28.7.7.56, “mysql_real_escape_string_quote()”
Section 4.5.4, “
mysqldump
— A Database Backup Program”
Section 8.9.2, “Optimizer Hints”
Section 9.2, “Schema Object Names”
Section 5.1.11, “Server SQL Modes”
Section 9.1.1, “String Literals”
Section 13.1.20.6, “Using FOREIGN KEY Constraints”
E
[
index top
]
ERROR_FOR_DIVISION_BY_ZERO
Section 12.24.3, “Expression Handling”
Section A.3, “MySQL 8.0 FAQ: Server SQL Mode”
Section 12.24.5, “Precision Math Examples”
Section 23.6, “Restrictions and Limitations on Partitioning”
Section 5.1.11, “Server SQL Modes”
H
[
index top
]
HIGH_NOT_PRECEDENCE
Section 9.5, “Expressions”
Section 12.3.1, “Operator Precedence”
Section 5.1.11, “Server SQL Modes”
I
[
index top
]
IGNORE_SPACE
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 9.2.4, “Function Name Parsing and Resolution”
Section 4.5.1.1, “mysql Client Options”
Section 5.1.11, “Server SQL Modes”
N
[
index top
]
NO_AUTO_CREATE_USER
Section 22.1.4, “What is New in NDB Cluster”
NO_AUTO_VALUE_ON_ZERO
Section 13.1.20, “CREATE TABLE Syntax”
Section 11.2.5, “Numeric Type Attributes”
Section 5.1.11, “Server SQL Modes”
Section 3.6.9, “Using AUTO_INCREMENT”
NO_BACKSLASH_ESCAPES
Section 12.17.4, “Functions That Modify JSON Values”
Section 28.7.7.55, “mysql_real_escape_string()”
Section 5.1.11, “Server SQL Modes”
Section 12.5.1, “String Comparison Functions”
Section 9.1.1, “String Literals”
Section 11.6, “The JSON Data Type”
NO_DIR_IN_CREATE
Section 13.1.20, “CREATE TABLE Syntax”
Section 17.4.1.10, “Replication and DIRECTORY Table Options”
Section 17.4.1.39, “Replication and Variables”
Section 5.1.11, “Server SQL Modes”
Section 5.4.4, “The Binary Log”
NO_ENGINE_SUBSTITUTION
Section 13.1.9, “ALTER TABLE Syntax”
Section 13.1.20, “CREATE TABLE Syntax”
Section 5.6.1, “Installing and Uninstalling Plugins”
Section A.3, “MySQL 8.0 FAQ: Server SQL Mode”
Section 5.1.11, “Server SQL Modes”
Section 16.1, “Setting the Storage Engine”
Section 17.3.4, “Using Replication with Different Master and Slave Storage Engines”
NO_UNSIGNED_SUBTRACTION
Section 12.6.1, “Arithmetic Operators”
Section 12.10, “Cast Functions and Operators”
Section 11.1.1, “Numeric Type Overview”
Section 11.2.6, “Out-of-Range and Overflow Handling”
Section 23.6, “Restrictions and Limitations on Partitioning”
Section 5.1.11, “Server SQL Modes”
NO_ZERO_DATE
Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 12.10, “Cast Functions and Operators”
Section 13.1.20, “CREATE TABLE Syntax”
Section 12.7, “Date and Time Functions”
Section 11.3, “Date and Time Types”
Section A.3, “MySQL 8.0 FAQ: Server SQL Mode”
Section B.6.4.2, “Problems Using DATE Columns”
Section 5.1.11, “Server SQL Modes”
Section 5.1.8, “Server System Variables”
NO_ZERO_IN_DATE
Section 13.1.20, “CREATE TABLE Syntax”
Section 12.7, “Date and Time Functions”
Section 11.3, “Date and Time Types”
Section A.3, “MySQL 8.0 FAQ: Server SQL Mode”
Section B.6.4.2, “Problems Using DATE Columns”
Section 5.1.11, “Server SQL Modes”
O
[
index top
]
ONLY_FULL_GROUP_BY
Section 3.3.4.8, “Counting Rows”
Section 12.20.2, “GROUP BY Modifiers”
Section 12.23, “Miscellaneous Functions”
Section A.3, “MySQL 8.0 FAQ: Server SQL Mode”
Section 12.20.3, “MySQL Handling of GROUP BY”
Section 5.1.11, “Server SQL Modes”
P
[
index top
]
PAD_CHAR_TO_FULL_LENGTH
Section 5.1.11, “Server SQL Modes”
Section 11.1.3, “String Type Overview”
Section 11.4.1, “The CHAR and VARCHAR Types”
Section 1.4, “What Is New in MySQL 8.0”
PIPES_AS_CONCAT
Section 9.5, “Expressions”
Section 12.3.1, “Operator Precedence”
Section 5.1.11, “Server SQL Modes”
R
[
index top
]
REAL_AS_FLOAT
Section 11.1.1, “Numeric Type Overview”
Section 11.2, “Numeric Types”
Section 5.1.11, “Server SQL Modes”
S
[
index top
]
STRICT_ALL_TABLES
Section 1.8.3.3, “Constraints on Invalid Data”
Section 12.24.3, “Expression Handling”
Section A.3, “MySQL 8.0 FAQ: Server SQL Mode”
Section 5.1.11, “Server SQL Modes”
Section 17.4.3, “Upgrading a Replication Setup”
STRICT_TRANS_TABLES
Section 1.8.3.3, “Constraints on Invalid Data”
Section 12.24.3, “Expression Handling”
Section A.3, “MySQL 8.0 FAQ: Server SQL Mode”
Section 5.1.11, “Server SQL Modes”
Section 17.4.3, “Upgrading a Replication Setup”
T
[
index top
]
TIME_TRUNCATE_FRACTIONAL
Section 11.3.6, “Fractional Seconds in Time Values”
Section 5.1.11, “Server SQL Modes”
TRADITIONAL
Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 12.24.3, “Expression Handling”
Section 13.2.7, “LOAD DATA Syntax”
Section A.3, “MySQL 8.0 FAQ: Server SQL Mode”
Section 5.1.11, “Server SQL Modes”
Section 5.1.8, “Server System Variables”