MySQL 实验室 因为专注,所以专业。

  • 首页
  • 博客
  • 下载
  • 文档
  • 工具
  • 知识库
  • 培训及服务
  • MySQL 5.1 Reference Manual :: SQL Modes Index
    • MySQL 5.1 Reference Manual
    • Preface, Notes, Licenses
    • 1 General Information
    • 2 Installing and Upgrading MySQL
    • 3 Tutorial
    • 4 MySQL Programs
    • 5 MySQL Server Administration
    • 6 Backup and Recovery
    • 7 Optimization
    • 8 Language Structure
    • 9 Internationalization and Localization
    • 10 Data Types
    • 11 Functions and Operators
    • 12 SQL Statement Syntax
    • 13 Storage Engines
    • 14 High Availability and Scalability
    • 15 MySQL Enterprise Monitor
    • 16 Replication
    • 17 MySQL Cluster NDB 6.X/7.X
    • 18 Partitioning
    • 19 Stored Programs and Views
    • 20 INFORMATION_SCHEMA Tables
    • 21 Connectors and APIs
    • 22 Extending MySQL
    • A MySQL 5.1 Frequently Asked Questions
    • B Errors, Error Codes, and Common Problems
    • C MySQL Change History
    • D Restrictions and Limits
    • Index
    • Standard Index
    • C Function Index
    • Command Index
    • Function Index
    • INFORMATION_SCHEMA Index
    • Transaction Isolation Level Index
    • JOIN Types Index
    • Operator Index
    • Option Index
    • Privileges Index
    • SQL Modes Index
    • Status Variable Index
    • Statement/Syntax Index
    • System Variable Index

    SQL Modes Index

    ALLOW_INVALID_DATES

    Section 11.6, “Date and Time Functions”
    Section 10.3, “Date and Time Types”
    Section B.5.5.2, “Problems Using DATE Columns”
    Section 5.1.7, “Server SQL Modes”
    Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”

    ANSI

    Section 12.4.5.14, “SHOW CREATE VIEW Syntax”
    Section 8.2.4, “Function Name Parsing and Resolution”
    Section 5.1.7, “Server SQL Modes”
    Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”

    ANSI_QUOTES

    Section 13.6.4.4, “FOREIGN KEY Constraints”
    Section 8.2, “Schema Object Names”
    Description
    Section 1.8.4, “MySQL Extensions to Standard SQL”
    Section 5.1.7, “Server SQL Modes”
    Section 8.1.1, “Strings”

    DB2

    Section 5.1.7, “Server SQL Modes”

    ERROR_FOR_DIVISION_BY_ZERO

    Section 5.1.7, “Server SQL Modes”

    HIGH_NOT_PRECEDENCE

    Section 11.2.1, “Operator Precedence”
    Section 5.1.7, “Server SQL Modes”

    IGNORE_SPACE

    Section 4.5.1.1, “mysql Options”
    Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
    Section 8.2.4, “Function Name Parsing and Resolution”
    Section 5.1.7, “Server SQL Modes”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    MAXDB

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

    MSSQL

    Section 5.1.7, “Server SQL Modes”

    MYSQL323

    Section 5.1.7, “Server SQL Modes”

    MYSQL40

    Section 5.1.7, “Server SQL Modes”

    NO_AUTO_CREATE_USER

    Section 12.4.1.3, “GRANT Syntax”
    Section 5.5.2, “Adding User Accounts”
    Section 5.1.7, “Server SQL Modes”

    NO_AUTO_VALUE_ON_ZERO

    Section 12.1.17, “CREATE TABLE Syntax”
    Section 5.1.7, “Server SQL Modes”

    NO_BACKSLASH_ESCAPES

    Section 5.1.7, “Server SQL Modes”
    Section 11.4.1, “String Comparison Functions”
    Section 8.1.1, “Strings”

    NO_DIR_IN_CREATE

    Section 12.1.17, “CREATE TABLE Syntax”
    Section 18.1, “Overview of Partitioning in MySQL”
    Section 16.4.1.7, “Replication and DIRECTORY Table Options”
    Section 16.4.1.31, “Replication and Variables”
    Section 5.1.7, “Server SQL Modes”
    Section 18.2.5, “Subpartitioning”
    Section 5.2.4, “The Binary Log”

    NO_ENGINE_SUBSTITUTION

    Section 12.1.7, “ALTER TABLE Syntax”
    Section 12.1.17, “CREATE TABLE Syntax”
    Section 5.1.3, “Server Options for Loading Plugins”
    Section 5.1.7, “Server SQL Modes”
    Section 13.3, “Setting the Storage Engine”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    NO_FIELD_OPTIONS

    Section 5.1.7, “Server SQL Modes”

    NO_KEY_OPTIONS

    Section 5.1.7, “Server SQL Modes”

    NO_TABLE_OPTIONS

    Section 5.1.7, “Server SQL Modes”

    NO_UNSIGNED_SUBTRACTION

    Section 10.2, “Numeric Types”
    Section 10.1.1, “Overview of Numeric Types”
    Section 18.5, “Restrictions and Limitations on Partitioning”
    Section 5.1.7, “Server SQL Modes”
    Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”

    NO_ZERO_DATE

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

    NO_ZERO_IN_DATE

    Section 12.1.17, “CREATE TABLE Syntax”
    Section 10.3, “Date and Time Types”
    Section B.5.5.2, “Problems Using DATE Columns”
    Section 5.1.7, “Server SQL Modes”

    ONLY_FULL_GROUP_BY

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

    ORACLE

    Section 5.1.7, “Server SQL Modes”

    PAD_CHAR_TO_FULL_LENGTH

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

    PIPES_AS_CONCAT

    Section 11.2.1, “Operator Precedence”
    Section 5.1.7, “Server SQL Modes”

    POSTGRESQL

    Section 5.1.7, “Server SQL Modes”

    REAL_AS_FLOAT

    Section 10.2, “Numeric Types”
    Section 10.1.1, “Overview of Numeric Types”
    Section 5.1.7, “Server SQL Modes”

    STRICT_ALL_TABLES

    Section 5.5.2, “Adding User Accounts”
    Section 1.8.6.2, “Constraints on Invalid Data”
    Section 5.1.7, “Server SQL Modes”

    STRICT_TRANS_TABLES

    Section 5.5.2, “Adding User Accounts”
    Section 1.8.6.2, “Constraints on Invalid Data”
    Section 5.1.7, “Server SQL Modes”

    TRADITIONAL

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