<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Function 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-command.html" title="Command Index"><link rel="next" href="dynindex-is.html" title="INFORMATION_SCHEMA 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">Function Index</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="dynindex-command.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="dynindex-is.html">Next</a></td></tr></table><hr></div><div class="index"><div class="titlepage"><div><div><h2 class="title"><a name="dynindex-function"></a>Function Index</h2></div></div></div><div class="indexdiv"><h3 class="title"><code class="literal">%</code></h3><dl><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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ABS()</code></h3><dl><dt><a href="sql-syntax.html#create-function-udf" title="12.5.3.1. CREATE FUNCTION Syntax">Section 12.5.3.1, “<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="extending-mysql.html#adding-functions" title="22.3. Adding New Functions to MySQL">Section 22.3, “Adding New Functions to MySQL”</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="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ABS(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ACOS(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ADDDATE()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ADDDATE(date,INTERVAL expr unit)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ADDDATE(expr,days)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ADDTIME()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ADDTIME(expr1,expr2)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AES_DECRYPT()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AES_DECRYPT(crypt_str,key_str)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AES_ENCRYPT()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AES_ENCRYPT(str,key_str)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ASCII()</code></h3><dl><dt><a href="sql-syntax.html#help" title="12.3.3. HELP Syntax">Section 12.3.3, “<code class="literal">HELP</code> Syntax”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ASCII(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ASIN(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ATAN(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ATAN(Y,X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ATAN2(Y,X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AVG()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><dt><a href="data-types.html#date-and-time-type-overview" title="10.1.2. Overview of Date and Time Types">Section 10.1.2, “Overview of Date and Time Types”</a></dt><dt><a href="data-types.html#enum" title="10.4.4. The ENUM Type">Section 10.4.4, “The <code class="literal">ENUM</code> Type”</a></dt><dt><a href="data-types.html#set" title="10.4.5. The SET Type">Section 10.4.5, “The <code class="literal">SET</code> Type”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AVG(DISTINCT)</code></h3><dl><dt><a href="optimization.html#loose-index-scan" title="7.2.14.1. Loose Index Scan">Section 7.2.14.1, “Loose Index Scan”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AVG([DISTINCT] expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Area()</code></h3><dl><dt><a href="functions.html#geometry-property-functions" title="11.13.5.2. Geometry Functions">Section 11.13.5.2, “<code class="literal">Geometry</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Area(mpoly)</code></h3><dl><dt><a href="functions.html#multipolygon-property-functions" title="11.13.5.2.6. MultiPolygon Functions">Section 11.13.5.2.6, “<code class="literal">MultiPolygon</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Area(poly)</code></h3><dl><dt><a href="functions.html#polygon-property-functions" title="11.13.5.2.5. Polygon Functions">Section 11.13.5.2.5, “<code class="literal">Polygon</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AsBinary()</code></h3><dl><dt><a href="functions.html#fetching-spatial-data" title="11.13.4.5. Fetching Spatial Data">Section 11.13.4.5, “Fetching Spatial Data”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AsBinary(g)</code></h3><dl><dt><a href="functions.html#functions-to-convert-geometries-between-formats" title="11.13.5.1. Geometry Format Conversion Functions">Section 11.13.5.1, “Geometry Format Conversion Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AsText()</code></h3><dl><dt><a href="functions.html#fetching-spatial-data" title="11.13.4.5. Fetching Spatial Data">Section 11.13.4.5, “Fetching Spatial Data”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AsText(g)</code></h3><dl><dt><a href="functions.html#functions-to-convert-geometries-between-formats" title="11.13.5.1. Geometry Format Conversion Functions">Section 11.13.5.1, “Geometry Format Conversion Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AsWKB(g)</code></h3><dl><dt><a href="functions.html#functions-to-convert-geometries-between-formats" title="11.13.5.1. Geometry Format Conversion Functions">Section 11.13.5.1, “Geometry Format Conversion Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AsWKT(g)</code></h3><dl><dt><a href="functions.html#functions-to-convert-geometries-between-formats" title="11.13.5.1. Geometry Format Conversion Functions">Section 11.13.5.1, “Geometry Format Conversion Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BENCHMARK()</code></h3><dl><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="optimization.html#query-speed" title="7.2. Optimizing SELECT and Other Statements">Section 7.2, “Optimizing <code class="literal">SELECT</code> and Other Statements”</a></dt><dt><a href="sql-syntax.html#optimizing-subqueries" title="12.2.9.10. Optimizing Subqueries">Section 12.2.9.10, “Optimizing Subqueries”</a></dt><dt><a href="sql-syntax.html#unnamed-views" title="12.2.9.8. Subqueries in the FROM clause">Section 12.2.9.8, “Subqueries in the <code class="literal">FROM</code> clause”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BENCHMARK(10, (SELECT * FROM t))</code></h3><dl><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BENCHMARK(count,expr)</code></h3><dl><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BENCHMARK(loop_count,expression)</code></h3><dl><dt><a href="optimization.html#query-speed" title="7.2. Optimizing SELECT and Other Statements">Section 7.2, “Optimizing <code class="literal">SELECT</code> and Other Statements”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BIN()</code></h3><dl><dt><a href="language-structure.html#bit-field-values" title="8.1.5. Bit-Field Values">Section 8.1.5, “Bit-Field Values”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BIN(N)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BIT_AND()</code></h3><dl><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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BIT_AND(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BIT_COUNT()</code></h3><dl><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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BIT_COUNT(N)</code></h3><dl><dt><a href="functions.html#bit-functions" title="11.11.1. Bit Functions">Section 11.11.1, “Bit Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BIT_LENGTH()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BIT_LENGTH(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BIT_OR()</code></h3><dl><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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BIT_OR(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BIT_XOR()</code></h3><dl><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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BIT_XOR(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BdMPolyFromText(wkt,srid)</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BdMPolyFromWKB(wkb,srid)</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BdPolyFromText(wkt,srid)</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BdPolyFromWKB(wkb,srid)</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Boundary(g)</code></h3><dl><dt><a href="functions.html#general-geometry-property-functions" title="11.13.5.2.1. General Geometry Functions">Section 11.13.5.2.1, “General Geometry Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Buffer(g,d)</code></h3><dl><dt><a href="functions.html#spatial-operators" title="11.13.5.3.2. Spatial Operators">Section 11.13.5.3.2, “Spatial Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CAST()</code></h3><dl><dt><a href="internationalization-localization.html#charset-convert" title="9.1.9.2. CONVERT() and
CAST()">Section 9.1.9.2, “<code class="literal">CONVERT()</code> and
<code class="literal">CAST()</code>”</a></dt><dt><a href="language-structure.html#bit-field-values" title="8.1.5. Bit-Field Values">Section 8.1.5, “Bit-Field Values”</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="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</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="introduction.html#differences-from-ansi" title="1.7.5. MySQL Differences from Standard SQL">Section 1.7.5, “MySQL Differences from Standard SQL”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="functions.html#type-conversion" title="11.2.2. Type Conversion in Expression Evaluation">Section 11.2.2, “Type Conversion in Expression Evaluation”</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><dt><a href="language-structure.html#user-variables" title="8.4. User-Defined Variables">Section 8.4, “User-Defined Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CAST(... AS UNSIGNED)</code></h3><dl><dt><a href="language-structure.html#hexadecimal-values" title="8.1.3. Hexadecimal Values">Section 8.1.3, “Hexadecimal Values”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CAST(... COLLATE ...)</code></h3><dl><dt><a href="internationalization-localization.html#charset-convert" title="9.1.9.2. CONVERT() and
CAST()">Section 9.1.9.2, “<code class="literal">CONVERT()</code> and
<code class="literal">CAST()</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CAST(...) COLLATE ...</code></h3><dl><dt><a href="internationalization-localization.html#charset-convert" title="9.1.9.2. CONVERT() and
CAST()">Section 9.1.9.2, “<code class="literal">CONVERT()</code> and
<code class="literal">CAST()</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CAST(expr AS CHAR)</code></h3><dl><dt><a href="functions.html#cast-functions" title="11.9. Cast Functions and Operators">Section 11.9, “Cast Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CAST(expr AS type)</code></h3><dl><dt><a href="functions.html#cast-functions" title="11.9. Cast Functions and Operators">Section 11.9, “Cast Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CAST(str AS BINARY)</code></h3><dl><dt><a href="internationalization-localization.html#charset-binary-op" title="9.1.7.3. BINARY Operator">Section 9.1.7.3, “<code class="literal">BINARY</code> Operator”</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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CEIL()</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CEIL(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CEILING()</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CEILING(3.7004397181411)</code></h3><dl><dt><a href="partitioning.html#partitioning-linear-hash" title="18.2.3.1. LINEAR HASH Partitioning">Section 18.2.3.1, “<code class="literal">LINEAR HASH</code> Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CEILING(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHAR()</code></h3><dl><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="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</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">CHAR(0)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHAR(1,0)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHAR(1,0,0)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHAR(128 | key_num)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHAR(256)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHAR(256*256)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHAR(N)</code></h3><dl><dt><a href="functions.html#cast-functions" title="11.9. Cast Functions and Operators">Section 11.9, “Cast Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHAR(N,... [USING charset_name])</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHARACTER_LENGTH()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHARACTER_LENGTH(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHARSET()</code></h3><dl><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHARSET(str)</code></h3><dl><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHAR_LENGTH()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CHAR_LENGTH(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COALESCE()</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COALESCE(a.c1,b.c1)</code></h3><dl><dt><a href="sql-syntax.html#join" title="12.2.8.1. JOIN Syntax">Section 12.2.8.1, “<code class="literal">JOIN</code> Syntax”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COALESCE(value,...)</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COERCIBILITY()</code></h3><dl><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="internationalization-localization.html#charset-collate-tricky" title="9.1.7.5. Special Cases Where Collation Determination Is Tricky">Section 9.1.7.5, “Special Cases Where Collation Determination Is Tricky”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COERCIBILITY(str)</code></h3><dl><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COLLATION()</code></h3><dl><dt><a href="error-handling.html#case-sensitivity" title="B.1.5.1. Case Sensitivity in String Searches">Section B.1.5.1, “Case Sensitivity in String Searches”</a></dt><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COLLATION(str)</code></h3><dl><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COMPRESS()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="installing.html#configure-options" title="2.3.2. Typical configure Options">Section 2.3.2, “Typical <span><strong class="command">configure</strong></span> Options”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COMPRESS(string_to_compress)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONCAT()</code></h3><dl><dt><a href="sql-syntax.html#create-function-udf" title="12.5.3.1. CREATE FUNCTION Syntax">Section 12.5.3.1, “<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><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="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="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="sql-syntax.html#rewriting-subqueries" title="12.2.9.11. Rewriting Subqueries as Joins">Section 12.2.9.11, “Rewriting Subqueries as Joins”</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="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt><dt><a href="internationalization-localization.html#charset-repertoire" title="9.1.8. String Repertoire">Section 9.1.8, “String Repertoire”</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><dt><a href="functions.html#type-conversion" title="11.2.2. Type Conversion in Expression Evaluation">Section 11.2.2, “Type Conversion in Expression Evaluation”</a></dt><dt><a href="functions.html#xml-functions" title="11.10. XML Functions">Section 11.10, “XML Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONCAT(p1.id, p1.tvab) + 0 AS tvid</code></h3><dl><dt><a href="tutorial.html#twin-pool" title="3.7.1. Find All Nondistributed Twins">Section 3.7.1, “Find All Nondistributed Twins”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONCAT(str1,str2,...)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONCAT_WS()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONCAT_WS(separator,str1,str2,...)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONNECTION_ID()</code></h3><dl><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONV()</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONV(N,10,16)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONV(N,10,2)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONV(N,10,8)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONV(N,from_base,to_base)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONVERT()</code></h3><dl><dt><a href="internationalization-localization.html#charset-convert" title="9.1.9.2. CONVERT() and
CAST()">Section 9.1.9.2, “<code class="literal">CONVERT()</code> and
<code class="literal">CAST()</code>”</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="internationalization-localization.html#charset-literal" title="9.1.3.5. Character String Literal Character Set and Collation">Section 9.1.3.5, “Character String Literal Character Set and Collation”</a></dt><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</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">CONVERT(... USING ...)</code></h3><dl><dt><a href="internationalization-localization.html#charset-convert" title="9.1.9.2. CONVERT() and
CAST()">Section 9.1.9.2, “<code class="literal">CONVERT()</code> and
<code class="literal">CAST()</code>”</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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONVERT(expr USING transcoding_name)</code></h3><dl><dt><a href="functions.html#cast-functions" title="11.9. Cast Functions and Operators">Section 11.9, “Cast Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONVERT(expr,type)</code></h3><dl><dt><a href="functions.html#cast-functions" title="11.9. Cast Functions and Operators">Section 11.9, “Cast Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONVERT_TZ()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="sql-syntax.html#lock-tables-notes" title="12.4.5.3. Other Table-Locking Notes">Section 12.4.5.3, “Other Table-Locking Notes”</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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONVERT_TZ(...,...,@@global.time_zone)</code></h3><dl><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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONVERT_TZ(...,...,@@session.time_zone)</code></h3><dl><dt><a href="replication.html#replication-features-timezone" title="16.3.1.26. Replication and Time Zones">Section 16.3.1.26, “Replication and Time Zones”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CONVERT_TZ(dt,from_tz,to_tz)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COS(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COT(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COUNT()</code></h3><dl><dt><a href="sql-syntax.html#create-function-udf" title="12.5.3.1. CREATE FUNCTION Syntax">Section 12.5.3.1, “<code class="literal">CREATE FUNCTION</code> Syntax”</a></dt><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><dt><a href="optimization.html#where-optimizations" title="7.2.4. WHERE Clause Optimization">Section 7.2.4, “<code class="literal">WHERE</code> Clause Optimization”</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="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="error-handling.html#problems-with-null" title="B.1.5.3. Problems with NULL Values">Section B.1.5.3, “Problems with <code class="literal">NULL</code> Values”</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="stored-programs-views.html#view-updatability" title="19.5.3. Updatable and Insertable Views">Section 19.5.3, “Updatable and Insertable Views”</a></dt><dt><a href="stored-programs-views.html#view-algorithms" title="19.5.2. View Processing Algorithms">Section 19.5.2, “View Processing Algorithms”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COUNT(*)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><dt><a href="optimization.html#where-optimizations" title="7.2.4. WHERE Clause Optimization">Section 7.2.4, “<code class="literal">WHERE</code> Clause Optimization”</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="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="error-handling.html#problems-with-null" title="B.1.5.3. Problems with NULL Values">Section B.1.5.3, “Problems with <code class="literal">NULL</code> Values”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COUNT(DISTINCT ...)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COUNT(DISTINCT expr,[expr...])</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COUNT(DISTINCT value_list)</code></h3><dl><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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COUNT(DISTINCT)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><dt><a href="optimization.html#loose-index-scan" title="7.2.14.1. Loose Index Scan">Section 7.2.14.1, “Loose Index Scan”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">COUNT(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CRC32()</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CRC32(expr)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CURDATE()</code></h3><dl><dt><a href="tutorial.html#date-calculations" title="3.3.4.5. Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CURRENT_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#data-type-defaults" title="10.1.4. Data Type Default Values">Section 10.1.4, “Data Type Default Values”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</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">CURRENT_DATE()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CURRENT_TIME</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="data-types.html#time" title="10.3.2. The TIME Type">Section 10.3.2, “The <code class="literal">TIME</code> Type”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CURRENT_TIME()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CURRENT_TIMESTAMP</code></h3><dl><dt><a href="sql-syntax.html#create-event" title="12.1.11. CREATE EVENT Syntax">Section 12.1.11, “<code class="literal">CREATE EVENT</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="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="data-types.html#data-type-defaults" title="10.1.4. Data Type Default Values">Section 10.1.4, “Data Type Default Values”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CURRENT_TIMESTAMP()</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#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CURRENT_USER</code></h3><dl><dt><a href="sql-syntax.html#create-event" title="12.1.11. CREATE EVENT Syntax">Section 12.1.11, “<code class="literal">CREATE EVENT</code> Syntax”</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="sql-syntax.html#create-trigger" title="12.1.19. CREATE TRIGGER Syntax">Section 12.1.19, “<code class="literal">CREATE TRIGGER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-view" title="12.1.20. CREATE VIEW Syntax">Section 12.1.20, “<code class="literal">CREATE VIEW</code> Syntax”</a></dt><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CURRENT_USER()</code></h3><dl><dt><a href="sql-syntax.html#create-event" title="12.1.11. CREATE EVENT Syntax">Section 12.1.11, “<code class="literal">CREATE EVENT</code> Syntax”</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="sql-syntax.html#create-trigger" title="12.1.19. CREATE TRIGGER Syntax">Section 12.1.19, “<code class="literal">CREATE TRIGGER</code> Syntax”</a></dt><dt><a href="sql-syntax.html#create-view" title="12.1.20. CREATE VIEW Syntax">Section 12.1.20, “<code class="literal">CREATE VIEW</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-grants" title="12.5.5.22. SHOW GRANTS Syntax">Section 12.5.5.22, “<code class="literal">SHOW GRANTS</code> Syntax”</a></dt><dt><a href="server-administration.html#connection-access" title="5.4.4. Access Control, Stage 1: Connection Verification">Section 5.4.4, “Access Control, Stage 1: Connection Verification”</a></dt><dt><a href="server-administration.html#account-activity-auditing" title="5.5.9. Auditing MySQL Account Activity">Section 5.5.9, “Auditing MySQL Account Activity”</a></dt><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</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-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt><dt><a href="internationalization-localization.html#charset-metadata" title="9.1.11. UTF-8 for Metadata">Section 9.1.11, “UTF-8 for Metadata”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CURTIME()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="internationalization-localization.html#time-zone-support" title="9.7. MySQL Server Time Zone Support">Section 9.7, “MySQL Server Time Zone Support”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Centroid(mpoly)</code></h3><dl><dt><a href="functions.html#multipolygon-property-functions" title="11.13.5.2.6. MultiPolygon Functions">Section 11.13.5.2.6, “<code class="literal">MultiPolygon</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Contains()</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Contains(g1,g2)</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ConvexHull(g)</code></h3><dl><dt><a href="functions.html#spatial-operators" title="11.13.5.3.2. Spatial Operators">Section 11.13.5.3.2, “Spatial Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Create_func_abs</code></h3><dl><dt><a href="extending-mysql.html#adding-native-function" title="22.3.3. Adding a New Native Function">Section 22.3.3, “Adding a New Native Function”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Create_func_arg0</code></h3><dl><dt><a href="extending-mysql.html#adding-native-function" title="22.3.3. Adding a New Native Function">Section 22.3.3, “Adding a New Native Function”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Create_func_arg1</code></h3><dl><dt><a href="extending-mysql.html#adding-native-function" title="22.3.3. Adding a New Native Function">Section 22.3.3, “Adding a New Native Function”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Create_func_arg2</code></h3><dl><dt><a href="extending-mysql.html#adding-native-function" title="22.3.3. Adding a New Native Function">Section 22.3.3, “Adding a New Native Function”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Create_func_arg3</code></h3><dl><dt><a href="extending-mysql.html#adding-native-function" title="22.3.3. Adding a New Native Function">Section 22.3.3, “Adding a New Native Function”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Create_func_concat</code></h3><dl><dt><a href="extending-mysql.html#adding-native-function" title="22.3.3. Adding a New Native Function">Section 22.3.3, “Adding a New Native Function”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Create_func_lcase</code></h3><dl><dt><a href="extending-mysql.html#adding-native-function" title="22.3.3. Adding a New Native Function">Section 22.3.3, “Adding a New Native Function”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Create_func_lpad</code></h3><dl><dt><a href="extending-mysql.html#adding-native-function" title="22.3.3. Adding a New Native Function">Section 22.3.3, “Adding a New Native Function”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Create_func_pow</code></h3><dl><dt><a href="extending-mysql.html#adding-native-function" title="22.3.3. Adding a New Native Function">Section 22.3.3, “Adding a New Native Function”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Create_func_uuid</code></h3><dl><dt><a href="extending-mysql.html#adding-native-function" title="22.3.3. Adding a New Native Function">Section 22.3.3, “Adding a New Native Function”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Create_native_func</code></h3><dl><dt><a href="extending-mysql.html#adding-native-function" title="22.3.3. Adding a New Native Function">Section 22.3.3, “Adding a New Native Function”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Crosses(g1,g2)</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DATABASE()</code></h3><dl><dt><a href="error-handling.html#open-bugs-general" title="B.1.8.2. Additional Known Issues">Section B.1.8.2, “Additional Known Issues”</a></dt><dt><a href="tutorial.html#creating-database" title="3.3.1. Creating and Selecting a Database">Section 3.3.1, “Creating and Selecting a Database”</a></dt><dt><a href="tutorial.html#getting-information" title="3.4. Getting Information About Databases and Tables">Section 3.4, “Getting Information About Databases and Tables”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="error-handling.html#open-bugs" title="B.1.8.1. Open Issues in MySQL">Section B.1.8.1, “Open Issues in MySQL”</a></dt><dt><a href="internationalization-localization.html#charset-metadata" title="9.1.11. UTF-8 for Metadata">Section 9.1.11, “UTF-8 for Metadata”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DATE()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DATE(expr)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DATEDIFF()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DATEDIFF(expr1,expr2)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DATE_ADD()</code></h3><dl><dt><a href="sql-syntax.html#create-event" title="12.1.11. CREATE EVENT Syntax">Section 12.1.11, “<code class="literal">CREATE EVENT</code> Syntax”</a></dt><dt><a href="tutorial.html#date-calculations" title="3.3.4.5. Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DATE_ADD(date,INTERVAL expr unit)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DATE_FORMAT()</code></h3><dl><dt><a href="connectors-apis.html#c-api-prepared-statement-problems" title="21.9.13. C API Prepared Statement Problems">Section 21.9.13, “C API Prepared Statement Problems”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="internationalization-localization.html#locale-support" title="9.8. MySQL Server Locale Support">Section 9.8, “MySQL Server Locale Support”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</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">DATE_FORMAT(date,format)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DATE_SUB()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DATE_SUB(date,INTERVAL expr unit)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DAY()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DAY(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DAYNAME()</code></h3><dl><dt><a href="internationalization-localization.html#locale-support" title="9.8. MySQL Server Locale Support">Section 9.8, “MySQL Server Locale Support”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</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">DAYNAME(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DAYOFMONTH()</code></h3><dl><dt><a href="tutorial.html#date-calculations" title="3.3.4.5. Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DAYOFMONTH(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DAYOFWEEK()</code></h3><dl><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DAYOFWEEK(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DAYOFYEAR()</code></h3><dl><dt><a href="partitioning.html#partitioning-types" title="18.2. Partition Types">Section 18.2, “Partition Types”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DAYOFYEAR(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DECODE()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DECODE(crypt_str,pass_str)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DEFAULT()</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DEFAULT(col_name)</code></h3><dl><dt><a href="sql-syntax.html#insert" title="12.2.5. INSERT Syntax">Section 12.2.5, “<code class="literal">INSERT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#replace" title="12.2.7. REPLACE Syntax">Section 12.2.7, “<code class="literal">REPLACE</code> Syntax”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DEFAULT(i)</code></h3><dl><dt><a href="data-types.html#data-type-defaults" title="10.1.4. Data Type Default Values">Section 10.1.4, “Data Type Default Values”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DEGREES(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DES_DECRYPT()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DES_DECRYPT(crypt_str[,key_str])</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DES_ENCRYPT()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DES_ENCRYPT(str[,{key_num|key_str}])</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Difference(g1,g2)</code></h3><dl><dt><a href="functions.html#spatial-operators" title="11.13.5.3.2. Spatial Operators">Section 11.13.5.3.2, “Spatial Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Dimension(g)</code></h3><dl><dt><a href="functions.html#general-geometry-property-functions" title="11.13.5.2.1. General Geometry Functions">Section 11.13.5.2.1, “General Geometry Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Disjoint(g1,g2)</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Distance()</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Distance(g1,g2)</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ELT()</code></h3><dl><dt><a href="error-handling.html#open-bugs-general" title="B.1.8.2. Additional Known Issues">Section B.1.8.2, “Additional Known Issues”</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="error-handling.html#open-bugs" title="B.1.8.1. Open Issues in MySQL">Section B.1.8.1, “Open Issues in MySQL”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ELT(N,str1,str2,str3,...)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ENCODE()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ENCODE(str,pass_str)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ENCRYPT()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</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-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="server-administration.html#user-names" title="5.5.1. User Names and Passwords">Section 5.5.1, “User Names and Passwords”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ENCRYPT(str[,salt])</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">EXP()</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">EXP(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">EXPORT_SET(bits,on,off[,separator[,number_of_bits]])</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">EXTRACT()</code></h3><dl><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="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">EXTRACT(unit FROM date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">EndPoint()</code></h3><dl><dt><a href="functions.html#linestring-property-functions" title="11.13.5.2.3. LineString Functions">Section 11.13.5.2.3, “<code class="literal">LineString</code> Functions”</a></dt><dt><a href="functions.html#multilinestring-property-functions" title="11.13.5.2.4. MultiLineString Functions">Section 11.13.5.2.4, “<code class="literal">MultiLineString</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">EndPoint(ls)</code></h3><dl><dt><a href="functions.html#linestring-property-functions" title="11.13.5.2.3. LineString Functions">Section 11.13.5.2.3, “<code class="literal">LineString</code> Functions”</a></dt><dt><a href="functions.html#functions-that-produce-new-geometries" title="11.13.5.3.1. Geometry Functions That Produce New Geometries">Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Envelope(g)</code></h3><dl><dt><a href="functions.html#general-geometry-property-functions" title="11.13.5.2.1. General Geometry Functions">Section 11.13.5.2.1, “General Geometry Functions”</a></dt><dt><a href="functions.html#functions-that-produce-new-geometries" title="11.13.5.3.1. Geometry Functions That Produce New Geometries">Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Equals(g1,g2)</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ExteriorRing(poly)</code></h3><dl><dt><a href="functions.html#polygon-property-functions" title="11.13.5.2.5. Polygon Functions">Section 11.13.5.2.5, “<code class="literal">Polygon</code> Functions”</a></dt><dt><a href="functions.html#functions-that-produce-new-geometries" title="11.13.5.3.1. Geometry Functions That Produce New Geometries">Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ExtractValue('<a><b>Sakila</b></a>', '/a/b')</code></h3><dl><dt><a href="functions.html#xml-functions" title="11.10. XML Functions">Section 11.10, “XML Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ExtractValue('<a><b>Sakila</b></a>', '/a/b/text()')</code></h3><dl><dt><a href="functions.html#xml-functions" title="11.10. XML Functions">Section 11.10, “XML Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ExtractValue()</code></h3><dl><dt><a href="introduction.html#mysql-nutshell" title="1.4.1. What Is New in MySQL 5.1">Section 1.4.1, “What Is New in MySQL 5.1”</a></dt><dt><a href="functions.html#xml-functions" title="11.10. XML Functions">Section 11.10, “XML Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ExtractValue(xml_frag, xpath_expr)</code></h3><dl><dt><a href="functions.html#xml-functions" title="11.10. XML Functions">Section 11.10, “XML Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FIELD()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FIELD(str,str1,str2,str3,...)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FIND_IN_SET()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt><dt><a href="data-types.html#set" title="10.4.5. The SET Type">Section 10.4.5, “The <code class="literal">SET</code> Type”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FIND_IN_SET(str,strlist)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FLOOR()</code></h3><dl><dt><a href="functions.html#arithmetic-functions" title="11.5.1. Arithmetic Operators">Section 11.5.1, “Arithmetic Operators”</a></dt><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FLOOR(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FLOOR(i RAND() * (j i))</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FORMAT()</code></h3><dl><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="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FORMAT(X,D)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FOUND_ROWS()</code></h3><dl><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</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-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FROM_DAYS()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FROM_DAYS(N)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FROM_UNIXTIME()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</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-timezone" title="16.3.1.26. Replication and Time Zones">Section 16.3.1.26, “Replication and Time Zones”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FROM_UNIXTIME(unix_timestamp)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">FROM_UNIXTIME(unix_timestamp,format)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="internationalization-localization.html#locale-support" title="9.8. MySQL Server Locale Support">Section 9.8, “MySQL Server Locale Support”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(DATE,'EUR')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(DATE,'INTERNAL')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(DATE,'ISO')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(DATE,'JIS')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(DATE,'USA')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(DATETIME,'EUR')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(DATETIME,'INTERNAL')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(DATETIME,'ISO')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(DATETIME,'JIS')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(DATETIME,'USA')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(TIME,'EUR')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(TIME,'INTERNAL')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(TIME,'ISO')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(TIME,'JIS')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT(TIME,'USA')</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_FORMAT({DATE|TIME|DATETIME}, {'EUR'|'USA'|'JIS'|'ISO'|'INTERNAL'})</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_LOCK()</code></h3><dl><dt><a href="sql-syntax.html#create-event" title="12.1.11. CREATE EVENT Syntax">Section 12.1.11, “<code class="literal">CREATE EVENT</code> Syntax”</a></dt><dt><a href="sql-syntax.html#kill" title="12.5.6.4. KILL Syntax">Section 12.5.6.4, “<code class="literal">KILL</code> Syntax”</a></dt><dt><a href="connectors-apis.html#mysql-change-user" title="21.9.3.3. mysql_change_user()">Section 21.9.3.3, “<code class="literal">mysql_change_user()</code>”</a></dt><dt><a href="connectors-apis.html#auto-reconnect" title="21.9.11. Controlling Automatic Reconnection Behavior">Section 21.9.11, “Controlling Automatic Reconnection Behavior”</a></dt><dt><a href="optimization.html#general-thread-states" title="7.5.6.2. General Thread States">Section 7.5.6.2, “General Thread States”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="optimization.html#internal-locking" title="7.3.1. Internal Locking Methods">Section 7.3.1, “Internal Locking Methods”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt><dt><a href="sql-syntax.html#lock-tables-notes" title="12.4.5.3. Other Table-Locking Notes">Section 12.4.5.3, “Other Table-Locking Notes”</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-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GET_LOCK(str,timeout)</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GLength()</code></h3><dl><dt><a href="functions.html#linestring-property-functions" title="11.13.5.2.3. LineString Functions">Section 11.13.5.2.3, “<code class="literal">LineString</code> Functions”</a></dt><dt><a href="functions.html#multilinestring-property-functions" title="11.13.5.2.4. MultiLineString Functions">Section 11.13.5.2.4, “<code class="literal">MultiLineString</code> Functions”</a></dt><dt><a href="functions.html#mysql-gis-conformance-and-compatibility" title="11.13.7. MySQL Conformance and Compatibility">Section 11.13.7, “MySQL Conformance and Compatibility”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GLength(ls)</code></h3><dl><dt><a href="functions.html#linestring-property-functions" title="11.13.5.2.3. LineString Functions">Section 11.13.5.2.3, “<code class="literal">LineString</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GLength(mls)</code></h3><dl><dt><a href="functions.html#multilinestring-property-functions" title="11.13.5.2.4. MultiLineString Functions">Section 11.13.5.2.4, “<code class="literal">MultiLineString</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GREATEST()</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GREATEST(value1,value2,...)</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GREATEST(x,NULL)</code></h3><dl><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">GROUP_CONCAT()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><dt><a href="error-handling.html#open-bugs-general" title="B.1.8.2. Additional Known Issues">Section B.1.8.2, “Additional Known Issues”</a></dt><dt><a href="introduction.html#mysql-nutshell" title="1.4.1. What Is New in MySQL 5.1">Section 1.4.1, “What Is New in MySQL 5.1”</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="error-handling.html#open-bugs" title="B.1.8.1. Open Issues in MySQL">Section B.1.8.1, “Open Issues in MySQL”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GROUP_CONCAT(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeomCollFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeomCollFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeomFromText()</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt><dt><a href="functions.html#populating-spatial-columns" title="11.13.4.4. Populating Spatial Columns">Section 11.13.4.4, “Populating Spatial Columns”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeomFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt><dt><a href="functions.html#functions-to-convert-geometries-between-formats" title="11.13.5.1. Geometry Format Conversion Functions">Section 11.13.5.1, “Geometry Format Conversion Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeomFromWKB()</code></h3><dl><dt><a href="functions.html#gis-mysql-specific-functions" title="11.13.4.2.3. Creating Geometry Values Using MySQL-Specific Functions">Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”</a></dt><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeomFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt><dt><a href="functions.html#functions-to-convert-geometries-between-formats" title="11.13.5.1. Geometry Format Conversion Functions">Section 11.13.5.1, “Geometry Format Conversion Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeometryCollection(g1,g2,...)</code></h3><dl><dt><a href="functions.html#gis-mysql-specific-functions" title="11.13.4.2.3. Creating Geometry Values Using MySQL-Specific Functions">Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeometryCollectionFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeometryCollectionFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeometryFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeometryFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeometryN(gc,N)</code></h3><dl><dt><a href="functions.html#geometrycollection-property-functions" title="11.13.5.2.7. GeometryCollection Functions">Section 11.13.5.2.7, “<code class="literal">GeometryCollection</code> Functions”</a></dt><dt><a href="functions.html#functions-that-produce-new-geometries" title="11.13.5.3.1. Geometry Functions That Produce New Geometries">Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">GeometryType(g)</code></h3><dl><dt><a href="functions.html#general-geometry-property-functions" title="11.13.5.2.1. General Geometry Functions">Section 11.13.5.2.1, “General Geometry Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">HEX()</code></h3><dl><dt><a href="internationalization-localization.html#charset-literal" title="9.1.3.5. Character String Literal Character Set and Collation">Section 9.1.3.5, “Character String Literal Character Set and Collation”</a></dt><dt><a href="language-structure.html#hexadecimal-values" title="8.1.3. Hexadecimal Values">Section 8.1.3, “Hexadecimal Values”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">HEX(N_or_S)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">HEX(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">HOUR()</code></h3><dl><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">HOUR(time)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IF()</code></h3><dl><dt><a href="error-handling.html#open-bugs-general" title="B.1.8.2. Additional Known Issues">Section B.1.8.2, “Additional Known Issues”</a></dt><dt><a href="functions.html#control-flow-functions" title="11.3. Control Flow Functions">Section 11.3, “Control Flow Functions”</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="error-handling.html#open-bugs" title="B.1.8.1. Open Issues in MySQL">Section B.1.8.1, “Open Issues in MySQL”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IF(0)</code></h3><dl><dt><a href="functions.html#control-flow-functions" title="11.3. Control Flow Functions">Section 11.3, “Control Flow Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IF(0.1)</code></h3><dl><dt><a href="functions.html#control-flow-functions" title="11.3. Control Flow Functions">Section 11.3, “Control Flow Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IF(expr1,expr2,expr3)</code></h3><dl><dt><a href="functions.html#control-flow-functions" title="11.3. Control Flow Functions">Section 11.3, “Control Flow Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IFNULL()</code></h3><dl><dt><a href="functions.html#control-flow-functions" title="11.3. Control Flow Functions">Section 11.3, “Control Flow Functions”</a></dt><dt><a href="error-handling.html#problems-with-null" title="B.1.5.3. Problems with NULL Values">Section B.1.5.3, “Problems with <code class="literal">NULL</code> Values”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IFNULL(expr1,expr2)</code></h3><dl><dt><a href="functions.html#control-flow-functions" title="11.3. Control Flow Functions">Section 11.3, “Control Flow Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IN()</code></h3><dl><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt><dt><a href="functions.html#type-conversion" title="11.2.2. Type Conversion in Expression Evaluation">Section 11.2.2, “Type Conversion in Expression Evaluation”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IN(value_list)</code></h3><dl><dt><a href="restrictions.html#subquery-restrictions" title="D.3. Restrictions on Subqueries">Section D.3, “Restrictions on Subqueries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">INET_ATON()</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">INET_ATON(expr)</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">INET_NTOA()</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">INET_NTOA(expr)</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">INSERT(str,pos,len,newstr)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">INSTR()</code></h3><dl><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">INSTR(str,substr)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">INTERVAL(N,N1,N2,N3,...)</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ISNULL()</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ISNULL(expr)</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IS_FREE_LOCK()</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</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-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IS_FREE_LOCK(str)</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IS_USED_LOCK()</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</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-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IS_USED_LOCK(str)</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">InteriorRingN(poly,N)</code></h3><dl><dt><a href="functions.html#polygon-property-functions" title="11.13.5.2.5. Polygon Functions">Section 11.13.5.2.5, “<code class="literal">Polygon</code> Functions”</a></dt><dt><a href="functions.html#functions-that-produce-new-geometries" title="11.13.5.3.1. Geometry Functions That Produce New Geometries">Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Intersection(g1,g2)</code></h3><dl><dt><a href="functions.html#spatial-operators" title="11.13.5.3.2. Spatial Operators">Section 11.13.5.3.2, “Spatial Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Intersects(g1,g2)</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IsClosed(mls)</code></h3><dl><dt><a href="functions.html#multilinestring-property-functions" title="11.13.5.2.4. MultiLineString Functions">Section 11.13.5.2.4, “<code class="literal">MultiLineString</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IsEmpty(g)</code></h3><dl><dt><a href="functions.html#general-geometry-property-functions" title="11.13.5.2.1. General Geometry Functions">Section 11.13.5.2.1, “General Geometry Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IsRing(ls)</code></h3><dl><dt><a href="functions.html#linestring-property-functions" title="11.13.5.2.3. LineString Functions">Section 11.13.5.2.3, “<code class="literal">LineString</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IsSimple()</code></h3><dl><dt><a href="functions.html#general-geometry-property-functions" title="11.13.5.2.1. General Geometry Functions">Section 11.13.5.2.1, “General Geometry Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IsSimple(g)</code></h3><dl><dt><a href="functions.html#general-geometry-property-functions" title="11.13.5.2.1. General Geometry Functions">Section 11.13.5.2.1, “General Geometry Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LAST_DAY()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LAST_DAY(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LAST_INSERT_ID()</code></h3><dl><dt><a href="programs.html#mysqlbinlog-hexdump" title="4.6.7.1. mysqlbinlog Hex Dump Format">Section 4.6.7.1, “<span><strong class="command">mysqlbinlog</strong></span> Hex Dump Format”</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="sql-syntax.html#insert-on-duplicate" title="12.2.5.3. INSERT ... ON
DUPLICATE KEY UPDATE Syntax">Section 12.2.5.3, “<code class="literal">INSERT ... ON
DUPLICATE KEY UPDATE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#insert-delayed" title="12.2.5.2. INSERT DELAYED Syntax">Section 12.2.5.2, “<code class="literal">INSERT DELAYED</code> Syntax”</a></dt><dt><a href="sql-syntax.html#insert" title="12.2.5. INSERT Syntax">Section 12.2.5, “<code class="literal">INSERT</code> Syntax”</a></dt><dt><a href="connectors-apis.html#mysql-insert-id" title="21.9.3.37. mysql_insert_id()">Section 21.9.3.37, “<code class="literal">mysql_insert_id()</code>”</a></dt><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="connectors-apis.html#auto-reconnect" title="21.9.11. Controlling Automatic Reconnection Behavior">Section 21.9.11, “Controlling Automatic Reconnection Behavior”</a></dt><dt><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqlbinlog-description.html" target="_top">Description</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="connectors-apis.html#getting-unique-id" title="21.9.10.3. How to Get the Unique ID for the Last Inserted Row">Section 21.9.10.3, “How to Get the Unique ID for the Last Inserted Row”</a></dt><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</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="sql-syntax.html#lock-tables-notes" title="12.4.5.3. Other Table-Locking Notes">Section 12.4.5.3, “Other Table-Locking Notes”</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-auto-increment" title="16.3.1.1. Replication and AUTO_INCREMENT">Section 16.3.1.1, “Replication and <code class="literal">AUTO_INCREMENT</code>”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt><dt><a href="stored-programs-views.html#stored-routines-last-insert-id" title="19.2.4. Stored Procedures, Functions, Triggers, and
LAST_INSERT_ID()">Section 19.2.4, “Stored Procedures, Functions, Triggers, and
<code class="literal">LAST_INSERT_ID()</code>”</a></dt><dt><a href="introduction.html#ansi-diff-transactions" title="1.7.5.2. Transactions and Atomic Operations">Section 1.7.5.2, “Transactions and Atomic Operations”</a></dt><dt><a href="replication.html#replication-problems" title="16.3.5. Troubleshooting Replication">Section 16.3.5, “Troubleshooting Replication”</a></dt><dt><a href="stored-programs-views.html#view-updatability" title="19.5.3. Updatable and Insertable Views">Section 19.5.3, “Updatable and Insertable Views”</a></dt><dt><a href="tutorial.html#example-auto-increment" title="3.6.9. Using AUTO_INCREMENT">Section 3.6.9, “Using <code class="literal">AUTO_INCREMENT</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LAST_INSERT_ID(expr)</code></h3><dl><dt><a href="sql-syntax.html#insert-on-duplicate" title="12.2.5.3. INSERT ... ON
DUPLICATE KEY UPDATE Syntax">Section 12.2.5.3, “<code class="literal">INSERT ... ON
DUPLICATE KEY UPDATE</code> Syntax”</a></dt><dt><a href="connectors-apis.html#mysql-insert-id" title="21.9.3.37. mysql_insert_id()">Section 21.9.3.37, “<code class="literal">mysql_insert_id()</code>”</a></dt><dt><a href="connectors-apis.html#mysql-stmt-insert-id" title="21.9.7.16. mysql_stmt_insert_id()">Section 21.9.7.16, “<code class="literal">mysql_stmt_insert_id()</code>”</a></dt><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LCASE()</code></h3><dl><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LCASE(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LEAST()</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LEAST(value1,value2,...)</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LEAST(x,NULL)</code></h3><dl><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">LEFT()</code></h3><dl><dt><a href="functions.html#cast-functions" title="11.9. Cast Functions and Operators">Section 11.9, “Cast Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LEFT(str,len)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LENGTH()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LENGTH(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LN()</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LN(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOAD_FILE()</code></h3><dl><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="server-administration.html#privileges-provided" title="5.4.1. Privileges Provided by MySQL">Section 5.4.1, “Privileges Provided by 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-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt><dt><a href="server-administration.html#privileges-options" title="5.3.3. Security-Related mysqld Options">Section 5.3.3, “Security-Related <span><strong class="command">mysqld</strong></span> Options”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOAD_FILE(file_name)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOCALTIME</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#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOCALTIME()</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#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOCALTIMESTAMP</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#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOCALTIMESTAMP()</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#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOCATE()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOCATE(substr,str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOCATE(substr,str,pos)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOG()</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOG(10,X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOG(2,13)</code></h3><dl><dt><a href="partitioning.html#partitioning-linear-hash" title="18.2.3.1. LINEAR HASH Partitioning">Section 18.2.3.1, “<code class="literal">LINEAR HASH</code> Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOG(B,X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOG(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOG(X) / LOG(2)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOG(X) / LOG(B)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOG10(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOG2()</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOG2(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOWER()</code></h3><dl><dt><a href="information-schema.html" title="Chapter 20. INFORMATION_SCHEMA Tables">Chapter 20, <i><code class="literal">INFORMATION_SCHEMA</code> Tables</i></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="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt><dt><a href="internationalization-localization.html#charset-unicode-sets" title="9.1.13.1. Unicode Character Sets">Section 9.1.13.1, “Unicode Character Sets”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LOWER(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LPAD(str,len,padstr)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LTRIM()</code></h3><dl><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LTRIM(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Length()</code></h3><dl><dt><a href="functions.html#linestring-property-functions" title="11.13.5.2.3. LineString Functions">Section 11.13.5.2.3, “<code class="literal">LineString</code> Functions”</a></dt><dt><a href="functions.html#multilinestring-property-functions" title="11.13.5.2.4. MultiLineString Functions">Section 11.13.5.2.4, “<code class="literal">MultiLineString</code> Functions”</a></dt><dt><a href="functions.html#mysql-gis-conformance-and-compatibility" title="11.13.7. MySQL Conformance and Compatibility">Section 11.13.7, “MySQL Conformance and Compatibility”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LineFromText()</code></h3><dl><dt><a href="functions.html#functions-to-convert-geometries-between-formats" title="11.13.5.1. Geometry Format Conversion Functions">Section 11.13.5.1, “Geometry Format Conversion Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LineFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LineFromWKB()</code></h3><dl><dt><a href="functions.html#functions-to-convert-geometries-between-formats" title="11.13.5.1. Geometry Format Conversion Functions">Section 11.13.5.1, “Geometry Format Conversion Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LineFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LineString(pt1,pt2,...)</code></h3><dl><dt><a href="functions.html#gis-mysql-specific-functions" title="11.13.4.2.3. Creating Geometry Values Using MySQL-Specific Functions">Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LineStringFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LineStringFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MAKEDATE()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MAKEDATE(year,dayofyear)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MAKETIME()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MAKETIME(hour,minute,second)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MAKE_SET(bits,str1,str2,...)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MASTER_POS_WAIT()</code></h3><dl><dt><a href="sql-syntax.html#master-pos-wait" title="12.6.2.4. MASTER_POS_WAIT() Syntax">Section 12.6.2.4, “<code class="literal">MASTER_POS_WAIT()</code> Syntax”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt><dt><a href="replication.html#replication-faq" title="16.3.4. Replication FAQ">Section 16.3.4, “Replication FAQ”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MASTER_POS_WAIT(log_name,log_pos[,timeout])</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MATCH (col1,col2,...) AGAINST (expr [search_modifier])</code></h3><dl><dt><a href="functions.html#fulltext-search" title="11.8. Full-Text Search Functions">Section 11.8, “Full-Text Search Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MATCH()</code></h3><dl><dt><a href="functions.html#fulltext-fine-tuning" title="11.8.6. Fine-Tuning MySQL Full-Text Search">Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”</a></dt><dt><a href="functions.html#fulltext-restrictions" title="11.8.5. Full-Text Restrictions">Section 11.8.5, “Full-Text Restrictions”</a></dt><dt><a href="functions.html#fulltext-search" title="11.8. Full-Text Search Functions">Section 11.8, “Full-Text Search Functions”</a></dt><dt><a href="functions.html#fulltext-natural-language" title="11.8.1. Natural Language Full-Text Searches">Section 11.8.1, “Natural Language Full-Text Searches”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MATCH() ... AGAINST</code></h3><dl><dt><a href="functions.html#fulltext-search" title="11.8. Full-Text Search Functions">Section 11.8, “Full-Text Search Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MATCH() ... AGAINST()</code></h3><dl><dt><a href="functions.html#fulltext-boolean" title="11.8.2. Boolean Full-Text Searches">Section 11.8.2, “Boolean Full-Text Searches”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MAX()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><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="error-handling.html#open-bugs-general" title="B.1.8.2. Additional Known Issues">Section B.1.8.2, “Additional Known Issues”</a></dt><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="optimization.html#mysql-indexes" title="7.4.4. How MySQL Uses Indexes">Section 7.4.4, “How MySQL Uses Indexes”</a></dt><dt><a href="optimization.html#loose-index-scan" title="7.2.14.1. Loose Index Scan">Section 7.2.14.1, “Loose Index Scan”</a></dt><dt><a href="error-handling.html#open-bugs" title="B.1.8.1. Open Issues in MySQL">Section B.1.8.1, “Open Issues in MySQL”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="sql-syntax.html#optimizing-subqueries" title="12.2.9.10. Optimizing Subqueries">Section 12.2.9.10, “Optimizing Subqueries”</a></dt><dt><a href="stored-programs-views.html#view-updatability" title="19.5.3. Updatable and Insertable Views">Section 19.5.3, “Updatable and Insertable Views”</a></dt><dt><a href="stored-programs-views.html#view-algorithms" title="19.5.2. View Processing Algorithms">Section 19.5.2, “View Processing Algorithms”</a></dt><dt><a href="data-types.html#y2k-issues" title="10.3.4. Year 2000 Issues and Date Types">Section 10.3.4, “Year 2000 Issues and Date Types”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MAX([DISTINCT] expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MAX(auto_increment_column) + 1 WHERE prefix=given-prefix</code></h3><dl><dt><a href="tutorial.html#example-auto-increment" title="3.6.9. Using AUTO_INCREMENT">Section 3.6.9, “Using <code class="literal">AUTO_INCREMENT</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MAX(col_name)</code></h3><dl><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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MAX(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MAX(t1.b)</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">MBRContains()</code></h3><dl><dt><a href="functions.html#relations-on-geometry-mbr" title="11.13.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)">Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”</a></dt><dt><a href="functions.html#using-a-spatial-index" title="11.13.6.2. Using a Spatial Index">Section 11.13.6.2, “Using a Spatial Index”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MBRContains(g1,g2)</code></h3><dl><dt><a href="functions.html#relations-on-geometry-mbr" title="11.13.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)">Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MBRDisjoint(g1,g2)</code></h3><dl><dt><a href="functions.html#relations-on-geometry-mbr" title="11.13.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)">Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MBREqual(g1,g2)</code></h3><dl><dt><a href="functions.html#relations-on-geometry-mbr" title="11.13.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)">Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MBRIntersects(g1,g2)</code></h3><dl><dt><a href="functions.html#relations-on-geometry-mbr" title="11.13.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)">Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MBROverlaps(g1,g2)</code></h3><dl><dt><a href="functions.html#relations-on-geometry-mbr" title="11.13.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)">Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MBRTouches(g1,g2)</code></h3><dl><dt><a href="functions.html#relations-on-geometry-mbr" title="11.13.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)">Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MBRWithin()</code></h3><dl><dt><a href="functions.html#relations-on-geometry-mbr" title="11.13.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)">Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”</a></dt><dt><a href="functions.html#using-a-spatial-index" title="11.13.6.2. Using a Spatial Index">Section 11.13.6.2, “Using a Spatial Index”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MBRWithin(g1,g2)</code></h3><dl><dt><a href="functions.html#relations-on-geometry-mbr" title="11.13.5.5. Relations on Geometry Minimal Bounding Rectangles (MBRs)">Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MD5()</code></h3><dl><dt><a href="partitioning.html#partitioning-key" title="18.2.4. KEY Partitioning">Section 18.2.4, “<code class="literal">KEY</code> Partitioning”</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="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="server-administration.html#security-guidelines" title="5.3.1. General Security Guidelines">Section 5.3.1, “General Security Guidelines”</a></dt><dt><a href="server-administration.html#application-password-use" title="5.5.6.4. Implications of Password Hashing Changes in MySQL 4.1 for Application
Programs">Section 5.5.6.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application
Programs”</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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MD5(str)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MICROSECOND()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MICROSECOND(expr)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MID()</code></h3><dl><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MID(expr,1,255)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MID(str,pos,len)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MIN()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><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="optimization.html#where-optimizations" title="7.2.4. WHERE Clause Optimization">Section 7.2.4, “<code class="literal">WHERE</code> Clause Optimization”</a></dt><dt><a href="error-handling.html#open-bugs-general" title="B.1.8.2. Additional Known Issues">Section B.1.8.2, “Additional Known Issues”</a></dt><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="optimization.html#mysql-indexes" title="7.4.4. How MySQL Uses Indexes">Section 7.4.4, “How MySQL Uses Indexes”</a></dt><dt><a href="optimization.html#loose-index-scan" title="7.2.14.1. Loose Index Scan">Section 7.2.14.1, “Loose Index Scan”</a></dt><dt><a href="error-handling.html#open-bugs" title="B.1.8.1. Open Issues in MySQL">Section B.1.8.1, “Open Issues in MySQL”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="sql-syntax.html#optimizing-subqueries" title="12.2.9.10. Optimizing Subqueries">Section 12.2.9.10, “Optimizing Subqueries”</a></dt><dt><a href="error-handling.html#problems-with-null" title="B.1.5.3. Problems with NULL Values">Section B.1.5.3, “Problems with <code class="literal">NULL</code> Values”</a></dt><dt><a href="stored-programs-views.html#view-updatability" title="19.5.3. Updatable and Insertable Views">Section 19.5.3, “Updatable and Insertable Views”</a></dt><dt><a href="stored-programs-views.html#view-algorithms" title="19.5.2. View Processing Algorithms">Section 19.5.2, “View Processing Algorithms”</a></dt><dt><a href="data-types.html#y2k-issues" title="10.3.4. Year 2000 Issues and Date Types">Section 10.3.4, “Year 2000 Issues and Date Types”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MIN(DATE_ADD(timestamp,INTERVAL 0 DAY))</code></h3><dl><dt><a href="data-types.html#y2k-issues" title="10.3.4. Year 2000 Issues and Date Types">Section 10.3.4, “Year 2000 Issues and Date Types”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MIN([DISTINCT] expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MIN(col_name)</code></h3><dl><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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MIN(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MIN(number-with-zerofill)</code></h3><dl><dt><a href="connectors-apis.html#c-api-prepared-statement-problems" title="21.9.13. C API Prepared Statement Problems">Section 21.9.13, “C API Prepared Statement Problems”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MINUTE()</code></h3><dl><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MINUTE(time)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MLineFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MLineFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MOD()</code></h3><dl><dt><a href="functions.html#arithmetic-functions" title="11.5.1. Arithmetic Operators">Section 11.5.1, “Arithmetic Operators”</a></dt><dt><a href="tutorial.html#date-calculations" title="3.3.4.5. Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</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="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MOD(N,0)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MOD(N,M)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MOD(X,0)</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">MOD(something,12)</code></h3><dl><dt><a href="tutorial.html#date-calculations" title="3.3.4.5. Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MONTH()</code></h3><dl><dt><a href="tutorial.html#date-calculations" title="3.3.4.5. Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dt><a href="partitioning.html#partitioning-types" title="18.2. Partition Types">Section 18.2, “Partition Types”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MONTH(birth)</code></h3><dl><dt><a href="tutorial.html#date-calculations" title="3.3.4.5. Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MONTH(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MONTHNAME()</code></h3><dl><dt><a href="internationalization-localization.html#locale-support" title="9.8. MySQL Server Locale Support">Section 9.8, “MySQL Server Locale Support”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</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">MONTHNAME(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MPointFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MPointFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MPolyFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MPolyFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MultiLineString(ls1,ls2,...)</code></h3><dl><dt><a href="functions.html#gis-mysql-specific-functions" title="11.13.4.2.3. Creating Geometry Values Using MySQL-Specific Functions">Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MultiLineStringFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MultiLineStringFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MultiPoint(pt1,pt2,...)</code></h3><dl><dt><a href="functions.html#gis-mysql-specific-functions" title="11.13.4.2.3. Creating Geometry Values Using MySQL-Specific Functions">Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MultiPointFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MultiPointFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MultiPolygon(poly1,poly2,...)</code></h3><dl><dt><a href="functions.html#gis-mysql-specific-functions" title="11.13.4.2.3. Creating Geometry Values Using MySQL-Specific Functions">Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MultiPolygonFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">MultiPolygonFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NAME_CONST()</code></h3><dl><dt><a href="stored-programs-views.html#stored-programs-logging" title="19.6. Binary Logging of Stored Programs">Section 19.6, “Binary Logging of Stored Programs”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NAME_CONST(name,value)</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NOW()</code></h3><dl><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="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#timestamp" title="10.3.1.1. TIMESTAMP Properties">Section 10.3.1.1, “<code class="literal">TIMESTAMP</code> Properties”</a></dt><dt><a href="data-types.html#data-type-defaults" title="10.1.4. Data Type Default Values">Section 10.1.4, “Data Type Default Values”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="internationalization-localization.html#time-zone-support" title="9.7. MySQL Server Time Zone Support">Section 9.7, “MySQL Server Time Zone Support”</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-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt><dt><a href="replication.html#replication-features-timezone" title="16.3.1.26. Replication and Time Zones">Section 16.3.1.26, “Replication and Time Zones”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</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><dt><a href="data-types.html#year" title="10.3.3. The YEAR Type">Section 10.3.3, “The <code class="literal">YEAR</code> Type”</a></dt><dt><a href="internationalization-localization.html#time-zone-leap-seconds" title="9.7.2. Time Zone Leap Second Support">Section 9.7.2, “Time Zone Leap Second Support”</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">NULLIF()</code></h3><dl><dt><a href="functions.html#control-flow-functions" title="11.3. Control Flow Functions">Section 11.3, “Control Flow Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NULLIF(expr1,expr2)</code></h3><dl><dt><a href="functions.html#control-flow-functions" title="11.3. Control Flow Functions">Section 11.3, “Control Flow Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NumGeometries(gc)</code></h3><dl><dt><a href="functions.html#geometrycollection-property-functions" title="11.13.5.2.7. GeometryCollection Functions">Section 11.13.5.2.7, “<code class="literal">GeometryCollection</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NumInteriorRings(poly)</code></h3><dl><dt><a href="functions.html#polygon-property-functions" title="11.13.5.2.5. Polygon Functions">Section 11.13.5.2.5, “<code class="literal">Polygon</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NumPoints(ls)</code></h3><dl><dt><a href="functions.html#linestring-property-functions" title="11.13.5.2.3. LineString Functions">Section 11.13.5.2.3, “<code class="literal">LineString</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">OCT(N)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">OCTET_LENGTH()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">OCTET_LENGTH(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">OLD_PASSWORD()</code></h3><dl><dt><a href="error-handling.html#old-client" title="B.1.2.4. Client does not support authentication protocol">Section B.1.2.4, “<code class="literal">Client does not support authentication protocol</code>”</a></dt><dt><a href="sql-syntax.html#set-password" title="12.5.1.6. SET PASSWORD Syntax">Section 12.5.1.6, “<code class="literal">SET PASSWORD</code> Syntax”</a></dt><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="server-administration.html#application-password-use" title="5.5.6.4. Implications of Password Hashing Changes in MySQL 4.1 for Application
Programs">Section 5.5.6.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application
Programs”</a></dt><dt><a href="server-administration.html#password-hashing" title="5.5.6.3. Password Hashing in MySQL">Section 5.5.6.3, “Password Hashing in MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">OLD_PASSWORD(str)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ORD()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ORD(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Overlaps(g1,g2)</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PASSWORD()</code></h3><dl><dt><a href="sql-syntax.html#create-user" title="12.5.1.1. CREATE USER Syntax">Section 12.5.1.1, “<code class="literal">CREATE USER</code> Syntax”</a></dt><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="error-handling.html#ignoring-user" title="B.1.2.15. Ignoring user">Section B.1.2.15, “<code class="literal">Ignoring user</code>”</a></dt><dt><a href="partitioning.html#partitioning-key" title="18.2.4. KEY Partitioning">Section 18.2.4, “<code class="literal">KEY</code> Partitioning”</a></dt><dt><a href="sql-syntax.html#set-password" title="12.5.1.6. SET PASSWORD Syntax">Section 12.5.1.6, “<code class="literal">SET PASSWORD</code> Syntax”</a></dt><dt><a href="server-administration.html#connection-access" title="5.4.4. Access Control, Stage 1: Connection Verification">Section 5.4.4, “Access Control, Stage 1: Connection Verification”</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#passwords" title="5.5.5. Assigning Account Passwords">Section 5.5.5, “Assigning Account Passwords”</a></dt><dt><a href="server-administration.html#access-denied" title="5.4.7. Causes of Access-Denied Errors">Section 5.4.7, “Causes of Access-Denied Errors”</a></dt><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="server-administration.html#application-password-use" title="5.5.6.4. Implications of Password Hashing Changes in MySQL 4.1 for Application
Programs">Section 5.5.6.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application
Programs”</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#password-hashing" title="5.5.6.3. Password Hashing in MySQL">Section 5.5.6.3, “Password Hashing 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="installing.html#default-privileges" title="2.13.3. Securing the Initial MySQL Accounts">Section 2.13.3, “Securing the Initial MySQL Accounts”</a></dt><dt><a href="server-administration.html#user-names" title="5.5.1. User Names and Passwords">Section 5.5.1, “User Names and Passwords”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PASSWORD(str)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PERIOD_ADD()</code></h3><dl><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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PERIOD_ADD(P,N)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PERIOD_DIFF()</code></h3><dl><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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PERIOD_DIFF(P1,P2)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PI()</code></h3><dl><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="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</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">POSITION(substr IN str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">POW()</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">POW(5-int_col,3) + 6</code></h3><dl><dt><a href="partitioning.html#partitioning-hash" title="18.2.3. HASH Partitioning">Section 18.2.3, “<code class="literal">HASH</code> Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">POW(X,Y)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">POWER(2,4)</code></h3><dl><dt><a href="partitioning.html#partitioning-linear-hash" title="18.2.3.1. LINEAR HASH Partitioning">Section 18.2.3.1, “<code class="literal">LINEAR HASH</code> Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">POWER(X,Y)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Point()</code></h3><dl><dt><a href="functions.html#gis-mysql-specific-functions" title="11.13.4.2.3. Creating Geometry Values Using MySQL-Specific Functions">Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Point(x,y)</code></h3><dl><dt><a href="functions.html#gis-mysql-specific-functions" title="11.13.4.2.3. Creating Geometry Values Using MySQL-Specific Functions">Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PointFromText()</code></h3><dl><dt><a href="functions.html#functions-to-convert-geometries-between-formats" title="11.13.5.1. Geometry Format Conversion Functions">Section 11.13.5.1, “Geometry Format Conversion Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PointFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PointFromWKB()</code></h3><dl><dt><a href="functions.html#functions-to-convert-geometries-between-formats" title="11.13.5.1. Geometry Format Conversion Functions">Section 11.13.5.1, “Geometry Format Conversion Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PointFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PointN(ls,N)</code></h3><dl><dt><a href="functions.html#linestring-property-functions" title="11.13.5.2.3. LineString Functions">Section 11.13.5.2.3, “<code class="literal">LineString</code> Functions”</a></dt><dt><a href="functions.html#functions-that-produce-new-geometries" title="11.13.5.3.1. Geometry Functions That Produce New Geometries">Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PolyFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PolyFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Polygon(ls1,ls2,...)</code></h3><dl><dt><a href="functions.html#gis-mysql-specific-functions" title="11.13.4.2.3. Creating Geometry Values Using MySQL-Specific Functions">Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PolygonFromText(wkt[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkt-functions" title="11.13.4.2.1. Creating Geometry Values Using WKT Functions">Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">PolygonFromWKB(wkb[,srid])</code></h3><dl><dt><a href="functions.html#gis-wkb-functions" title="11.13.4.2.2. Creating Geometry Values Using WKB Functions">Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">QUARTER()</code></h3><dl><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">QUARTER(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">QUOTE()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">QUOTE(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RADIANS(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RAND()</code></h3><dl><dt><a href="programs.html#mysqlbinlog-hexdump" title="4.6.7.1. mysqlbinlog Hex Dump Format">Section 4.6.7.1, “<span><strong class="command">mysqlbinlog</strong></span> Hex Dump Format”</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="http://dev.mysql.com/doc/refman/5.1/en/mysqlbinlog-description.html" target="_top">Description</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</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-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RAND(N)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RAND(determinstic_expression)</code></h3><dl><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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RELEASE_LOCK()</code></h3><dl><dt><a href="sql-syntax.html#do" title="12.2.3. DO Syntax">Section 12.2.3, “<code class="literal">DO</code> Syntax”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="optimization.html#internal-locking" title="7.3.1. Internal Locking Methods">Section 7.3.1, “Internal Locking Methods”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt><dt><a href="sql-syntax.html#lock-tables-notes" title="12.4.5.3. Other Table-Locking Notes">Section 12.4.5.3, “Other Table-Locking Notes”</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-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RELEASE_LOCK(str)</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REPEAT()</code></h3><dl><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REPEAT(str,count)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REPLACE()</code></h3><dl><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REPLACE(str,from_str,to_str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REVERSE()</code></h3><dl><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REVERSE(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RIGHT()</code></h3><dl><dt><a href="tutorial.html#date-calculations" title="3.3.4.5. Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RIGHT(str,len)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ROUND()</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt><dt><a href="error-handling.html#problems-with-float" title="B.1.5.8. Problems with Floating-Point Comparisons">Section B.1.5.8, “Problems with Floating-Point Comparisons”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ROUND(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ROUND(X,D)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">ROW_COUNT()</code></h3><dl><dt><a href="sql-syntax.html#call" title="12.2.1. CALL Syntax">Section 12.2.1, “<code class="literal">CALL</code> Syntax”</a></dt><dt><a href="sql-syntax.html#delete" title="12.2.2. DELETE Syntax">Section 12.2.2, “<code class="literal">DELETE</code> Syntax”</a></dt><dt><a href="sql-syntax.html#insert" title="12.2.5. INSERT Syntax">Section 12.2.5, “<code class="literal">INSERT</code> Syntax”</a></dt><dt><a href="connectors-apis.html#mysql-affected-rows" title="21.9.3.1. mysql_affected_rows()">Section 21.9.3.1, “<code class="literal">mysql_affected_rows()</code>”</a></dt><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</a></dt><dt><a href="replication.html#replication-features-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RPAD()</code></h3><dl><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RPAD(str,len,padstr)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RTRIM()</code></h3><dl><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RTRIM(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Related()</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SCHEMA()</code></h3><dl><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SECOND()</code></h3><dl><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SECOND(time)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SEC_TO_TIME(seconds)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SESSION_USER()</code></h3><dl><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="internationalization-localization.html#charset-metadata" title="9.1.11. UTF-8 for Metadata">Section 9.1.11, “UTF-8 for Metadata”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SHA()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SHA(str)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SHA1()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="server-administration.html#security-guidelines" title="5.3.1. General Security Guidelines">Section 5.3.1, “General Security Guidelines”</a></dt><dt><a href="server-administration.html#application-password-use" title="5.5.6.4. Implications of Password Hashing Changes in MySQL 4.1 for Application
Programs">Section 5.5.6.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application
Programs”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SHA1(str)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SIGN(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SIN(3.14)</code></h3><dl><dt><a href="extending-mysql.html#udf-arguments" title="22.3.2.3. UDF Argument Processing">Section 22.3.2.3, “UDF Argument Processing”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SIN(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SLEEP()</code></h3><dl><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</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="restrictions.html#limits-windows" title="D.7.3. Windows Platform Limitations">Section D.7.3, “Windows Platform Limitations”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SLEEP(duration)</code></h3><dl><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SOUNDEX()</code></h3><dl><dt><a href="extending-mysql.html#adding-functions" title="22.3. Adding New Functions to MySQL">Section 22.3, “Adding New Functions to MySQL”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SOUNDEX(expr1) = SOUNDEX(expr2)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SOUNDEX(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SPACE()</code></h3><dl><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SPACE(N)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SQRT(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SRID(g)</code></h3><dl><dt><a href="functions.html#general-geometry-property-functions" title="11.13.5.2.1. General Geometry Functions">Section 11.13.5.2.1, “General Geometry Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STD()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</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></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STD(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STDDEV()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STDDEV(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STDDEV_POP()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STDDEV_POP(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STDDEV_SAMP()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STDDEV_SAMP(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STRCMP()</code></h3><dl><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="functions.html#string-comparison-functions" title="11.4.1. String Comparison Functions">Section 11.4.1, “String Comparison Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STRCMP(expr1,expr2)</code></h3><dl><dt><a href="functions.html#string-comparison-functions" title="11.4.1. String Comparison Functions">Section 11.4.1, “String Comparison Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STR_TO_DATE()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="internationalization-localization.html#locale-support" title="9.8. MySQL Server Locale Support">Section 9.8, “MySQL Server Locale Support”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">STR_TO_DATE(str,format)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBDATE()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBDATE(date,INTERVAL expr unit)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBDATE(expr,days)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBSTR()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBSTR(str FROM pos FOR len)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBSTR(str FROM pos)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBSTR(str,pos)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBSTR(str,pos,len)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBSTRING()</code></h3><dl><dt><a href="server-administration.html#account-activity-auditing" title="5.5.9. Auditing MySQL Account Activity">Section 5.5.9, “Auditing MySQL Account Activity”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt><dt><a href="data-types.html#blob" title="10.4.3. The BLOB and
TEXT Types">Section 10.4.3, “The <code class="literal">BLOB</code> and
<code class="literal">TEXT</code> Types”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBSTRING(str FROM pos FOR len)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBSTRING(str FROM pos)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBSTRING(str,pos)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBSTRING(str,pos,len)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBSTRING_INDEX()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBSTRING_INDEX(str,delim,count)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBTIME()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUBTIME(expr1,expr2)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUM()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><dt><a href="extending-mysql.html#adding-udf" title="22.3.2. Adding a New User-Defined Function">Section 22.3.2, “Adding a New User-Defined Function”</a></dt><dt><a href="data-types.html#date-and-time-type-overview" title="10.1.2. Overview of Date and Time Types">Section 10.1.2, “Overview of Date and Time Types”</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="error-handling.html#problems-with-null" title="B.1.5.3. Problems with NULL Values">Section B.1.5.3, “Problems with <code class="literal">NULL</code> Values”</a></dt><dt><a href="data-types.html#enum" title="10.4.4. The ENUM Type">Section 10.4.4, “The <code class="literal">ENUM</code> Type”</a></dt><dt><a href="data-types.html#set" title="10.4.5. The SET Type">Section 10.4.5, “The <code class="literal">SET</code> Type”</a></dt><dt><a href="stored-programs-views.html#view-updatability" title="19.5.3. Updatable and Insertable Views">Section 19.5.3, “Updatable and Insertable Views”</a></dt><dt><a href="stored-programs-views.html#view-algorithms" title="19.5.2. View Processing Algorithms">Section 19.5.2, “View Processing Algorithms”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUM(DISTINCT)</code></h3><dl><dt><a href="optimization.html#loose-index-scan" title="7.2.14.1. Loose Index Scan">Section 7.2.14.1, “Loose Index Scan”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUM([DISTINCT] expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SUM(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SYSDATE()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="replication.html#replication-features-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</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">SYSTEM_USER()</code></h3><dl><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="internationalization-localization.html#charset-metadata" title="9.1.11. UTF-8 for Metadata">Section 9.1.11, “UTF-8 for Metadata”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">StartPoint()</code></h3><dl><dt><a href="functions.html#linestring-property-functions" title="11.13.5.2.3. LineString Functions">Section 11.13.5.2.3, “<code class="literal">LineString</code> Functions”</a></dt><dt><a href="functions.html#multilinestring-property-functions" title="11.13.5.2.4. MultiLineString Functions">Section 11.13.5.2.4, “<code class="literal">MultiLineString</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">StartPoint(ls)</code></h3><dl><dt><a href="functions.html#linestring-property-functions" title="11.13.5.2.3. LineString Functions">Section 11.13.5.2.3, “<code class="literal">LineString</code> Functions”</a></dt><dt><a href="functions.html#functions-that-produce-new-geometries" title="11.13.5.3.1. Geometry Functions That Produce New Geometries">Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">SymDifference(g1,g2)</code></h3><dl><dt><a href="functions.html#spatial-operators" title="11.13.5.3.2. Spatial Operators">Section 11.13.5.3.2, “Spatial Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TAN(X)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIME()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIME(expr)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIMEDIFF()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIMEDIFF(expr1,expr2)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIMESTAMP()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIMESTAMP(expr)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIMESTAMP(expr1,expr2)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIMESTAMPADD()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIMESTAMPADD(unit,interval,datetime_expr)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIMESTAMPDIFF()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIME_FORMAT(time,format)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIME_TO_SEC()</code></h3><dl><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TIME_TO_SEC(time)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TO_DAYS()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</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="partitioning.html#partitioning-pruning" title="18.4. Partition Pruning">Section 18.4, “Partition Pruning”</a></dt><dt><a href="partitioning.html#partitioning-types" title="18.2. Partition Types">Section 18.2, “Partition Types”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TO_DAYS(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TO_DAYS(date_col)</code></h3><dl><dt><a href="partitioning.html#partitioning-hash" title="18.2.3. HASH Partitioning">Section 18.2.3, “<code class="literal">HASH</code> Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TRIM()</code></h3><dl><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="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TRIM([remstr FROM] str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TRUNCATE()</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">TRUNCATE(X,D)</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Touches(g1,g2)</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UCASE()</code></h3><dl><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UCASE(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UNCOMPRESS()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt><dt><a href="installing.html#configure-options" title="2.3.2. Typical configure Options">Section 2.3.2, “Typical <span><strong class="command">configure</strong></span> Options”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UNCOMPRESS(string_to_uncompress)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UNCOMPRESSED_LENGTH()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UNCOMPRESSED_LENGTH(compressed_string)</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UNHEX()</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UNHEX(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UNIX_TIMESTAMP()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</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="error-handling.html#timezone-problems" title="B.1.4.6. Time Zone Problems">Section B.1.4.6, “Time Zone Problems”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UNIX_TIMESTAMP(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UPPER()</code></h3><dl><dt><a href="information-schema.html" title="Chapter 20. INFORMATION_SCHEMA Tables">Chapter 20, <i><code class="literal">INFORMATION_SCHEMA</code> Tables</i></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="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt><dt><a href="internationalization-localization.html#charset-unicode-sets" title="9.1.13.1. Unicode Character Sets">Section 9.1.13.1, “Unicode Character Sets”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UPPER(X)</code></h3><dl><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UPPER(_utf8'abc')</code></h3><dl><dt><a href="internationalization-localization.html#charset-repertoire" title="9.1.8. String Repertoire">Section 9.1.8, “String Repertoire”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UPPER(str)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">USER()</code></h3><dl><dt><a href="server-administration.html#account-activity-auditing" title="5.5.9. Auditing MySQL Account Activity">Section 5.5.9, “Auditing MySQL Account Activity”</a></dt><dt><a href="server-administration.html#access-denied" title="5.4.7. Causes of Access-Denied Errors">Section 5.4.7, “Causes of Access-Denied Errors”</a></dt><dt><a href="internationalization-localization.html#charset-collation-charset" title="9.1.7.6. Collations Must Be for the Right Character Set">Section 9.1.7.6, “Collations Must Be for the Right Character Set”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</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-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt><dt><a href="internationalization-localization.html#charset-collate-tricky" title="9.1.7.5. Special Cases Where Collation Determination Is Tricky">Section 9.1.7.5, “Special Cases Where Collation Determination Is Tricky”</a></dt><dt><a href="internationalization-localization.html#charset-metadata" title="9.1.11. UTF-8 for Metadata">Section 9.1.11, “UTF-8 for Metadata”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UTC_DATE</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UTC_DATE()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UTC_TIME</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UTC_TIME()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UTC_TIMESTAMP</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#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UTC_TIMESTAMP()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="internationalization-localization.html#time-zone-support" title="9.7. MySQL Server Time Zone Support">Section 9.7, “MySQL Server Time Zone Support”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UUID()</code></h3><dl><dt><a href="replication.html#replication-options-binary-log" title="16.1.3.4. Binary Log Options and Variables">Section 16.1.3.4, “Binary Log Options and Variables”</a></dt><dt><a href="stored-programs-views.html#stored-programs-logging" title="19.6. Binary Logging of Stored Programs">Section 19.6, “Binary Logging of Stored Programs”</a></dt><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt><dt><a href="server-administration.html#binary-log-mixed" title="5.2.4.3. Mixed Binary Logging Format">Section 5.2.4.3, “Mixed Binary Logging Format”</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-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt><dt><a href="server-administration.html#binary-log-setting" title="5.2.4.2. Setting The Binary Log Format">Section 5.2.4.2, “Setting The Binary Log Format”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UUID_SHORT()</code></h3><dl><dt><a href="optimization.html#query-cache-operation" title="7.5.5.1. How the Query Cache Operates">Section 7.5.5.1, “How the Query Cache Operates”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Union(g1,g2)</code></h3><dl><dt><a href="functions.html#spatial-operators" title="11.13.5.3.2. Spatial Operators">Section 11.13.5.3.2, “Spatial Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UpdateXML()</code></h3><dl><dt><a href="introduction.html#mysql-nutshell" title="1.4.1. What Is New in MySQL 5.1">Section 1.4.1, “What Is New in MySQL 5.1”</a></dt><dt><a href="functions.html#xml-functions" title="11.10. XML Functions">Section 11.10, “XML Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">UpdateXML(xml_target, xpath_expr, new_xml)</code></h3><dl><dt><a href="functions.html#xml-functions" title="11.10. XML Functions">Section 11.10, “XML Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">VALUES()</code></h3><dl><dt><a href="sql-syntax.html#insert-on-duplicate" title="12.2.5.3. INSERT ... ON
DUPLICATE KEY UPDATE Syntax">Section 12.2.5.3, “<code class="literal">INSERT ... ON
DUPLICATE KEY UPDATE</code> Syntax”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">VALUES(col_name)</code></h3><dl><dt><a href="sql-syntax.html#insert-on-duplicate" title="12.2.5.3. INSERT ... ON
DUPLICATE KEY UPDATE Syntax">Section 12.2.5.3, “<code class="literal">INSERT ... ON
DUPLICATE KEY UPDATE</code> Syntax”</a></dt><dt><a href="functions.html#miscellaneous-functions" title="11.11.4. Miscellaneous Functions">Section 11.11.4, “Miscellaneous Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">VARIANCE()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">VARIANCE(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">VAR_POP()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">VAR_POP(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">VAR_SAMP()</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">VAR_SAMP(expr)</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">VERSION()</code></h3><dl><dt><a href="error-handling.html#case-sensitivity" title="B.1.5.1. Case Sensitivity in String Searches">Section B.1.5.1, “Case Sensitivity in String Searches”</a></dt><dt><a href="functions.html#information-functions" title="11.11.3. Information Functions">Section 11.11.3, “Information Functions”</a></dt><dt><a href="replication.html#replication-features-functions" title="16.3.1.11. Replication and System Functions">Section 16.3.1.11, “Replication and System Functions”</a></dt><dt><a href="internationalization-localization.html#charset-collate-tricky" title="9.1.7.5. Special Cases Where Collation Determination Is Tricky">Section 9.1.7.5, “Special Cases Where Collation Determination Is Tricky”</a></dt><dt><a href="internationalization-localization.html#charset-metadata" title="9.1.11. UTF-8 for Metadata">Section 9.1.11, “UTF-8 for Metadata”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEEK()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEEK(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEEK(date,0)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEEK(date,3)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEEK(date[,mode])</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEEKDAY()</code></h3><dl><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="partitioning.html#partitioning-types" title="18.2. Partition Types">Section 18.2, “Partition Types”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEEKDAY(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEEKOFYEAR()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEEKOFYEAR(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEIGHT_STRING()</code></h3><dl><dt><a href="error-handling.html#case-sensitivity" title="B.1.5.1. Case Sensitivity in String Searches">Section B.1.5.1, “Case Sensitivity in String Searches”</a></dt><dt><a href="internationalization-localization.html#adding-collation" title="9.5. How to Add a New Collation to a Character Set">Section 9.5, “How to Add a New Collation to a Character Set”</a></dt><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt><dt><a href="internationalization-localization.html#charset-unicode-sets" title="9.1.13.1. Unicode Character Sets">Section 9.1.13.1, “Unicode Character Sets”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEIGHT_STRING(str [AS {CHAR|BINARY}(N)] [LEVEL levels] [flags])</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEIGHT_STRING(str1)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">WEIGHT_STRING(str2)</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Within()</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Within(g1,g2)</code></h3><dl><dt><a href="functions.html#functions-that-test-spatial-relationships-between-geometries" title="11.13.5.6. Functions That Test Spatial Relationships Between Geometries">Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">X(p)</code></h3><dl><dt><a href="functions.html#point-property-functions" title="11.13.5.2.2. Point Functions">Section 11.13.5.2.2, “<code class="literal">Point</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">Y(p)</code></h3><dl><dt><a href="functions.html#point-property-functions" title="11.13.5.2.2. Point Functions">Section 11.13.5.2.2, “<code class="literal">Point</code> Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">YEAR('1984-06-21')</code></h3><dl><dt><a href="partitioning.html#partitioning-pruning" title="18.4. Partition Pruning">Section 18.4, “Partition Pruning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">YEAR('1999-06-21')</code></h3><dl><dt><a href="partitioning.html#partitioning-pruning" title="18.4. Partition Pruning">Section 18.4, “Partition Pruning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">YEAR()</code></h3><dl><dt><a href="tutorial.html#date-calculations" title="3.3.4.5. Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dt><a href="partitioning.html#partitioning-pruning" title="18.4. Partition Pruning">Section 18.4, “Partition Pruning”</a></dt><dt><a href="partitioning.html#partitioning-types" title="18.2. Partition Types">Section 18.2, “Partition Types”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">YEAR(NULL)</code></h3><dl><dt><a href="partitioning.html#partitioning-handling-nulls" title="18.2.6. How MySQL Partitioning Handles NULL">Section 18.2.6, “How MySQL Partitioning Handles <code class="literal">NULL</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">YEAR(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">YEAR(date_col)</code></h3><dl><dt><a href="partitioning.html#partitioning-hash" title="18.2.3. HASH Partitioning">Section 18.2.3, “<code class="literal">HASH</code> Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">YEAR(dob)</code></h3><dl><dt><a href="partitioning.html#partitioning-management-range-list" title="18.3.1. Management of RANGE and LIST
Partitions">Section 18.3.1, “Management of <code class="literal">RANGE</code> and <code class="literal">LIST</code>
Partitions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">YEAR(separated)</code></h3><dl><dt><a href="partitioning.html#partitioning-range" title="18.2.1. RANGE Partitioning">Section 18.2.1, “<code class="literal">RANGE</code> Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">YEARWEEK()</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="partitioning.html#partitioning-limitations-functions" title="18.5.3. Partitioning Limitations Relating to Functions">Section 18.5.3, “Partitioning Limitations Relating to Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">YEARWEEK(date)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">YEARWEEK(date,mode)</code></h3><dl><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">addslashes()</code></h3><dl><dt><a href="server-administration.html#security-guidelines" title="5.3.1. General Security Guidelines">Section 5.3.1, “General Security Guidelines”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">crypt()</code></h3><dl><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">expr IN (value,...)</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">expr NOT IN (value,...)</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">gethostbyaddr()</code></h3><dl><dt><a href="optimization.html#dns" title="7.5.11. How MySQL Uses DNS">Section 7.5.11, “How MySQL Uses DNS”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">gethostbyaddr_r()</code></h3><dl><dt><a href="optimization.html#dns" title="7.5.11. How MySQL Uses DNS">Section 7.5.11, “How MySQL Uses DNS”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">gethostbyname()</code></h3><dl><dt><a href="optimization.html#dns" title="7.5.11. How MySQL Uses DNS">Section 7.5.11, “How MySQL Uses DNS”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">gethostbyname_r()</code></h3><dl><dt><a href="optimization.html#dns" title="7.5.11. How MySQL Uses DNS">Section 7.5.11, “How MySQL Uses DNS”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">main()</code></h3><dl><dt><a href="connectors-apis.html#libmysqld" title="21.8. libmysqld, the Embedded MySQL Server Library">Section 21.8, “libmysqld, the Embedded MySQL Server Library”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">my_open()</code></h3><dl><dt><a href="server-administration.html#server-status-variables" title="5.1.7. Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">my_strxfrm_MYSET()</code></h3><dl><dt><a href="internationalization-localization.html#adding-character-set" title="9.4. Adding a New Character Set">Section 9.4, “Adding a New Character Set”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_add_word()</code></h3><dl><dt><a href="extending-mysql.html#plugin-api-type-specific" title="22.2.3.2. Type-Specific Plugin Structures and Functions">Section 22.2.3.2, “Type-Specific Plugin Structures and Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_bind_param()</code></h3><dl><dt><a href="connectors-apis.html#c-api-prepared-statement-functions" title="21.9.7. C API Prepared Statement Function Descriptions">Section 21.9.7, “C API Prepared Statement Function Descriptions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_bind_result()</code></h3><dl><dt><a href="connectors-apis.html#c-api-prepared-statement-functions" title="21.9.7. C API Prepared Statement Function Descriptions">Section 21.9.7, “C API Prepared Statement Function Descriptions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_escape_string()</code></h3><dl><dt><a href="server-administration.html#security-guidelines" title="5.3.1. General Security Guidelines">Section 5.3.1, “General Security Guidelines”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_execute()</code></h3><dl><dt><a href="connectors-apis.html#c-api-prepared-statement-functions" title="21.9.7. C API Prepared Statement Function Descriptions">Section 21.9.7, “C API Prepared Statement Function Descriptions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_fetch()</code></h3><dl><dt><a href="connectors-apis.html#c-api-prepared-statement-functions" title="21.9.7. C API Prepared Statement Function Descriptions">Section 21.9.7, “C API Prepared Statement Function Descriptions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_fetch_column()</code></h3><dl><dt><a href="connectors-apis.html#c-api-prepared-statement-functions" title="21.9.7. C API Prepared Statement Function Descriptions">Section 21.9.7, “C API Prepared Statement Function Descriptions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_get_metadata()</code></h3><dl><dt><a href="connectors-apis.html#c-api-prepared-statement-functions" title="21.9.7. C API Prepared Statement Function Descriptions">Section 21.9.7, “C API Prepared Statement Function Descriptions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_library_xxx()</code></h3><dl><dt><a href="connectors-apis.html#libmysqld" title="21.8. libmysqld, the Embedded MySQL Server Library">Section 21.8, “libmysqld, the Embedded MySQL Server Library”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_list_tables()</code></h3><dl><dt><a href="connectors-apis.html#mysql-list-tables" title="21.9.3.44. mysql_list_tables()">Section 21.9.3.44, “<code class="literal">mysql_list_tables()</code>”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_param_count()</code></h3><dl><dt><a href="connectors-apis.html#c-api-prepared-statement-functions" title="21.9.7. C API Prepared Statement Function Descriptions">Section 21.9.7, “C API Prepared Statement Function Descriptions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_param_result()</code></h3><dl><dt><a href="connectors-apis.html#c-api-prepared-statement-functions" title="21.9.7. C API Prepared Statement Function Descriptions">Section 21.9.7, “C API Prepared Statement Function Descriptions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_parse()</code></h3><dl><dt><a href="extending-mysql.html#plugin-api-type-specific" title="22.2.3.2. Type-Specific Plugin Structures and Functions">Section 22.2.3.2, “Type-Specific Plugin Structures and Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_prepare()</code></h3><dl><dt><a href="connectors-apis.html#c-api-prepared-statement-functions" title="21.9.7. C API Prepared Statement Function Descriptions">Section 21.9.7, “C API Prepared Statement Function Descriptions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_real_escape_string()</code></h3><dl><dt><a href="server-administration.html#security-guidelines" title="5.3.1. General Security Guidelines">Section 5.3.1, “General Security Guidelines”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_send_long_data()</code></h3><dl><dt><a href="connectors-apis.html#c-api-prepared-statement-functions" title="21.9.7. C API Prepared Statement Function Descriptions">Section 21.9.7, “C API Prepared Statement Function Descriptions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">mysql_shutdown(X)</code></h3><dl><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">mysql_shutdown(X,SHUTDOWN_DEFAULT)</code></h3><dl><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">pthread_exit()</code></h3><dl><dt><a href="connectors-apis.html#libmysqld" title="21.8. libmysqld, the Embedded MySQL Server Library">Section 21.8, “libmysqld, the Embedded MySQL Server Library”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">setrlimit()</code></h3><dl><dt><a href="server-administration.html#server-options" title="5.1.2. Server Command Options">Section 5.1.2, “Server Command Options”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">thr_setconcurrency()</code></h3><dl><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</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-command.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="dynindex-is.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Command Index </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> <code class="literal">INFORMATION_SCHEMA</code> Index</td></tr></table></div></body></html>
