SQL Modes Index
   

SQL Modes Index

ALLOW_INVALID_DATES

Section 11.7, “Date and Time Functions”
Section 10.3, “Date and Time Types”
Section C.5.5.2, “Problems Using DATE Columns”
Section 5.1.6, “Server SQL Modes”
Section 10.3.1, “The DATE, DATETIME, and TIMESTAMP Types”

ANSI

Section 12.7.5.14, “SHOW CREATE VIEW Синтаксис”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 5.1.6, “Server SQL Modes”
Section 19.28, “The INFORMATION_SCHEMA VIEWS Table”

ANSI_QUOTES

Section 13.3.5.4, “FOREIGN KEY Constraints”
Описание
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 8.2, “Schema Object Names”
Section 5.1.6, “Server SQL Modes”
Section 8.1.1, “String Literals”

DB2

Section 5.1.6, “Server SQL Modes”

ERROR_FOR_DIVISION_BY_ZERO

Section 11.18.3, “Expression Handling”
Section 11.18.5, “Precision Math Examples”
Section 5.1.6, “Server SQL Modes”

HIGH_NOT_PRECEDENCE

Section 8.5, “Expression Синтаксис”
Section 11.3.1, “Operator Precedence”
Section 5.1.6, “Server SQL Modes”

IGNORE_SPACE

Section 4.5.1.1, “mysql Options”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 5.1.6, “Server SQL Modes”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

MAXDB

Section 10.3.1.1, “TIMESTAMP Properties”
Section 5.1.6, “Server SQL Modes”

MSSQL

Section 5.1.6, “Server SQL Modes”

MYSQL323

Section 5.1.6, “Server SQL Modes”

MYSQL40

Section 5.1.6, “Server SQL Modes”

NO_AUTO_CREATE_USER

Section 12.7.1.3, “GRANT Синтаксис”
Section 5.5.2, “Adding User Accounts”
Section 5.1.6, “Server SQL Modes”

NO_AUTO_VALUE_ON_ZERO

Section 12.1.17, “CREATE TABLE Синтаксис”
Section 5.1.6, “Server SQL Modes”
Section 3.6.9, “Using AUTO_INCREMENT”

NO_BACKSLASH_ESCAPES

Section 5.1.6, “Server SQL Modes”
Section 11.5.1, “String Comparison Functions”
Section 8.1.1, “String Literals”

NO_DIR_IN_CREATE

Section 12.1.17, “CREATE TABLE Синтаксис”
Section 17.1, “Overview of Partitioning in MySQL”
Section 15.4.1.7, “Replication and DIRECTORY Table Options”
Section 15.4.1.33, “Replication and Variables”
Section 5.1.6, “Server SQL Modes”
Section 17.2.6, “Subpartitioning”
Section 5.2.4, “The Binary Log”

NO_ENGINE_SUBSTITUTION

Section 12.1.7, “ALTER TABLE Синтаксис”
Section 12.1.17, “CREATE TABLE Синтаксис”
Section 5.1.7.1, “Installing and Uninstalling Plugins”
Section 5.1.6, “Server SQL Modes”
Section 13.1, “Setting the Storage Engine”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 15.3.2, “Using Replication with Different Master and Slave Storage Engines”

NO_FIELD_OPTIONS

Section 5.1.6, “Server SQL Modes”

NO_KEY_OPTIONS

Section 5.1.6, “Server SQL Modes”

NO_TABLE_OPTIONS

Section 5.1.6, “Server SQL Modes”

NO_UNSIGNED_SUBTRACTION

Section 11.6.1, “Arithmetic Operators”
Section 11.10, “Cast Functions and Operators”
Section 10.1.1, “Numeric Type Overview”
Section 10.2.6, “Out-of-Range and Overflow Handling”
Section 17.5, “Restrictions and Limitations on Partitioning”
Section 5.1.6, “Server SQL Modes”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

NO_ZERO_DATE

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.10, “Cast Functions and Operators”
Section 10.3, “Date and Time Types”
Section C.5.5.2, “Problems Using DATE Columns”
Section 5.1.6, “Server SQL Modes”

NO_ZERO_IN_DATE

Section 12.1.17, “CREATE TABLE Синтаксис”
Section 10.3, “Date and Time Types”
Section C.5.5.2, “Problems Using DATE Columns”
Section 5.1.6, “Server SQL Modes”

ONLY_FULL_GROUP_BY

Section 11.16.3, “GROUP BY and HAVING with Hidden Columns”
Section 3.3.4.8, “Counting Rows”
Section 5.1.6, “Server SQL Modes”

ORACLE

Section 5.1.6, “Server SQL Modes”

PAD_CHAR_TO_FULL_LENGTH

Section 5.1.6, “Server SQL Modes”
Section 10.1.3, “String Type Overview”
Section 10.4.1, “The CHAR and VARCHAR Types”

PIPES_AS_CONCAT

Section 8.5, “Expression Синтаксис”
Section 11.3.1, “Operator Precedence”
Section 5.1.6, “Server SQL Modes”

POSTGRESQL

Section 5.1.6, “Server SQL Modes”

REAL_AS_FLOAT

Section 10.1.1, “Numeric Type Overview”
Section 10.2, “Numeric Types”
Section 5.1.6, “Server SQL Modes”

STRICT_ALL_TABLES

Section 5.5.2, “Adding User Accounts”
Section 1.8.6.2, “Constraints on Invalid Data”
Section 11.18.3, “Expression Handling”
Section 5.1.6, “Server SQL Modes”

STRICT_TRANS_TABLES

Section 5.5.2, “Adding User Accounts”
Section 1.8.6.2, “Constraints on Invalid Data”
Section 11.18.3, “Expression Handling”
Section 5.1.6, “Server SQL Modes”

TRADITIONAL

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.18.3, “Expression Handling”
Section 5.1.6, “Server SQL Modes”
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices
   
Privileges Index Начало Status Variable Index
    Поддержать сайт на родительском проекте КГБ