<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>SQL Modes Index</title><link rel="stylesheet" href="mysql-html.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.69.1"><link rel="start" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="up" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="prev" href="dynindex-priv.html" title="Privileges Index"><link rel="next" href="dynindex-statvar.html" title="Status Variable Index"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">SQL Modes Index</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="dynindex-priv.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="dynindex-statvar.html">Next</a></td></tr></table><hr></div><div class="index"><div class="titlepage"><div><div><h2 class="title"><a name="dynindex-sqlmode"></a>SQL Modes Index</h2></div></div></div><div class="indexdiv"><h3 class="title"><code class="literal">ALLOW_INVALID_DATES</code></h3><dl><dt><a href="data-types.html#date-and-time-types" title="10.3. Date and Time Types">Section 10.3, “Date and Time Types”</a></dt><dt><a href="error-handling.html#using-date" title="B.1.5.2. Problems Using DATE Columns">Section B.1.5.2, “Problems Using <code class="literal">DATE</code> Columns”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="data-types.html#datetime" title="10.3.1. The DATETIME,
DATE, and
TIMESTAMP Types">Section 10.3.1, “The <code class="literal">DATETIME</code>,
<code class="literal">DATE</code>, and
<code class="literal">TIMESTAMP</code> Types”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ANSI</code></h3><dl><dt><a href="sql-syntax.html#show-create-view" title="12.5.5.14. SHOW CREATE VIEW Syntax">Section 12.5.5.14, “<code class="literal">SHOW CREATE VIEW</code> Syntax”</a></dt><dt><a href="language-structure.html#function-resolution" title="8.2.4. Function Name Parsing and Resolution">Section 8.2.4, “Function Name Parsing and Resolution”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="information-schema.html#views-table" title="20.15. The INFORMATION_SCHEMA VIEWS Table">Section 20.15, “The <code class="literal">INFORMATION_SCHEMA VIEWS</code> Table”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ANSI_QUOTES</code></h3><dl><dt><a href="storage-engines.html#innodb-foreign-key-constraints" title="13.6.4.4. FOREIGN KEY Constraints">Section 13.6.4.4, “<code class="literal">FOREIGN KEY</code> Constraints”</a></dt><dt><a href="language-structure.html#identifiers" title="8.2. Schema Object Names">Section 8.2, “Schema Object Names”</a></dt><dt><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump-description.html" target="_top">Description</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="language-structure.html#string-syntax" title="8.1.1. Strings">Section 8.1.1, “Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DB2</code></h3><dl><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ERROR_FOR_DIVISION_BY_ZERO</code></h3><dl><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">HIGH_NOT_PRECEDENCE</code></h3><dl><dt><a href="functions.html#operator-precedence" title="11.2.1. Operator Precedence">Section 11.2.1, “Operator Precedence”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IGNORE_SPACE</code></h3><dl><dt><a href="programs.html#mysql-command-options" title="4.5.1.1. mysql Options">Section 4.5.1.1, “<span><strong class="command">mysql</strong></span> Options”</a></dt><dt><a href="sql-syntax.html#create-procedure" title="12.1.15. CREATE PROCEDURE and
CREATE FUNCTION Syntax">Section 12.1.15, “<code class="literal">CREATE PROCEDURE</code> and
<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="language-structure.html#function-resolution" title="8.2.4. Function Name Parsing and Resolution">Section 8.2.4, “Function Name Parsing and Resolution”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MAXDB</code></h3><dl><dt><a href="data-types.html#timestamp" title="10.3.1.1. TIMESTAMP Properties">Section 10.3.1.1, “<code class="literal">TIMESTAMP</code> Properties”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MSSQL</code></h3><dl><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MYSQL323</code></h3><dl><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MYSQL40</code></h3><dl><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NO_AUTO_CREATE_USER</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="server-administration.html#adding-users" title="5.5.2. Adding User Accounts">Section 5.5.2, “Adding User Accounts”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NO_AUTO_VALUE_ON_ZERO</code></h3><dl><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NO_BACKSLASH_ESCAPES</code></h3><dl><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="functions.html#string-comparison-functions" title="11.4.1. String Comparison Functions">Section 11.4.1, “String Comparison Functions”</a></dt><dt><a href="language-structure.html#string-syntax" title="8.1.1. Strings">Section 8.1.1, “Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NO_DIR_IN_CREATE</code></h3><dl><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="partitioning.html#partitioning-overview" title="18.1. Overview of Partitioning in MySQL">Section 18.1, “Overview of Partitioning in MySQL”</a></dt><dt><a href="replication.html#replication-features" title="16.3.1. Replication Features and Issues">Section 16.3.1, “Replication Features and Issues”</a></dt><dt><a href="replication.html#replication-features-directory" title="16.3.1.6. Replication and DIRECTORY Table Options">Section 16.3.1.6, “Replication and <code class="literal">DIRECTORY</code> Table Options”</a></dt><dt><a href="replication.html#replication-features-variables" title="16.3.1.30. Replication and Variables">Section 16.3.1.30, “Replication and Variables”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="partitioning.html#partitioning-subpartitions" title="18.2.5. Subpartitioning">Section 18.2.5, “Subpartitioning”</a></dt><dt><a href="server-administration.html#binary-log" title="5.2.4. The Binary Log">Section 5.2.4, “The Binary Log”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NO_ENGINE_SUBSTITUTION</code></h3><dl><dt><a href="sql-syntax.html#alter-table" title="12.1.7. ALTER TABLE Syntax">Section 12.1.7, “<code class="literal">ALTER TABLE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="server-administration.html#server-plugin-options" title="5.1.3. Server Options for Loading Plugins">Section 5.1.3, “Server Options for Loading Plugins”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NO_FIELD_OPTIONS</code></h3><dl><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NO_KEY_OPTIONS</code></h3><dl><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NO_TABLE_OPTIONS</code></h3><dl><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NO_UNSIGNED_SUBTRACTION</code></h3><dl><dt><a href="data-types.html#numeric-types" title="10.2. Numeric Types">Section 10.2, “Numeric Types”</a></dt><dt><a href="data-types.html#numeric-type-overview" title="10.1.1. Overview of Numeric Types">Section 10.1.1, “Overview of Numeric Types”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="installing.html#upgrading-from-previous-series" title="2.4.1.1. Upgrading from MySQL 5.0 to 5.1">Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NO_ZERO_DATE</code></h3><dl><dt><a href="data-types.html#timestamp" title="10.3.1.1. TIMESTAMP Properties">Section 10.3.1.1, “<code class="literal">TIMESTAMP</code> Properties”</a></dt><dt><a href="functions.html#cast-functions" title="11.9. Cast Functions and Operators">Section 11.9, “Cast Functions and Operators”</a></dt><dt><a href="data-types.html#date-and-time-types" title="10.3. Date and Time Types">Section 10.3, “Date and Time Types”</a></dt><dt><a href="error-handling.html#using-date" title="B.1.5.2. Problems Using DATE Columns">Section B.1.5.2, “Problems Using <code class="literal">DATE</code> Columns”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NO_ZERO_IN_DATE</code></h3><dl><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="data-types.html#date-and-time-types" title="10.3. Date and Time Types">Section 10.3, “Date and Time Types”</a></dt><dt><a href="error-handling.html#using-date" title="B.1.5.2. Problems Using DATE Columns">Section B.1.5.2, “Problems Using <code class="literal">DATE</code> Columns”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ONLY_FULL_GROUP_BY</code></h3><dl><dt><a href="functions.html#group-by-hidden-columns" title="11.12.3. GROUP BY and HAVING with Hidden
Columns">Section 11.12.3, “<code class="literal">GROUP BY</code> and <code class="literal">HAVING</code> with Hidden
Columns”</a></dt><dt><a href="tutorial.html#counting-rows" title="3.3.4.8. Counting Rows">Section 3.3.4.8, “Counting Rows”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ORACLE</code></h3><dl><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PAD_CHAR_TO_FULL_LENGTH</code></h3><dl><dt><a href="data-types.html#string-type-overview" title="10.1.3. Overview of String Types">Section 10.1.3, “Overview of String Types”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="data-types.html#char" title="10.4.1. The CHAR and
VARCHAR Types">Section 10.4.1, “The <code class="literal">CHAR</code> and
<code class="literal">VARCHAR</code> Types”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PIPES_AS_CONCAT</code></h3><dl><dt><a href="functions.html#operator-precedence" title="11.2.1. Operator Precedence">Section 11.2.1, “Operator Precedence”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">POSTGRESQL</code></h3><dl><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REAL_AS_FLOAT</code></h3><dl><dt><a href="data-types.html#numeric-types" title="10.2. Numeric Types">Section 10.2, “Numeric Types”</a></dt><dt><a href="data-types.html#numeric-type-overview" title="10.1.1. Overview of Numeric Types">Section 10.1.1, “Overview of Numeric Types”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STRICT_ALL_TABLES</code></h3><dl><dt><a href="server-administration.html#adding-users" title="5.5.2. Adding User Accounts">Section 5.5.2, “Adding User Accounts”</a></dt><dt><a href="introduction.html#constraint-invalid-data" title="1.7.6.2. Constraints on Invalid Data">Section 1.7.6.2, “Constraints on Invalid Data”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STRICT_TRANS_TABLES</code></h3><dl><dt><a href="server-administration.html#adding-users" title="5.5.2. Adding User Accounts">Section 5.5.2, “Adding User Accounts”</a></dt><dt><a href="introduction.html#constraint-invalid-data" title="1.7.6.2. Constraints on Invalid Data">Section 1.7.6.2, “Constraints on Invalid Data”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TRADITIONAL</code></h3><dl><dt><a href="data-types.html#timestamp" title="10.3.1.1. TIMESTAMP Properties">Section 10.3.1.1, “<code class="literal">TIMESTAMP</code> Properties”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="dynindex-priv.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="dynindex-statvar.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Privileges Index </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> Status Variable Index</td></tr></table></div></body></html>
