MySQL :: MySQL 8.4 Reference Manual :: SQL Modes Index

Skip to Main Content

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

version 8.4

MySQL 8.4 Reference Manual / Indexes / Modes Index

SQL Modes Index

A | E | H | I | N | O | P | R | S | T

A

ALLOW_INVALID_DATES

Section 13.2, “Date and Time Data Types”
Section 14.7, “Date and Time Functions”
Section B.3.4.2, “Problems Using DATE Columns”
Section 7.1.11, “Server SQL Modes”
Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”

ANSI

Section 11.2.5, “Function Name Parsing and Resolution”
Section 7.1.11, “Server SQL Modes”
Section 15.7.7.14, “SHOW CREATE VIEW Statement”
Section 28.3.47, “The INFORMATION_SCHEMA VIEWS Table”

ANSI_QUOTES

Section 15.1.20.5, “FOREIGN KEY Constraints”
Section 6.5.1.6, “mysql Client Tips”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 6.5.4, “mysqldump — A Database Backup Program”
Section 10.9.3, “Optimizer Hints”
Section 11.2, “Schema Object Names”
Section 7.1.11, “Server SQL Modes”
Section 11.1.1, “String Literals”

E

ERROR_FOR_DIVISION_BY_ZERO

Section 14.24.3, “Expression Handling”
Section A.3, “MySQL 8.4 FAQ: Server SQL Mode”
Section 14.24.5, “Precision Math Examples”
Section 7.1.11, “Server SQL Modes”

H

HIGH_NOT_PRECEDENCE

Section 11.5, “Expressions”
Section 14.4.1, “Operator Precedence”
Section 7.1.11, “Server SQL Modes”

I

IGNORE_SPACE

Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 11.2.5, “Function Name Parsing and Resolution”
Section 6.5.1.1, “mysql Client Options”
Section 7.1.11, “Server SQL Modes”

N

NO_AUTO_VALUE_ON_ZERO

Section 15.1.20, “CREATE TABLE Statement”
Section 13.1.6, “Numeric Type Attributes”
Section 7.1.11, “Server SQL Modes”
Section 5.6.9, “Using AUTO_INCREMENT”

NO_BACKSLASH_ESCAPES

Section 14.17.4, “Functions That Modify JSON Values”
Section 14.8.2, “Regular Expressions”
Section 7.1.11, “Server SQL Modes”
Section 14.8.1, “String Comparison Functions and Operators”
Section 11.1.1, “String Literals”
Section 13.5, “The JSON Data Type”

NO_DIR_IN_CREATE

Section 15.1.20, “CREATE TABLE Statement”
Section 19.5.1.10, “Replication and DIRECTORY Table Options”
Section 19.5.1.39, “Replication and Variables”
Section 7.1.11, “Server SQL Modes”
Section 7.4.4, “The Binary Log”

NO_ENGINE_SUBSTITUTION

Section 15.1.9, “ALTER TABLE Statement”
Section 15.1.20, “CREATE TABLE Statement”
Section 7.6.1, “Installing and Uninstalling Plugins”
Section A.3, “MySQL 8.4 FAQ: Server SQL Mode”
Section 7.1.11, “Server SQL Modes”
Section 18.1, “Setting the Storage Engine”
Section 19.4.4, “Using Replication with Different Source and Replica Storage Engines”

NO_UNSIGNED_SUBTRACTION

Section 14.6.1, “Arithmetic Operators”
Section 14.10, “Cast Functions and Operators”
Section 13.1.1, “Numeric Data Type Syntax”
Section 13.1.7, “Out-of-Range and Overflow Handling”
Section 26.6, “Restrictions and Limitations on Partitioning”
Section 7.1.11, “Server SQL Modes”

NO_ZERO_DATE

Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 14.10, “Cast Functions and Operators”
Section 15.1.20, “CREATE TABLE Statement”
Section 13.2, “Date and Time Data Types”
Section 14.7, “Date and Time Functions”
Section 15.2.9, “LOAD DATA Statement”
Section A.3, “MySQL 8.4 FAQ: Server SQL Mode”
Section B.3.4.2, “Problems Using DATE Columns”
Section 7.1.11, “Server SQL Modes”
Section 7.1.8, “Server System Variables”
Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”

NO_ZERO_IN_DATE

Section 15.1.20, “CREATE TABLE Statement”
Section 13.2, “Date and Time Data Types”
Section 15.2.9, “LOAD DATA Statement”
Section A.3, “MySQL 8.4 FAQ: Server SQL Mode”
Section B.3.4.2, “Problems Using DATE Columns”
Section 7.1.11, “Server SQL Modes”

O

ONLY_FULL_GROUP_BY

Section 5.3.4.8, “Counting Rows”
Section 14.19.2, “GROUP BY Modifiers”
Section 14.23, “Miscellaneous Functions”
Section A.3, “MySQL 8.4 FAQ: Server SQL Mode”
Section 14.19.3, “MySQL Handling of GROUP BY”
Section 7.1.11, “Server SQL Modes”

P

PAD_CHAR_TO_FULL_LENGTH

Section 7.1.11, “Server SQL Modes”
Section 13.3.1, “String Data Type Syntax”
Section 13.3.2, “The CHAR and VARCHAR Types”

PIPES_AS_CONCAT

Section 11.5, “Expressions”
Section 14.4.3, “Logical Operators”
Section 14.4.1, “Operator Precedence”
Section 7.1.11, “Server SQL Modes”

R

REAL_AS_FLOAT

Section 13.1.1, “Numeric Data Type Syntax”
Section 13.1, “Numeric Data Types”
Section 7.1.11, “Server SQL Modes”

S

STRICT_ALL_TABLES

Section 14.24.3, “Expression Handling”
Section A.3, “MySQL 8.4 FAQ: Server SQL Mode”
Section 7.1.11, “Server SQL Modes”

STRICT_TRANS_TABLES

Section 14.24.3, “Expression Handling”
Section A.3, “MySQL 8.4 FAQ: Server SQL Mode”
Section 7.1.11, “Server SQL Modes”

T

TIME_TRUNCATE_FRACTIONAL

Section 13.2.6, “Fractional Seconds in Time Values”
Section 7.1.11, “Server SQL Modes”

TRADITIONAL

Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 14.24.3, “Expression Handling”
Section A.3, “MySQL 8.4 FAQ: Server SQL Mode”
Section 7.1.11, “Server SQL Modes”
Section 7.1.8, “Server System Variables”

PREV HOME UP NEXT