MySQL :: MySQL 5.6 Reference Manual :: SQL Modes Index

Contact MySQL |
Login | Register

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

version 5.6

8.0 current
5.7
5.5

5.6 Japanese

MySQL 5.6 Reference Manual / Indexes / Modes Index

SQL Modes Index

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

A

ALLOW_INVALID_DATES

Section 12.7, “Date and Time Functions”
Section 11.3, “Date and Time Types”
Section B.5.4.2, “Problems Using DATE Columns”
Section 5.1.10, “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.10, “Server SQL Modes”
Section 13.7.5.14, “SHOW CREATE VIEW Syntax”
Section 21.29, “The INFORMATION_SCHEMA VIEWS Table”

ANSI_QUOTES

Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 9.2, “Schema Object Names”
Section 5.1.10, “Server SQL Modes”
Section 9.1.1, “String Literals”
Section 13.1.17.6, “Using FOREIGN KEY Constraints”

D

DB2

Section 5.1.10, “Server SQL Modes”

E

ERROR_FOR_DIVISION_BY_ZERO

Section 12.20.3, “Expression Handling”
Section 12.20.5, “Precision Math Examples”
Section 5.1.10, “Server SQL Modes”
Section 1.4, “What Is New in MySQL 5.6”

H

HIGH_NOT_PRECEDENCE

Section 9.5, “Expression Syntax”
Section 12.3.1, “Operator Precedence”
Section 5.1.10, “Server SQL Modes”

I

IGNORE_SPACE

Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 9.2.4, “Function Name Parsing and Resolution”
Section 4.5.1.1, “mysql Options”
Section 5.1.10, “Server SQL Modes”

M

MAXDB

Section 11.1.2, “Date and Time Type Overview”
Section 5.1.10, “Server SQL Modes”
Section 11.3.1, “The DATE, DATETIME, and TIMESTAMP Types”

MSSQL

Section 5.1.10, “Server SQL Modes”

MYSQL323

Section 5.1.10, “Server SQL Modes”

MYSQL40

Section 5.1.10, “Server SQL Modes”

N

NO_AUTO_CREATE_USER

Section 13.7.1.4, “GRANT Syntax”
Section 5.1.10, “Server SQL Modes”

NO_AUTO_VALUE_ON_ZERO

Section 13.1.17, “CREATE TABLE Syntax”
Section 11.2.5, “Numeric Type Attributes”
Section 5.1.10, “Server SQL Modes”
Section 3.6.9, “Using AUTO_INCREMENT”

NO_BACKSLASH_ESCAPES

Section 5.1.10, “Server SQL Modes”
Section 12.5.1, “String Comparison Functions”
Section 9.1.1, “String Literals”

NO_DIR_IN_CREATE

Section 13.1.17, “CREATE TABLE Syntax”
Section 17.4.1.10, “Replication and DIRECTORY Table Options”
Section 17.4.1.36, “Replication and Variables”
Section 5.1.10, “Server SQL Modes”
Section 19.2.6, “Subpartitioning”
Section 5.4.4, “The Binary Log”

NO_ENGINE_SUBSTITUTION

Section 13.1.7, “ALTER TABLE Syntax”
Section 13.1.17, “CREATE TABLE Syntax”
Section 5.5.1, “Installing and Uninstalling Plugins”
Section A.3, “MySQL 5.6 FAQ: Server SQL Mode”
Section 5.1.6, “Server Command Options”
Section 5.1.10, “Server SQL Modes”
Section 5.1.7, “Server System Variables”
Section 15.1, “Setting the Storage Engine”
Section 5.1.2.2, “Using a Sample Default Server Configuration File”
Section 17.3.3, “Using Replication with Different Master and Slave Storage Engines”

NO_FIELD_OPTIONS

Section 5.1.10, “Server SQL Modes”

NO_KEY_OPTIONS

Section 5.1.10, “Server SQL Modes”

NO_TABLE_OPTIONS

Section 5.1.10, “Server SQL Modes”

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 19.6, “Restrictions and Limitations on Partitioning”
Section 5.1.10, “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.17, “CREATE TABLE Syntax”
Section 12.7, “Date and Time Functions”
Section 11.3, “Date and Time Types”
Section B.5.4.2, “Problems Using DATE Columns”
Section 5.1.10, “Server SQL Modes”
Section 5.1.7, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.6”

NO_ZERO_IN_DATE

Section 13.1.17, “CREATE TABLE Syntax”
Section 12.7, “Date and Time Functions”
Section 11.3, “Date and Time Types”
Section B.5.4.2, “Problems Using DATE Columns”
Section 5.1.10, “Server SQL Modes”
Section 1.4, “What Is New in MySQL 5.6”

O

ONLY_FULL_GROUP_BY

Section 3.3.4.8, “Counting Rows”
Section 12.18.2, “GROUP BY Modifiers”
Section 12.18.3, “MySQL Handling of GROUP BY”
Section 5.1.10, “Server SQL Modes”

ORACLE

Section 5.1.10, “Server SQL Modes”

P

PAD_CHAR_TO_FULL_LENGTH

Section 5.1.10, “Server SQL Modes”
Section 11.1.3, “String Type Overview”
Section 11.4.1, “The CHAR and VARCHAR Types”

PIPES_AS_CONCAT

Section 9.5, “Expression Syntax”
Section 12.3.1, “Operator Precedence”
Section 5.1.10, “Server SQL Modes”

POSTGRESQL

Section 5.1.10, “Server SQL Modes”

R

REAL_AS_FLOAT

Section 11.1.1, “Numeric Type Overview”
Section 11.2, “Numeric Types”
Section 5.1.10, “Server SQL Modes”

S

STRICT_ALL_TABLES

Section 1.7.3.3, “Constraints on Invalid Data”
Section 12.20.3, “Expression Handling”
Section A.3, “MySQL 5.6 FAQ: Server SQL Mode”
Section 5.1.10, “Server SQL Modes”
Section 17.4.3, “Upgrading a Replication Setup”
Section 1.4, “What Is New in MySQL 5.6”

STRICT_TRANS_TABLES

Section 1.7.3.3, “Constraints on Invalid Data”
Section 12.20.3, “Expression Handling”
Section A.3, “MySQL 5.6 FAQ: Server SQL Mode”
Section 5.1.10, “Server SQL Modes”
Section 17.4.3, “Upgrading a Replication Setup”
Section 5.1.2.2, “Using a Sample Default Server Configuration File”
Section 1.4, “What Is New in MySQL 5.6”

T

TRADITIONAL

Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 12.20.3, “Expression Handling”
Section 13.2.6, “LOAD DATA INFILE Syntax”
Section A.3, “MySQL 5.6 FAQ: Server SQL Mode”
Section 5.1.10, “Server SQL Modes”
Section 5.1.7, “Server System Variables”

PREV HOME UP NEXT

User Comments

User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.

Sign Up Login You must be logged in to post a comment.