Movatterモバイル変換

Skip to Main Content

The world's most popular open source database

Developer Zone Downloads MySQL.com

Section Menu:

Documentation Home

MySQL 5.7 Reference Manual

Related Documentation

MySQL 5.7 Release Notes

Download this Manual

PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb

Excerpts from this Manual

MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL NDB Cluster 7.5

9.5
9.4
9.3
9.2
9.1
9.0
8.4 current
8.0

MySQL 5.7 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 11.2, “Date and Time Data Types”
Section 12.7, “Date and Time Functions”
Section B.3.4.2, “Problems Using DATE Columns”
Section 5.1.10, “Server SQL Modes”
Section 11.2.2, “The DATE, DATETIME, and TIMESTAMP Types”

ANSI

Section 2.10.3, “Changes in MySQL 5.7”
Section 9.2.5, “Function Name Parsing and Resolution”
Section 5.1.10, “Server SQL Modes”
Section 13.7.5.13, “SHOW CREATE VIEW Statement”
Section 24.3.31, “The INFORMATION_SCHEMA VIEWS Table”

ANSI_QUOTES

Section 13.1.18.5, “FOREIGN KEY Constraints”
Section 4.5.1.6, “mysql Client Tips”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 4.5.4, “mysqldump — A Database Backup Program”
Section 8.9.3, “Optimizer Hints”
Section 9.2, “Schema Object Names”
Section 5.1.10, “Server SQL Modes”
Section 9.1.1, “String Literals”

D

DB2

Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

E

ERROR_FOR_DIVISION_BY_ZERO

Section 12.21.3, “Expression Handling”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 12.21.5, “Precision Math Examples”
Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

H

HIGH_NOT_PRECEDENCE

Section 9.5, “Expressions”
Section 12.4.1, “Operator Precedence”
Section 5.1.10, “Server SQL Modes”

I

IGNORE_SPACE

Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 9.2.5, “Function Name Parsing and Resolution”
Section 4.5.1.1, “mysql Client Options”
Section 5.1.10, “Server SQL Modes”

M

MAXDB

Section 11.2.1, “Date and Time Data Type Syntax”
Section 5.1.10, “Server SQL Modes”
Section 11.2.2, “The DATE, DATETIME, and TIMESTAMP Types”
Section 1.3, “What Is New in MySQL 5.7”

MSSQL

Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

MYSQL323

Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

MYSQL40

Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

N

NO_AUTO_CREATE_USER

Section 13.7.1.4, “GRANT Statement”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

NO_AUTO_VALUE_ON_ZERO

Section 13.1.18, “CREATE TABLE Statement”
Section 11.1.6, “Numeric Type Attributes”
Section 5.1.10, “Server SQL Modes”
Section 3.6.9, “Using AUTO_INCREMENT”

NO_BACKSLASH_ESCAPES

Section 12.17.4, “Functions That Modify JSON Values”
Section 12.8.2, “Regular Expressions”
Section 5.1.10, “Server SQL Modes”
Section 12.8.1, “String Comparison Functions and Operators”
Section 9.1.1, “String Literals”
Section 11.5, “The JSON Data Type”

NO_DIR_IN_CREATE

Section 13.1.18, “CREATE TABLE Statement”
Section 16.4.1.11, “Replication and DIRECTORY Table Options”
Section 16.4.1.37, “Replication and Variables”
Section 5.1.10, “Server SQL Modes”
Section 22.2.6, “Subpartitioning”
Section 5.4.4, “The Binary Log”

NO_ENGINE_SUBSTITUTION

Section 13.1.8, “ALTER TABLE Statement”
Section 2.10.3, “Changes in MySQL 5.7”
Section 13.1.18, “CREATE TABLE Statement”
Section 5.5.1, “Installing and Uninstalling Plugins”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 5.1.10, “Server SQL Modes”
Section 15.1, “Setting the Storage Engine”
Section 16.3.3, “Using Replication with Different Source and Replica Storage Engines”
Section 1.3, “What Is New in MySQL 5.7”

NO_FIELD_OPTIONS

Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

NO_KEY_OPTIONS

Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

NO_TABLE_OPTIONS

Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

NO_UNSIGNED_SUBTRACTION

Section 12.6.1, “Arithmetic Operators”
Section 12.10, “Cast Functions and Operators”
Section 11.1.1, “Numeric Data Type Syntax”
Section 11.1.7, “Out-of-Range and Overflow Handling”
Section 22.6, “Restrictions and Limitations on Partitioning”
Section 5.1.10, “Server SQL Modes”

NO_ZERO_DATE

Section 11.2.6, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 12.10, “Cast Functions and Operators”
Section 13.1.18, “CREATE TABLE Statement”
Section 11.2, “Date and Time Data Types”
Section 12.7, “Date and Time Functions”
Section 13.2.6, “LOAD DATA Statement”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section B.3.4.2, “Problems Using DATE Columns”
Section 5.1.10, “Server SQL Modes”
Section 5.1.7, “Server System Variables”
Section 11.2.2, “The DATE, DATETIME, and TIMESTAMP Types”
Section 1.3, “What Is New in MySQL 5.7”

NO_ZERO_IN_DATE

Section 13.1.18, “CREATE TABLE Statement”
Section 11.2, “Date and Time Data Types”
Section 13.2.6, “LOAD DATA Statement”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section B.3.4.2, “Problems Using DATE Columns”
Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

O

ONLY_FULL_GROUP_BY

Section 2.10.3, “Changes in MySQL 5.7”
Section 3.3.4.8, “Counting Rows”
Section 12.19.2, “GROUP BY Modifiers”
Section 12.20, “Miscellaneous Functions”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 12.19.3, “MySQL Handling of GROUP BY”
Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

ORACLE

Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

P

PAD_CHAR_TO_FULL_LENGTH

Section 5.1.10, “Server SQL Modes”
Section 11.3.1, “String Data Type Syntax”
Section 11.3.2, “The CHAR and VARCHAR Types”

PIPES_AS_CONCAT

Section 9.5, “Expressions”
Section 12.4.3, “Logical Operators”
Section 12.4.1, “Operator Precedence”
Section 5.1.10, “Server SQL Modes”

POSTGRESQL

Section 5.1.10, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 5.7”

R

REAL_AS_FLOAT

Section 11.1.1, “Numeric Data Type Syntax”
Section 11.1, “Numeric Data Types”
Section 5.1.10, “Server SQL Modes”

S

STRICT_ALL_TABLES

Section 1.6.3.3, “Constraints on Invalid Data”
Section 12.21.3, “Expression Handling”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 5.1.10, “Server SQL Modes”
Section 16.4.3, “Upgrading a Replication Topology”

STRICT_TRANS_TABLES

Section 2.10.3, “Changes in MySQL 5.7”
Section 1.6.3.3, “Constraints on Invalid Data”
Section 12.21.3, “Expression Handling”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 5.1.10, “Server SQL Modes”
Section 16.4.3, “Upgrading a Replication Topology”
Section 1.3, “What Is New in MySQL 5.7”

T

TRADITIONAL

Section 11.2.6, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 12.21.3, “Expression Handling”
Section A.3, “MySQL 5.7 FAQ: Server SQL Mode”
Section 5.1.10, “Server SQL Modes”
Section 5.1.7, “Server System Variables”

PREV HOME UP NEXT

Related Documentation

MySQL 5.7 Release Notes

Download this Manual

PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb

Excerpts from this Manual

MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL NDB Cluster 7.5

[8]ページ先頭

©2009-2025 Movatter.jp