Function Index

%

Section 1.7.4, “MySQL Extensions to Standard SQL”

ABS()

Section 12.5.3.1, “CREATE FUNCTION Syntax”
Section 22.3, “Adding New Functions to MySQL”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

ABS(X)

Section 11.5.2, “Mathematical Functions”

ACOS(X)

Section 11.5.2, “Mathematical Functions”

ADDDATE()

Section 11.6, “Date and Time Functions”

ADDDATE(date,INTERVAL expr unit)

Section 11.6, “Date and Time Functions”

ADDDATE(expr,days)

Section 11.6, “Date and Time Functions”

ADDTIME()

Section 11.6, “Date and Time Functions”

ADDTIME(expr1,expr2)

Section 11.6, “Date and Time Functions”

AES_DECRYPT()

Section 11.11.2, “Encryption and Compression Functions”

AES_DECRYPT(crypt_str,key_str)

Section 11.11.2, “Encryption and Compression Functions”

AES_ENCRYPT()

Section 11.11.2, “Encryption and Compression Functions”

AES_ENCRYPT(str,key_str)

Section 11.11.2, “Encryption and Compression Functions”

ASCII()

Section 12.3.3, “HELP Syntax”
Section 11.4, “String Functions”

ASCII(str)

Section 11.4, “String Functions”

ASIN(X)

Section 11.5.2, “Mathematical Functions”

ATAN(X)

Section 11.5.2, “Mathematical Functions”

ATAN(Y,X)

Section 11.5.2, “Mathematical Functions”

ATAN2(Y,X)

Section 11.5.2, “Mathematical Functions”

AVG()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 10.1.2, “Overview of Date and Time Types”
Section 10.4.4, “The ENUM Type”
Section 10.4.5, “The SET Type”

AVG([DISTINCT] expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

Area()

Section 11.13.5.2, “Geometry Functions”

Area(mpoly)

Section 11.13.5.2.6, “MultiPolygon Functions”

Area(poly)

Section 11.13.5.2.5, “Polygon Functions”

AsBinary()

Section 11.13.4.5, “Fetching Spatial Data”

AsBinary(g)

Section 11.13.5.1, “Geometry Format Conversion Functions”

AsText()

Section 11.13.4.5, “Fetching Spatial Data”

AsText(g)

Section 11.13.5.1, “Geometry Format Conversion Functions”

AsWKB(g)

Section 11.13.5.1, “Geometry Format Conversion Functions”

AsWKT(g)

Section 11.13.5.1, “Geometry Format Conversion Functions”

BENCHMARK()

Section 7.5.5.1, “How the Query Cache Operates”
Section 11.11.3, “Information Functions”
Section 7.2, “Optimizing SELECT and Other Statements”
Section 12.2.9.10, “Optimizing Subqueries”
Section 12.2.9.8, “Subqueries in the FROM clause”

BENCHMARK(10, (SELECT * FROM t))

Section 11.11.3, “Information Functions”

BENCHMARK(count,expr)

Section 11.11.3, “Information Functions”

BENCHMARK(loop_count,expression)

Section 7.2, “Optimizing SELECT and Other Statements”

BIN()

Section 8.1.5, “Bit-Field Values”

BIN(N)

Section 11.4, “String Functions”

BIT_AND()

Section 1.7.4, “MySQL Extensions to Standard SQL”

BIT_AND(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

BIT_COUNT()

Section 1.7.4, “MySQL Extensions to Standard SQL”

BIT_COUNT(N)

Section 11.11.1, “Bit Functions”

BIT_LENGTH()

Section 11.4, “String Functions”

BIT_LENGTH(str)

Section 11.4, “String Functions”

BIT_OR()

Section 1.7.4, “MySQL Extensions to Standard SQL”

BIT_OR(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

BIT_XOR()

Section 1.7.4, “MySQL Extensions to Standard SQL”

BIT_XOR(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

BdMPolyFromText(wkt,srid)

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

BdMPolyFromWKB(wkb,srid)

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

BdPolyFromText(wkt,srid)

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

BdPolyFromWKB(wkb,srid)

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

Boundary(g)

Section 11.13.5.2.1, “General Geometry Functions”

Buffer(g,d)

Section 11.13.5.3.2, “Spatial Operators”

CAST()

Section 9.1.8.2, “CONVERT() and CAST()
Section 8.1.5, “Bit-Field Values”
Section 11.9, “Cast Functions and Operators”
Section 11.2.3, “Comparison Functions and Operators”
Section 11.6, “Date and Time Functions”
Section 10.3, “Date and Time Types”
Section 1.7.5, “MySQL Differences from Standard SQL”
Section 9.1.8.1, “Result Strings”
Section 11.2.2, “Type Conversion in Expression Evaluation”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”
Section 8.4, “User-Defined Variables”

CAST(... AS UNSIGNED)

Section 8.1.3, “Hexadecimal Values”

CAST(... COLLATE ...)

Section 9.1.8.2, “CONVERT() and CAST()

CAST(...) COLLATE ...

Section 9.1.8.2, “CONVERT() and CAST()

CAST(expr AS CHAR)

Section 11.9, “Cast Functions and Operators”

CAST(expr AS type)

Section 11.9, “Cast Functions and Operators”

CAST(str AS BINARY)

Section 9.1.6.3, “BINARY Operator”
Section 11.9, “Cast Functions and Operators”

CEIL()

Section 11.5.2, “Mathematical Functions”

CEIL(X)

Section 11.5.2, “Mathematical Functions”

CEILING()

Section 11.5.2, “Mathematical Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

CEILING(3.7004397181411)

Section 18.2.3.1, “LINEAR HASH Partitioning”

CEILING(X)

Section 11.5.2, “Mathematical Functions”

CHAR()

Section 1.7.4, “MySQL Extensions to Standard SQL”
Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

CHAR(0)

Section 11.4, “String Functions”

CHAR(1,0)

Section 11.4, “String Functions”

CHAR(1,0,0)

Section 11.4, “String Functions”

CHAR(128 | key_num)

Section 11.11.2, “Encryption and Compression Functions”

CHAR(256)

Section 11.4, “String Functions”

CHAR(256*256)

Section 11.4, “String Functions”

CHAR(N)

Section 11.9, “Cast Functions and Operators”

CHAR(N,... [USING charset_name])

Section 11.4, “String Functions”

CHARACTER_LENGTH()

Section 11.4, “String Functions”

CHARACTER_LENGTH(str)

Section 11.4, “String Functions”

CHARSET()

Section 11.11.3, “Information Functions”
Section 9.1.8.1, “Result Strings”

CHARSET(str)

Section 11.11.3, “Information Functions”

CHAR_LENGTH()

Section 11.4, “String Functions”

CHAR_LENGTH(str)

Section 11.4, “String Functions”

COALESCE()

Section 11.2.3, “Comparison Functions and Operators”

COALESCE(a.c1,b.c1)

Section 12.2.8.1, “JOIN Syntax”

COALESCE(value,...)

Section 11.2.3, “Comparison Functions and Operators”

COERCIBILITY()

Section 11.11.3, “Information Functions”
Section 9.1.6.5, “Special Cases Where Collation Determination Is Tricky”

COERCIBILITY(str)

Section 11.11.3, “Information Functions”

COLLATION()

Section B.1.5.1, “Case Sensitivity in String Searches”
Section 11.11.3, “Information Functions”
Section 9.1.8.1, “Result Strings”

COLLATION(str)

Section 11.11.3, “Information Functions”

COMPRESS()

Section 11.11.2, “Encryption and Compression Functions”
Section 5.1.4, “Server System Variables”
Section 2.10.2, “Typical configure Options”

COMPRESS(string_to_compress)

Section 11.11.2, “Encryption and Compression Functions”

CONCAT()

Section 12.5.3.1, “CREATE FUNCTION Syntax”
Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 12.5.5.14, “SHOW CREATE VIEW Syntax”
Section 1.7.4, “MySQL Extensions to Standard SQL”
Section 9.1.8.1, “Result Strings”
Section 12.2.9.11, “Rewriting Subqueries as Joins”
Section 5.1.8, “Server SQL Modes”
Section 11.4, “String Functions”
Section 9.1.7, “String Repertoire”
Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”
Section 11.2.2, “Type Conversion in Expression Evaluation”
Section 11.10, “XML Functions”

CONCAT(p1.id, p1.tvab) + 0 AS tvid

Section 3.7.1, “Find All Nondistributed Twins”

CONCAT(str1,str2,...)

Section 11.4, “String Functions”

CONCAT_WS()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 11.4, “String Functions”

CONCAT_WS(separator,str1,str2,...)

Section 11.4, “String Functions”

CONNECTION_ID()

Section 7.5.5.1, “How the Query Cache Operates”
Section 11.11.3, “Information Functions”
Section 16.3.1, “Replication Features and Issues”

CONV()

Section 11.5.2, “Mathematical Functions”
Section 9.1.8.1, “Result Strings”

CONV(N,10,16)

Section 11.4, “String Functions”

CONV(N,10,2)

Section 11.4, “String Functions”

CONV(N,10,8)

Section 11.5.2, “Mathematical Functions”
Section 11.4, “String Functions”

CONV(N,from_base,to_base)

Section 11.5.2, “Mathematical Functions”

CONVERT()

Section 9.1.8.2, “CONVERT() and CAST()
Section 11.9, “Cast Functions and Operators”
Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 11.2.3, “Comparison Functions and Operators”
Section 11.11.4, “Miscellaneous Functions”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

CONVERT(... USING ...)

Section 9.1.8.2, “CONVERT() and CAST()
Section 11.9, “Cast Functions and Operators”

CONVERT(expr USING transcoding_name)

Section 11.9, “Cast Functions and Operators”

CONVERT(expr,type)

Section 11.9, “Cast Functions and Operators”

CONVERT(ucs2)

Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”

CONVERT_TZ()

Section 11.6, “Date and Time Functions”
Section 7.5.5.1, “How the Query Cache Operates”
Section 12.4.5.3, “Other Table-Locking Notes”
Section 16.3.1, “Replication Features and Issues”

CONVERT_TZ(...,...,@@global.time_zone)

Section 16.3.1, “Replication Features and Issues”

CONVERT_TZ(...,...,@@session.time_zone)

Section 16.3.1.24, “Replication and Time Zones”

CONVERT_TZ(dt,from_tz,to_tz)

Section 11.6, “Date and Time Functions”

COS(X)

Section 11.5.2, “Mathematical Functions”

COT(X)

Section 11.5.2, “Mathematical Functions”

COUNT()

Section 12.5.3.1, “CREATE FUNCTION Syntax”
Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 7.2.4, “WHERE Clause Optimization”
Section 3.3.4.8, “Counting Rows”
Section 18.1, “Overview of Partitioning in MySQL”
Section B.1.5.3, “Problems with NULL Values”
Section 5.1.8, “Server SQL Modes”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.5.2, “View Processing Algorithms”

COUNT(*)

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 7.2.4, “WHERE Clause Optimization”
Section 3.3.4.8, “Counting Rows”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section B.1.5.3, “Problems with NULL Values”

COUNT(DISTINCT ...)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

COUNT(DISTINCT expr,[expr...])

Section 11.12.1, “GROUP BY (Aggregate) Functions”

COUNT(DISTINCT value_list)

Section 1.7.4, “MySQL Extensions to Standard SQL”

COUNT(DISTINCT)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

COUNT(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

CRC32()

Section 11.5.2, “Mathematical Functions”

CRC32(expr)

Section 11.5.2, “Mathematical Functions”

CURDATE()

Section 3.3.4.5, “Date Calculations”
Section 11.6, “Date and Time Functions”
Section 7.5.5.1, “How the Query Cache Operates”

CURRENT_DATE

Section 12.1.17, “CREATE TABLE Syntax”
Section 10.1.4, “Data Type Default Values”
Section 11.6, “Date and Time Functions”
Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”

CURRENT_DATE()

Section 11.6, “Date and Time Functions”
Section 7.5.5.1, “How the Query Cache Operates”

CURRENT_TIME

Section 11.6, “Date and Time Functions”
Section 10.3.2, “The TIME Type”

CURRENT_TIME()

Section 11.6, “Date and Time Functions”
Section 7.5.5.1, “How the Query Cache Operates”

CURRENT_TIMESTAMP

Section 12.1.11, “CREATE EVENT Syntax”
Section 12.1.17, “CREATE TABLE Syntax”
Section 10.3.1.1, “TIMESTAMP Properties”
Section 10.1.4, “Data Type Default Values”
Section 11.6, “Date and Time Functions”

CURRENT_TIMESTAMP()

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”
Section 7.5.5.1, “How the Query Cache Operates”

CURRENT_USER

Section 12.1.11, “CREATE EVENT Syntax”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 12.1.19, “CREATE TRIGGER Syntax”
Section 12.1.20, “CREATE VIEW Syntax”
Section 11.11.3, “Information Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.3.1.10, “Replication and System Functions”

CURRENT_USER()

Section 12.1.11, “CREATE EVENT Syntax”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 12.1.19, “CREATE TRIGGER Syntax”
Section 12.1.20, “CREATE VIEW Syntax”
Section 12.5.5.22, “SHOW GRANTS Syntax”
Section 5.4.4, “Access Control, Stage 1: Connection Verification”
Section 5.5.9, “Auditing MySQL Account Activity”
Section 11.11.3, “Information Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.10, “Replication and System Functions”
Section 9.1.10, “UTF-8 for Metadata”

CURTIME()

Section 11.6, “Date and Time Functions”
Section 7.5.5.1, “How the Query Cache Operates”
Section 9.7, “MySQL Server Time Zone Support”

Centroid(mpoly)

Section 11.13.5.2.6, “MultiPolygon Functions”

Contains()

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

Contains(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

ConvexHull(g)

Section 11.13.5.3.2, “Spatial Operators”

Create_func_abs

Section 22.3.3, “Adding a New Native Function”

Create_func_arg0

Section 22.3.3, “Adding a New Native Function”

Create_func_arg1

Section 22.3.3, “Adding a New Native Function”

Create_func_arg2

Section 22.3.3, “Adding a New Native Function”

Create_func_arg3

Section 22.3.3, “Adding a New Native Function”

Create_func_concat

Section 22.3.3, “Adding a New Native Function”

Create_func_lcase

Section 22.3.3, “Adding a New Native Function”

Create_func_lpad

Section 22.3.3, “Adding a New Native Function”

Create_func_pow

Section 22.3.3, “Adding a New Native Function”

Create_func_uuid

Section 22.3.3, “Adding a New Native Function”

Create_native_func

Section 22.3.3, “Adding a New Native Function”

Crosses(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

DATABASE()

Section B.1.8.2, “Additional Known Issues”
Section 3.4, “Getting Information About Databases and Tables”
Section 7.5.5.1, “How the Query Cache Operates”
Section 11.11.3, “Information Functions”
Section B.1.8.1, “Open Issues in MySQL”
Section 9.1.10, “UTF-8 for Metadata”

DATE()

Section 11.6, “Date and Time Functions”

DATE(expr)

Section 11.6, “Date and Time Functions”

DATEDIFF()

Section 11.6, “Date and Time Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

DATEDIFF(expr1,expr2)

Section 11.6, “Date and Time Functions”

DATE_ADD()

Section 12.1.11, “CREATE EVENT Syntax”
Section 3.3.4.5, “Date Calculations”
Section 11.6, “Date and Time Functions”
Section 10.3, “Date and Time Types”

DATE_ADD(date,INTERVAL expr unit)

Section 11.6, “Date and Time Functions”

DATE_FORMAT()

Section 21.10.13, “C API Prepared Statement Problems”
Section 11.6, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”
Section 5.1.4, “Server System Variables”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

DATE_FORMAT(date,format)

Section 11.6, “Date and Time Functions”

DATE_SUB()

Section 11.6, “Date and Time Functions”
Section 10.3, “Date and Time Types”

DATE_SUB(date,INTERVAL expr unit)

Section 11.6, “Date and Time Functions”

DAY()

Section 11.6, “Date and Time Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

DAY(date)

Section 11.6, “Date and Time Functions”

DAYNAME()

Section 9.8, “MySQL Server Locale Support”
Section 5.1.4, “Server System Variables”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

DAYNAME(date)

Section 11.6, “Date and Time Functions”

DAYOFMONTH()

Section 3.3.4.5, “Date Calculations”
Section 11.6, “Date and Time Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

DAYOFMONTH(date)

Section 11.6, “Date and Time Functions”

DAYOFWEEK()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

DAYOFWEEK(date)

Section 11.6, “Date and Time Functions”

DAYOFYEAR()

Section 18.2, “Partition Types”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

DAYOFYEAR(date)

Section 11.6, “Date and Time Functions”

DECODE()

Section 11.11.2, “Encryption and Compression Functions”
Section 1.7.4, “MySQL Extensions to Standard SQL”

DECODE(crypt_str,pass_str)

Section 11.11.2, “Encryption and Compression Functions”

DEFAULT()

Section 11.11.4, “Miscellaneous Functions”

DEFAULT(col_name)

Section 12.2.5, “INSERT Syntax”
Section 12.2.7, “REPLACE Syntax”
Section 11.11.4, “Miscellaneous Functions”

DEFAULT(i)

Section 10.1.4, “Data Type Default Values”

DEGREES(X)

Section 11.5.2, “Mathematical Functions”

DES_DECRYPT()

Section 11.11.2, “Encryption and Compression Functions”
Section 5.1.2, “Server Command Options”

DES_DECRYPT(crypt_str[,key_str])

Section 11.11.2, “Encryption and Compression Functions”

DES_ENCRYPT()

Section 11.11.2, “Encryption and Compression Functions”
Section 5.1.2, “Server Command Options”

DES_ENCRYPT(str[,{key_num|key_str}])

Section 11.11.2, “Encryption and Compression Functions”

Difference(g1,g2)

Section 11.13.5.3.2, “Spatial Operators”

Dimension(g)

Section 11.13.5.2.1, “General Geometry Functions”

Disjoint(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

Distance()

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

Distance(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

ELT()

Section B.1.8.2, “Additional Known Issues”
Section 1.7.4, “MySQL Extensions to Standard SQL”
Section B.1.8.1, “Open Issues in MySQL”
Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

ELT(N,str1,str2,str3,...)

Section 11.4, “String Functions”

ENCODE()

Section 11.11.2, “Encryption and Compression Functions”
Section 1.7.4, “MySQL Extensions to Standard SQL”

ENCODE(str,pass_str)

Section 11.11.2, “Encryption and Compression Functions”

ENCRYPT()

Section 11.11.2, “Encryption and Compression Functions”
Section 7.5.5.1, “How the Query Cache Operates”
Section 1.7.4, “MySQL Extensions to Standard SQL”
Section 5.1.4, “Server System Variables”
Section 5.5.1, “User Names and Passwords”

ENCRYPT(str[,salt])

Section 11.11.2, “Encryption and Compression Functions”

EXP()

Section 11.5.2, “Mathematical Functions”

EXP(X)

Section 11.5.2, “Mathematical Functions”

EXPORT_SET(bits,on,off[,separator[,number_of_bits]])

Section 11.4, “String Functions”

EXTRACT()

Section 11.9, “Cast Functions and Operators”
Section 11.6, “Date and Time Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

EXTRACT(unit FROM date)

Section 11.6, “Date and Time Functions”

EndPoint()

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.2.4, “MultiLineString Functions”

EndPoint(ls)

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

Envelope(g)

Section 11.13.5.2.1, “General Geometry Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

Equals(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

ExteriorRing(poly)

Section 11.13.5.2.5, “Polygon Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

ExtractValue('<a><b>Sakila</b></a>', '/a/b')

Section 11.10, “XML Functions”

ExtractValue('<a><b>Sakila</b></a>', '/a/b/text()')

Section 11.10, “XML Functions”

ExtractValue()

Section 1.4.1, “What Is New in MySQL 5.1”
Section 11.10, “XML Functions”

ExtractValue(xml_frag, xpath_expr)

Section 11.10, “XML Functions”

FIELD()

Section 11.4, “String Functions”

FIELD(str,str1,str2,str3,...)

Section 11.4, “String Functions”

FIND_IN_SET()

Section 11.4, “String Functions”
Section 10.4.5, “The SET Type”

FIND_IN_SET(str,strlist)

Section 11.4, “String Functions”

FLOOR()

Section 11.5.1, “Arithmetic Operators”
Section 11.5.2, “Mathematical Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

FLOOR(X)

Section 11.5.2, “Mathematical Functions”

FLOOR(i RAND() * (j i))

Section 11.5.2, “Mathematical Functions”

FORMAT()

Section 1.7.4, “MySQL Extensions to Standard SQL”
Section 9.1.8.1, “Result Strings”

FORMAT(X,D)

Section 11.5.2, “Mathematical Functions”
Section 11.11.4, “Miscellaneous Functions”
Section 11.4, “String Functions”

FOUND_ROWS()

Section 7.5.5.1, “How the Query Cache Operates”
Section 11.11.3, “Information Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.10, “Replication and System Functions”

FROM_DAYS()

Section 11.6, “Date and Time Functions”
Section 1.7.4, “MySQL Extensions to Standard SQL”

FROM_DAYS(N)

Section 11.6, “Date and Time Functions”

FROM_UNIXTIME()

Section 11.6, “Date and Time Functions”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.24, “Replication and Time Zones”

FROM_UNIXTIME(unix_timestamp)

Section 11.6, “Date and Time Functions”

FROM_UNIXTIME(unix_timestamp,format)

Section 11.6, “Date and Time Functions”

GET_FORMAT()

Section 11.6, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”

GET_FORMAT(DATE,'EUR')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATE,'INTERNAL')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATE,'ISO')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATE,'JIS')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATE,'USA')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATETIME,'EUR')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATETIME,'INTERNAL')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATETIME,'ISO')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATETIME,'JIS')

Section 11.6, “Date and Time Functions”

GET_FORMAT(DATETIME,'USA')

Section 11.6, “Date and Time Functions”

GET_FORMAT(TIME,'EUR')

Section 11.6, “Date and Time Functions”

GET_FORMAT(TIME,'INTERNAL')

Section 11.6, “Date and Time Functions”

GET_FORMAT(TIME,'ISO')

Section 11.6, “Date and Time Functions”

GET_FORMAT(TIME,'JIS')

Section 11.6, “Date and Time Functions”

GET_FORMAT(TIME,'USA')

Section 11.6, “Date and Time Functions”

GET_FORMAT({DATE|TIME|DATETIME}, {'EUR'|'USA'|'JIS'|'ISO'|'INTERNAL'})

Section 11.6, “Date and Time Functions”

GET_LOCK()

Section 12.1.11, “CREATE EVENT Syntax”
Section 12.5.6.4, “KILL Syntax”
Section 21.10.3.3, “mysql_change_user()
Section 21.10.11, “Controlling Automatic Reconnection Behavior”
Section 7.5.6.2, “General Thread States”
Section 7.5.5.1, “How the Query Cache Operates”
Section 7.3.1, “Internal Locking Methods”
Section 11.11.4, “Miscellaneous Functions”
Section 12.4.5.3, “Other Table-Locking Notes”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.10, “Replication and System Functions”

GET_LOCK(str,timeout)

Section 11.11.4, “Miscellaneous Functions”

GLength()

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.2.4, “MultiLineString Functions”
Section 11.13.7, “MySQL Conformance and Compatibility”

GLength(ls)

Section 11.13.5.2.3, “LineString Functions”

GLength(mls)

Section 11.13.5.2.4, “MultiLineString Functions”

GREATEST()

Section 11.2.3, “Comparison Functions and Operators”
Section 9.1.8.1, “Result Strings”

GREATEST(value1,value2,...)

Section 11.2.3, “Comparison Functions and Operators”

GREATEST(x,NULL)

Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

GROUP_CONCAT()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section B.1.8.2, “Additional Known Issues”
Changes in Release 4.1.x (Production)
Section 1.4.1, “What Is New in MySQL 5.1”
Section 1.7.4, “MySQL Extensions to Standard SQL”
Section B.1.8.1, “Open Issues in MySQL”
Section 5.1.4, “Server System Variables”

GROUP_CONCAT(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

GeomCollFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

GeomCollFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

GeomFromText()

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
Section 11.13.4.4, “Populating Spatial Columns”

GeomFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”
Section 11.13.5.1, “Geometry Format Conversion Functions”

GeomFromWKB()

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”
Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

GeomFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”
Section 11.13.5.1, “Geometry Format Conversion Functions”

GeometryCollection(g1,g2,...)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

GeometryCollectionFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

GeometryCollectionFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

GeometryFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

GeometryFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

GeometryN(gc,N)

Section 11.13.5.2.7, “GeometryCollection Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

GeometryType(g)

Section 11.13.5.2.1, “General Geometry Functions”

HEX()

Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 8.1.3, “Hexadecimal Values”
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

HEX(N_or_S)

Section 11.5.2, “Mathematical Functions”
Section 11.4, “String Functions”

HEX(str)

Section 11.4, “String Functions”

HOUR()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

HOUR(time)

Section 11.6, “Date and Time Functions”

IF()

Section B.1.8.2, “Additional Known Issues”
Section 11.3, “Control Flow Functions”
Section 1.7.4, “MySQL Extensions to Standard SQL”
Section B.1.8.1, “Open Issues in MySQL”
Section 9.1.8.1, “Result Strings”

IF(0)

Section 11.3, “Control Flow Functions”

IF(0.1)

Section 11.3, “Control Flow Functions”

IF(expr1,expr2,expr3)

Section 11.3, “Control Flow Functions”

IFNULL()

Section 11.3, “Control Flow Functions”
Section B.1.5.3, “Problems with NULL Values”

IFNULL(expr1,expr2)

Section 11.3, “Control Flow Functions”

IN()

Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”
Section 11.2.2, “Type Conversion in Expression Evaluation”

IN(value_list)

Section D.3, “Restrictions on Subqueries”

INET_ATON()

Section 11.11.4, “Miscellaneous Functions”

INET_ATON(expr)

Section 11.11.4, “Miscellaneous Functions”

INET_NTOA()

Section 11.11.4, “Miscellaneous Functions”

INET_NTOA(expr)

Section 11.11.4, “Miscellaneous Functions”

INSERT(str,pos,len,newstr)

Section 11.4, “String Functions”

INSTR()

Section 9.1.8.1, “Result Strings”

INSTR(str,substr)

Section 11.4, “String Functions”

INTERVAL(N,N1,N2,N3,...)

Section 11.2.3, “Comparison Functions and Operators”

ISNULL()

Section 11.2.3, “Comparison Functions and Operators”

ISNULL(expr)

Section 11.2.3, “Comparison Functions and Operators”

IS_FREE_LOCK()

Section 11.11.4, “Miscellaneous Functions”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.10, “Replication and System Functions”

IS_FREE_LOCK(str)

Section 11.11.4, “Miscellaneous Functions”

IS_USED_LOCK()

Section 11.11.4, “Miscellaneous Functions”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.10, “Replication and System Functions”

IS_USED_LOCK(str)

Section 11.11.4, “Miscellaneous Functions”

InteriorRingN(poly,N)

Section 11.13.5.2.5, “Polygon Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

Intersection(g1,g2)

Section 11.13.5.3.2, “Spatial Operators”

Intersects(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

IsClosed(mls)

Section 11.13.5.2.4, “MultiLineString Functions”

IsEmpty(g)

Section 11.13.5.2.1, “General Geometry Functions”

IsRing(ls)

Section 11.13.5.2.3, “LineString Functions”

IsSimple()

Section 11.13.5.2.1, “General Geometry Functions”

IsSimple(g)

Section 11.13.5.2.1, “General Geometry Functions”

LAST_DAY()

Section 11.6, “Date and Time Functions”

LAST_DAY(date)

Section 11.6, “Date and Time Functions”

LAST_INSERT_ID()

Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 12.1.17, “CREATE TABLE Syntax”
Section 12.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 12.2.5.2, “INSERT DELAYED Syntax”
Section 12.2.5, “INSERT Syntax”
Section 21.10.3.37, “mysql_insert_id()
Section 21.10.11, “Controlling Automatic Reconnection Behavior”
Description
Section 7.5.5.1, “How the Query Cache Operates”
Section 21.10.10.3, “How to Get the Unique ID for the Last Inserted Row”
Section 11.11.3, “Information Functions”
Section 1.7.4, “MySQL Extensions to Standard SQL”
Section 12.4.5.3, “Other Table-Locking Notes”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.1, “Replication and AUTO_INCREMENT
Section 5.1.5, “Session System Variables”
Section 19.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()
Section 1.7.5.2, “Transactions and Atomic Operations”
Section 16.3.5, “Troubleshooting Replication”
Section 19.5.3, “Updatable and Insertable Views”
Section 3.6.9, “Using AUTO_INCREMENT

LAST_INSERT_ID(expr)

Section 12.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 21.10.3.37, “mysql_insert_id()
Section 21.10.7.16, “mysql_stmt_insert_id()
Section 11.11.3, “Information Functions”

LCASE()

Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

LCASE(str)

Section 11.4, “String Functions”

LEAST()

Section 11.2.3, “Comparison Functions and Operators”
Section 9.1.8.1, “Result Strings”

LEAST(value1,value2,...)

Section 11.2.3, “Comparison Functions and Operators”

LEAST(x,NULL)

Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

LEFT()

Section 11.9, “Cast Functions and Operators”

LEFT(str,len)

Section 11.4, “String Functions”

LENGTH()

Section 11.4, “String Functions”

LENGTH(str)

Section 11.4, “String Functions”

LN()

Section 11.5.2, “Mathematical Functions”

LN(X)

Section 11.5.2, “Mathematical Functions”

LOAD_FILE()

Section 7.5.5.1, “How the Query Cache Operates”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.10, “Replication and System Functions”
Section 5.3.3, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.4, “Server System Variables”

LOAD_FILE(file_name)

Section 11.4, “String Functions”

LOCALTIME

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”

LOCALTIME()

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”

LOCALTIMESTAMP

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”

LOCALTIMESTAMP()

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”

LOCATE()

Section 11.4, “String Functions”

LOCATE(substr,str)

Section 11.4, “String Functions”

LOCATE(substr,str,pos)

Section 11.4, “String Functions”

LOG()

Section 11.5.2, “Mathematical Functions”

LOG(10,X)

Section 11.5.2, “Mathematical Functions”

LOG(2,13)

Section 18.2.3.1, “LINEAR HASH Partitioning”

LOG(B,X)

Section 11.5.2, “Mathematical Functions”

LOG(X)

Section 11.5.2, “Mathematical Functions”

LOG(X) / LOG(2)

Section 11.5.2, “Mathematical Functions”

LOG(X) / LOG(B)

Section 11.5.2, “Mathematical Functions”

LOG10(X)

Section 11.5.2, “Mathematical Functions”

LOG2()

Section 11.5.2, “Mathematical Functions”

LOG2(X)

Section 11.5.2, “Mathematical Functions”

LOWER()

Section 11.9, “Cast Functions and Operators”
Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”
Section 9.1.12.1, “Unicode Character Sets”

LOWER(str)

Section 11.4, “String Functions”

LPAD(str,len,padstr)

Section 11.4, “String Functions”

LTRIM()

Section 9.1.8.1, “Result Strings”

LTRIM(str)

Section 11.4, “String Functions”

Length()

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.2.4, “MultiLineString Functions”
Section 11.13.7, “MySQL Conformance and Compatibility”

LineFromText()

Section 11.13.5.1, “Geometry Format Conversion Functions”

LineFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

LineFromWKB()

Section 11.13.5.1, “Geometry Format Conversion Functions”

LineFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

LineString(pt1,pt2,...)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

LineStringFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

LineStringFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

MAKEDATE()

Section 11.6, “Date and Time Functions”

MAKEDATE(year,dayofyear)

Section 11.6, “Date and Time Functions”

MAKETIME()

Section 11.6, “Date and Time Functions”

MAKETIME(hour,minute,second)

Section 11.6, “Date and Time Functions”

MAKE_SET(bits,str1,str2,...)

Section 11.4, “String Functions”

MASTER_POS_WAIT()

Section 12.6.2.4, “MASTER_POS_WAIT() Syntax”
Section 7.5.5.1, “How the Query Cache Operates”
Section 11.11.4, “Miscellaneous Functions”
Section 16.3.4, “Replication FAQ”

MASTER_POS_WAIT(log_name,log_pos[,timeout])

Section 11.11.4, “Miscellaneous Functions”

MATCH (col1,col2,...) AGAINST (expr [search_modifier])

Section 11.8, “Full-Text Search Functions”

MATCH()

Section 11.8.6, “Fine-Tuning MySQL Full-Text Search”
Section 11.8.5, “Full-Text Restrictions”
Section 11.8, “Full-Text Search Functions”
Section 11.8.1, “Natural Language Full-Text Searches”

MATCH() ... AGAINST

Section 11.8, “Full-Text Search Functions”

MATCH() ... AGAINST()

Section 11.8.2, “Boolean Full-Text Searches”

MAX()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
Section B.1.8.2, “Additional Known Issues”
Section 11.2.3, “Comparison Functions and Operators”
Section 7.4.4, “How MySQL Uses Indexes”
Section 7.2.14.1, “Loose index scan”
Section B.1.8.1, “Open Issues in MySQL”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 12.2.9.10, “Optimizing Subqueries”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.5.2, “View Processing Algorithms”
Section 10.3.4, “Year 2000 Issues and Date Types”

MAX([DISTINCT] expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

MAX(auto_increment_column) + 1 WHERE prefix=given-prefix

Section 3.6.9, “Using AUTO_INCREMENT

MAX(col_name)

Section 10.1.1, “Overview of Numeric Types”

MAX(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

MAX(t1.b)

Section 5.1.8, “Server SQL Modes”

MBRContains()

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
Section 11.13.6.2, “Using a Spatial Index”

MBRContains(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBRDisjoint(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBREqual(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBRIntersects(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBROverlaps(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBRTouches(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBRWithin()

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
Section 11.13.6.2, “Using a Spatial Index”

MBRWithin(g1,g2)

Section 11.13.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MD5()

Section 18.2.4, “KEY Partitioning”
Section 8.2, “Schema Object Names”
Section 11.11.2, “Encryption and Compression Functions”
Section 5.3.1, “General Security Guidelines”
Section 5.5.6.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 1.7.4, “MySQL Extensions to Standard SQL”

MD5(str)

Section 11.11.2, “Encryption and Compression Functions”

MICROSECOND()

Section 11.6, “Date and Time Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

MICROSECOND(expr)

Section 11.6, “Date and Time Functions”

MID()

Section 9.1.8.1, “Result Strings”

MID(expr,1,255)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

MID(str,pos,len)

Section 11.4, “String Functions”

MIN()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 11.12.3, “GROUP BY and HAVING with Hidden Columns”
Section 7.2.4, “WHERE Clause Optimization”
Section B.1.8.2, “Additional Known Issues”
Section 11.2.3, “Comparison Functions and Operators”
Section 7.4.4, “How MySQL Uses Indexes”
Section 7.2.14.1, “Loose index scan”
Section B.1.8.1, “Open Issues in MySQL”
Section 7.2.1, “Optimizing Queries with EXPLAIN
Section 12.2.9.10, “Optimizing Subqueries”
Section B.1.5.3, “Problems with NULL Values”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.5.2, “View Processing Algorithms”
Section 10.3.4, “Year 2000 Issues and Date Types”

MIN(DATE_ADD(timestamp,INTERVAL 0 DAY))

Section 10.3.4, “Year 2000 Issues and Date Types”

MIN([DISTINCT] expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

MIN(col_name)

Section 10.1.1, “Overview of Numeric Types”

MIN(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

MIN(number-with-zerofill)

Section 21.10.13, “C API Prepared Statement Problems”

MINUTE()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

MINUTE(time)

Section 11.6, “Date and Time Functions”

MLineFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

MLineFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

MOD()

Section 11.5.1, “Arithmetic Operators”
Section 3.3.4.5, “Date Calculations”
Section 11.5.2, “Mathematical Functions”
Section 1.7.4, “MySQL Extensions to Standard SQL”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

MOD(N,0)

Section 11.5.2, “Mathematical Functions”

MOD(N,M)

Section 11.5.2, “Mathematical Functions”
Section 1.7.4, “MySQL Extensions to Standard SQL”

MOD(X,0)

Section 5.1.8, “Server SQL Modes”

MOD(something,12)

Section 3.3.4.5, “Date Calculations”

MONTH()

Section 3.3.4.5, “Date Calculations”
Section 18.2, “Partition Types”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

MONTH(birth)

Section 3.3.4.5, “Date Calculations”

MONTH(date)

Section 11.6, “Date and Time Functions”

MONTHNAME()

Section 9.8, “MySQL Server Locale Support”
Section 5.1.4, “Server System Variables”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

MONTHNAME(date)

Section 11.6, “Date and Time Functions”

MPointFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

MPointFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

MPolyFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

MPolyFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

MultiLineString(ls1,ls2,...)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

MultiLineStringFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

MultiLineStringFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

MultiPoint(pt1,pt2,...)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

MultiPointFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

MultiPointFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

MultiPolygon(poly1,poly2,...)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

MultiPolygonFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

MultiPolygonFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

NAME_CONST()

Section 19.6, “Binary Logging of Stored Programs”
Section 11.11.4, “Miscellaneous Functions”

NAME_CONST(name,value)

Section 11.11.4, “Miscellaneous Functions”

NOW()

Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 12.1.17, “CREATE TABLE Syntax”
Section 10.3.1.1, “TIMESTAMP Properties”
Section 10.1.4, “Data Type Default Values”
Section 11.6, “Date and Time Functions”
Section 7.5.5.1, “How the Query Cache Operates”
Section A.1, “MySQL 5.1 FAQ — General”
Section 9.7, “MySQL Server Time Zone Support”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.10, “Replication and System Functions”
Section 16.3.1.24, “Replication and Time Zones”
Section 5.1.2, “Server Command Options”
Section 5.1.5, “Session System Variables”
Section 10.3.1, “The DATETIME, DATE, and TIMESTAMP Types”
Section 10.3.3, “The YEAR Type”
Section 9.7.2, “Time Zone Leap Second Support”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

NULLIF()

Section 11.3, “Control Flow Functions”

NULLIF(expr1,expr2)

Section 11.3, “Control Flow Functions”

NumGeometries(gc)

Section 11.13.5.2.7, “GeometryCollection Functions”

NumInteriorRings(poly)

Section 11.13.5.2.5, “Polygon Functions”

NumPoints(ls)

Section 11.13.5.2.3, “LineString Functions”

OCT(N)

Section 11.5.2, “Mathematical Functions”
Section 11.4, “String Functions”

OCTET_LENGTH()

Section 11.4, “String Functions”

OCTET_LENGTH(str)

Section 11.4, “String Functions”

OLD_PASSWORD()

Section B.1.2.4, “Client does not support authentication protocol
Section 12.5.1.6, “SET PASSWORD Syntax”
Section 11.11.2, “Encryption and Compression Functions”
Section 5.5.6.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 5.5.6.3, “Password Hashing in MySQL”

OLD_PASSWORD(str)

Section 11.11.2, “Encryption and Compression Functions”

ORD()

Section 11.4, “String Functions”

ORD(str)

Section 11.4, “String Functions”

Overlaps(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

PASSWORD()

Section 12.5.1.1, “CREATE USER Syntax”
Section 12.5.1.3, “GRANT Syntax”
Section B.1.2.15, “Ignoring user
Section 18.2.4, “KEY Partitioning”
Section 12.5.1.6, “SET PASSWORD Syntax”
Section 5.4.4, “Access Control, Stage 1: Connection Verification”
Section 5.5.2, “Adding User Accounts”
Section 5.5.5, “Assigning Account Passwords”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 11.11.2, “Encryption and Compression Functions”
Section 5.5.6.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 1.7.4, “MySQL Extensions to Standard SQL”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 16.3.1, “Replication Features and Issues”
Section 2.11.3, “Securing the Initial MySQL Accounts”
Section 5.5.1, “User Names and Passwords”

PASSWORD(str)

Section 11.11.2, “Encryption and Compression Functions”

PERIOD_ADD()

Section 1.7.4, “MySQL Extensions to Standard SQL”

PERIOD_ADD(P,N)

Section 11.6, “Date and Time Functions”

PERIOD_DIFF()

Section 1.7.4, “MySQL Extensions to Standard SQL”

PERIOD_DIFF(P1,P2)

Section 11.6, “Date and Time Functions”

PI()

Section 8.2.4, “Function Name Parsing and Resolution”
Section 11.5.2, “Mathematical Functions”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

POSITION(substr IN str)

Section 11.4, “String Functions”

POW()

Section 11.5.2, “Mathematical Functions”

POW(5-int_col,3) + 6

Section 18.2.3, “HASH Partitioning”

POW(X,Y)

Section 11.5.2, “Mathematical Functions”

POWER(2,4)

Section 18.2.3.1, “LINEAR HASH Partitioning”

POWER(X,Y)

Section 11.5.2, “Mathematical Functions”

Point()

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

Point(x,y)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

PointFromText()

Section 11.13.5.1, “Geometry Format Conversion Functions”

PointFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

PointFromWKB()

Section 11.13.5.1, “Geometry Format Conversion Functions”

PointFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

PointN(ls,N)

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

PolyFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

PolyFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

Polygon(ls1,ls2,...)

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

PolygonFromText(wkt[,srid])

Section 11.13.4.2.1, “Creating Geometry Values Using WKT Functions”

PolygonFromWKB(wkb[,srid])

Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”

QUARTER()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

QUARTER(date)

Section 11.6, “Date and Time Functions”

QUOTE()

Section 11.4, “String Functions”

QUOTE(str)

Section 11.4, “String Functions”

RADIANS(X)

Section 11.5.2, “Mathematical Functions”

RAND()

Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Description
Section 7.5.5.1, “How the Query Cache Operates”
Section 11.5.2, “Mathematical Functions”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.10, “Replication and System Functions”
Section 5.1.5, “Session System Variables”

RAND(N)

Section 11.5.2, “Mathematical Functions”

RAND(some_non_rand_expr)

Section 16.3.1, “Replication Features and Issues”

RELEASE_LOCK()

Section 12.2.3, “DO Syntax”
Section 7.5.5.1, “How the Query Cache Operates”
Section 7.3.1, “Internal Locking Methods”
Section 11.11.4, “Miscellaneous Functions”
Section 12.4.5.3, “Other Table-Locking Notes”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.10, “Replication and System Functions”

RELEASE_LOCK(str)

Section 11.11.4, “Miscellaneous Functions”

REPEAT()

Section 9.1.8.1, “Result Strings”

REPEAT(str,count)

Section 11.4, “String Functions”

REPLACE()

Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

REPLACE(str,from_str,to_str)

Section 11.4, “String Functions”

REVERSE()

Section 9.1.8.1, “Result Strings”

REVERSE(str)

Section 11.4, “String Functions”

RIGHT()

Section 3.3.4.5, “Date Calculations”
Section 9.1.8.1, “Result Strings”

RIGHT(str,len)

Section 11.4, “String Functions”

ROUND()

Section 11.5.2, “Mathematical Functions”
Section B.1.5.8, “Problems with Floating-Point Comparisons”

ROUND(X)

Section 11.5.2, “Mathematical Functions”

ROUND(X,D)

Section 11.5.2, “Mathematical Functions”

ROW_COUNT()

Section 12.2.1, “CALL Syntax”
Section 12.2.2, “DELETE Syntax”
Section 12.2.5, “INSERT Syntax”
Section 21.10.3.1, “mysql_affected_rows()
Section 11.11.3, “Information Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.3.1.10, “Replication and System Functions”

RPAD()

Section 9.1.8.1, “Result Strings”

RPAD(str,len,padstr)

Section 11.4, “String Functions”

RTRIM()

Section 9.1.8.1, “Result Strings”

RTRIM(str)

Section 11.4, “String Functions”

Related()

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

SCHEMA()

Section 11.11.3, “Information Functions”

SECOND()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

SECOND(time)

Section 11.6, “Date and Time Functions”

SEC_TO_TIME(seconds)

Section 11.6, “Date and Time Functions”

SESSION_USER()

Section 11.11.3, “Information Functions”
Section 9.1.10, “UTF-8 for Metadata”

SHA()

Section 11.11.2, “Encryption and Compression Functions”

SHA(str)

Section 11.11.2, “Encryption and Compression Functions”

SHA1()

Section 11.11.2, “Encryption and Compression Functions”
Section 5.3.1, “General Security Guidelines”
Section 5.5.6.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”

SHA1(str)

Section 11.11.2, “Encryption and Compression Functions”

SHA2()

Section 11.11.2, “Encryption and Compression Functions”

SHA2(str, hash_length)

Section 11.11.2, “Encryption and Compression Functions”

SIGN(X)

Section 11.5.2, “Mathematical Functions”

SIN(3.14)

Section 22.3.2.3, “UDF Argument Processing”

SIN(X)

Section 11.5.2, “Mathematical Functions”

SLEEP()

Section 7.5.5.1, “How the Query Cache Operates”
Section 11.11.4, “Miscellaneous Functions”
Section 16.3.1, “Replication Features and Issues”
Section D.7.3, “Windows Platform Limitations”

SLEEP(duration)

Section 11.11.4, “Miscellaneous Functions”

SOUNDEX()

Section 22.3, “Adding New Functions to MySQL”
Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

SOUNDEX(expr1) = SOUNDEX(expr2)

Section 11.4, “String Functions”

SOUNDEX(str)

Section 11.4, “String Functions”

SPACE()

Section 9.1.8.1, “Result Strings”

SPACE(N)

Section 11.4, “String Functions”

SQRT(X)

Section 11.5.2, “Mathematical Functions”

SRID(g)

Section 11.13.5.2.1, “General Geometry Functions”

STD()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 1.7.4, “MySQL Extensions to Standard SQL”

STD(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STDDEV()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STDDEV(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STDDEV_POP()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STDDEV_POP(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STDDEV_SAMP()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STDDEV_SAMP(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

STRCMP()

Section B.1.5.2, “Problems Using DATE Columns”
Section 11.4.1, “String Comparison Functions”

STRCMP(expr1,expr2)

Section 11.4.1, “String Comparison Functions”

STR_TO_DATE()

Section 11.6, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”

STR_TO_DATE(str,format)

Section 11.6, “Date and Time Functions”

SUBDATE()

Section 11.6, “Date and Time Functions”

SUBDATE(date,INTERVAL expr unit)

Section 11.6, “Date and Time Functions”

SUBDATE(expr,days)

Section 11.6, “Date and Time Functions”

SUBSTR()

Section 11.4, “String Functions”

SUBSTR(str FROM pos FOR len)

Section 11.4, “String Functions”

SUBSTR(str FROM pos)

Section 11.4, “String Functions”

SUBSTR(str,pos)

Section 11.4, “String Functions”

SUBSTR(str,pos,len)

Section 11.4, “String Functions”

SUBSTRING()

Section 5.5.9, “Auditing MySQL Account Activity”
Changes in Release 4.1.x (Production)
Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”
Section 10.4.3, “The BLOB and TEXT Types”

SUBSTRING(str FROM pos FOR len)

Section 11.4, “String Functions”

SUBSTRING(str FROM pos)

Section 11.4, “String Functions”

SUBSTRING(str,pos)

Section 11.4, “String Functions”

SUBSTRING(str,pos,len)

Section 11.4, “String Functions”

SUBSTRING_INDEX()

Section 11.4, “String Functions”

SUBSTRING_INDEX(str,delim,count)

Section 11.4, “String Functions”

SUBTIME()

Section 11.6, “Date and Time Functions”

SUBTIME(expr1,expr2)

Section 11.6, “Date and Time Functions”

SUM()

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 22.3.2, “Adding a New User-Defined Function”
Section 10.1.2, “Overview of Date and Time Types”
Section 18.1, “Overview of Partitioning in MySQL”
Section B.1.5.3, “Problems with NULL Values”
Section 10.4.4, “The ENUM Type”
Section 10.4.5, “The SET Type”
Section 19.5.3, “Updatable and Insertable Views”
Section 19.5.2, “View Processing Algorithms”

SUM([DISTINCT] expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

SUM(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

SYSDATE()

Section 11.6, “Date and Time Functions”
Section 7.5.5.1, “How the Query Cache Operates”
Section 16.3.1.10, “Replication and System Functions”
Section 5.1.2, “Server Command Options”
Section 5.1.5, “Session System Variables”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

SYSTEM_USER()

Section 11.11.3, “Information Functions”
Section 9.1.10, “UTF-8 for Metadata”

StartPoint()

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.2.4, “MultiLineString Functions”

StartPoint(ls)

Section 11.13.5.2.3, “LineString Functions”
Section 11.13.5.3.1, “Geometry Functions That Produce New Geometries”

SymDifference(g1,g2)

Section 11.13.5.3.2, “Spatial Operators”

TAN(X)

Section 11.5.2, “Mathematical Functions”

TIME()

Section 11.6, “Date and Time Functions”

TIME(expr)

Section 11.6, “Date and Time Functions”

TIMEDIFF()

Section 11.6, “Date and Time Functions”

TIMEDIFF(expr1,expr2)

Section 11.6, “Date and Time Functions”

TIMESTAMP()

Section 11.6, “Date and Time Functions”

TIMESTAMP(expr)

Section 11.6, “Date and Time Functions”

TIMESTAMP(expr1,expr2)

Section 11.6, “Date and Time Functions”

TIMESTAMPADD()

Section 11.6, “Date and Time Functions”

TIMESTAMPADD(unit,interval,datetime_expr)

Section 11.6, “Date and Time Functions”

TIMESTAMPDIFF()

Section 11.6, “Date and Time Functions”

TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)

Section 11.6, “Date and Time Functions”

TIME_FORMAT(time,format)

Section 11.6, “Date and Time Functions”

TIME_TO_SEC()

Section 18.5.3, “Partitioning Limitations Relating to Functions”

TIME_TO_SEC(time)

Section 11.6, “Date and Time Functions”

TO_DAYS()

Section 11.6, “Date and Time Functions”
Section 1.7.4, “MySQL Extensions to Standard SQL”
Section 18.4, “Partition Pruning”
Section 18.2, “Partition Types”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

TO_DAYS(date)

Section 11.6, “Date and Time Functions”

TO_DAYS(date_col)

Section 18.2.3, “HASH Partitioning”

TRIM()

Section 1.7.4, “MySQL Extensions to Standard SQL”
Section 9.1.8.1, “Result Strings”

TRIM([remstr FROM] str)

Section 11.4, “String Functions”

TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str)

Section 11.4, “String Functions”

TRUNCATE()

Section 11.5.2, “Mathematical Functions”

TRUNCATE(X,D)

Section 11.5.2, “Mathematical Functions”

Touches(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

UCASE()

Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”

UCASE(str)

Section 11.4, “String Functions”

UNCOMPRESS()

Section 11.11.2, “Encryption and Compression Functions”
Section 5.1.4, “Server System Variables”
Section 2.10.2, “Typical configure Options”

UNCOMPRESS(string_to_uncompress)

Section 11.11.2, “Encryption and Compression Functions”

UNCOMPRESSED_LENGTH()

Section 11.11.2, “Encryption and Compression Functions”

UNCOMPRESSED_LENGTH(compressed_string)

Section 11.11.2, “Encryption and Compression Functions”

UNHEX()

Section 11.4, “String Functions”

UNHEX(str)

Section 11.4, “String Functions”

UNIX_TIMESTAMP()

Section 11.6, “Date and Time Functions”
Section 7.5.5.1, “How the Query Cache Operates”
Section 16.3.1, “Replication Features and Issues”
Section B.1.4.6, “Time Zone Problems”

UNIX_TIMESTAMP(date)

Section 11.6, “Date and Time Functions”

UPPER()

Section 11.9, “Cast Functions and Operators”
Section 9.1.8.1, “Result Strings”
Section 11.4, “String Functions”
Section 9.1.12.1, “Unicode Character Sets”

UPPER(X)

Section 9.1.8.1, “Result Strings”

UPPER(_utf8'abc')

Section 9.1.7, “String Repertoire”

UPPER(str)

Section 11.4, “String Functions”

USER()

Section 5.5.9, “Auditing MySQL Account Activity”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 9.1.6.6, “Collations Must Be for the Right Character Set”
Section 7.5.5.1, “How the Query Cache Operates”
Section 11.11.3, “Information Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.10, “Replication and System Functions”
Section 9.1.6.5, “Special Cases Where Collation Determination Is Tricky”
Section 9.1.10, “UTF-8 for Metadata”

UTC_DATE

Section 11.6, “Date and Time Functions”

UTC_DATE()

Section 11.6, “Date and Time Functions”

UTC_TIME

Section 11.6, “Date and Time Functions”

UTC_TIME()

Section 11.6, “Date and Time Functions”

UTC_TIMESTAMP

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.6, “Date and Time Functions”

UTC_TIMESTAMP()

Section 11.6, “Date and Time Functions”
Section 9.7, “MySQL Server Time Zone Support”

UUID()

Section 16.1.3.4, “Binary Log Options and Variables”
Section 19.6, “Binary Logging of Stored Programs”
Section 7.5.5.1, “How the Query Cache Operates”
Section 11.11.4, “Miscellaneous Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 16.3.1, “Replication Features and Issues”
Section 16.3.1.10, “Replication and System Functions”
Section 5.2.4.2, “Setting The Binary Log Format”

UUID_SHORT()

Section 7.5.5.1, “How the Query Cache Operates”
Section 11.11.4, “Miscellaneous Functions”

Union(g1,g2)

Section 11.13.5.3.2, “Spatial Operators”

UpdateXML()

Section 1.4.1, “What Is New in MySQL 5.1”
Section 11.10, “XML Functions”

UpdateXML(xml_target, xpath_expr, new_xml)

Section 11.10, “XML Functions”

VALUES()

Section 12.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 11.11.4, “Miscellaneous Functions”

VALUES(col_name)

Section 12.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 11.11.4, “Miscellaneous Functions”

VARIANCE()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

VARIANCE(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

VAR_POP()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

VAR_POP(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

VAR_SAMP()

Section 11.12.1, “GROUP BY (Aggregate) Functions”

VAR_SAMP(expr)

Section 11.12.1, “GROUP BY (Aggregate) Functions”

VERSION()

Section B.1.5.1, “Case Sensitivity in String Searches”
Section 11.11.3, “Information Functions”
Section 16.3.1.10, “Replication and System Functions”
Section 9.1.6.5, “Special Cases Where Collation Determination Is Tricky”
Section 9.1.10, “UTF-8 for Metadata”

WEEK()

Section 11.6, “Date and Time Functions”
Section 5.1.4, “Server System Variables”

WEEK(date)

Section 11.6, “Date and Time Functions”

WEEK(date,0)

Section 11.6, “Date and Time Functions”

WEEK(date,3)

Section 11.6, “Date and Time Functions”

WEEK(date[,mode])

Section 11.6, “Date and Time Functions”

WEEKDAY()

Section 1.7.4, “MySQL Extensions to Standard SQL”
Section 18.2, “Partition Types”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

WEEKDAY(date)

Section 11.6, “Date and Time Functions”

WEEKOFYEAR()

Section 11.6, “Date and Time Functions”

WEEKOFYEAR(date)

Section 11.6, “Date and Time Functions”

WEIGHT_STRING()

Section B.1.5.1, “Case Sensitivity in String Searches”
Section 9.5, “How to Add a New Collation to a Character Set”
Section 11.4, “String Functions”
Section 9.1.12.1, “Unicode Character Sets”

WEIGHT_STRING(str [AS {CHAR|BINARY}(N)] [LEVEL levels] [flags])

Section 11.4, “String Functions”

WEIGHT_STRING(str1)

Section 11.4, “String Functions”

WEIGHT_STRING(str2)

Section 11.4, “String Functions”

Within()

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

Within(g1,g2)

Section 11.13.5.6, “Functions That Test Spatial Relationships Between Geometries”

X(p)

Section 11.13.5.2.2, “Point Functions”

Y(p)

Section 11.13.5.2.2, “Point Functions”

YEAR('1984-06-21')

Section 18.4, “Partition Pruning”

YEAR('1999-06-21')

Section 18.4, “Partition Pruning”

YEAR()

Section 3.3.4.5, “Date Calculations”
Section 18.4, “Partition Pruning”
Section 18.2, “Partition Types”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

YEAR(NULL)

Section 18.2.6, “How MySQL Partitioning Handles NULL

YEAR(date)

Section 11.6, “Date and Time Functions”

YEAR(date_col)

Section 18.2.3, “HASH Partitioning”

YEAR(dob)

Section 18.3.1, “Management of RANGE and LIST Partitions”

YEAR(separated)

Section 18.2.1, “RANGE Partitioning”

YEARWEEK()

Section 11.6, “Date and Time Functions”
Section 18.5.3, “Partitioning Limitations Relating to Functions”

YEARWEEK(date)

Section 11.6, “Date and Time Functions”

YEARWEEK(date,mode)

Section 11.6, “Date and Time Functions”

addslashes()

Section 5.3.1, “General Security Guidelines”

ascii

Section 9.1.7, “String Repertoire”
Section 2.10.2, “Typical configure Options”
Section 9.1.12.2, “West European Character Sets”

bin

Section 2.11.2, “Unix Post-Installation Procedures”

binary

Section 12.2.8, “SELECT Syntax”
Section 9.4, “Adding a New Character Set”
Section 21.10.1, “C API Data Types”
Section 21.10.5, “C API Prepared Statement Data types”
Section B.1.5.1, “Case Sensitivity in String Searches”
Section 9.1.4, “Connection Character Sets and Collations”
Description
Section 9.1.8.1, “Result Strings”
Section 5.1.4, “Server System Variables”
Section 9.1.6.4, “The _bin and binary Collations”
Section 2.10.2, “Typical configure Options”

case

Section 12.1.17, “CREATE TABLE Syntax”
Section 9.4, “Adding a New Character Set”

char

Section 21.10.5, “C API Prepared Statement Data types”
Section 13.9, “The MEMORY (HEAP) Storage Engine”

charset

Section 9.1.4, “Connection Character Sets and Collations”

collation

Section 9.4.1, “The Character Definition Arrays”

compress

Section 21.10.3.49, “mysql_options()
Section B.1.3.1, “Problems Linking to the MySQL Client Library”

count

Section 12.5.5.16, “SHOW ENGINE Syntax”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 5.1.8, “Server SQL Modes”

crypt()

Section 11.11.2, “Encryption and Compression Functions”
Section 5.1.4, “Server System Variables”

date

Section 11.6, “Date and Time Functions”

day

Section 21.10.5, “C API Prepared Statement Data types”

default

Section 17.3.4.1, “MySQL Cluster Configuration — Basic Example”
Section 5.1.6.1, “Structured System Variables”
Section 7.2.18, “Using optimizer_switch to Control the Optimizer”

expr IN (value,...)

Section 11.2.3, “Comparison Functions and Operators”

expr NOT IN (value,...)

Section 11.2.3, “Comparison Functions and Operators”

gethostbyaddr()

Section 7.5.11, “How MySQL Uses DNS”

gethostbyaddr_r()

Section 7.5.11, “How MySQL Uses DNS”

gethostbyname()

Section 7.5.11, “How MySQL Uses DNS”

gethostbyname_r()

Section 7.5.11, “How MySQL Uses DNS”

hour

Section 21.10.5, “C API Prepared Statement Data types”

insert

Section 7.5.6.3, “Delayed-Insert Thread States”

length

Section 21.10.3.34, “mysql_hex_string()
Section 21.10.3.53, “mysql_real_escape_string()
Section 21.10.3.54, “mysql_real_query()
Section 21.10.7.11, “mysql_stmt_fetch()
Section 21.10.7.20, “mysql_stmt_prepare()
Section 21.10.7.25, “mysql_stmt_send_long_data()
Section 21.10.5, “C API Prepared Statement Data types”
Section 22.2.3.3, “Creating a Plugin Library”
Section 22.2.3.2, “Type-Specific Plugin Structures and Functions”

ln

Section 2.9, “Installing MySQL from tar.gz Packages on Other Unix-Like Systems”

log

Section 2.10.3, “Installing from the Development Source Tree”

lower

Section 11.4.2, “Regular Expressions”
Section 9.4.1, “The Character Definition Arrays”

main()

Section 21.9, “libmysqld, the Embedded MySQL Server Library”

max

Section 13.6.2, “InnoDB Configuration”

minute

Section 21.10.5, “C API Prepared Statement Data types”

month

Section 21.10.5, “C API Prepared Statement Data types”

my_open()

Section 5.1.7, “Server Status Variables”

my_strxfrm_MYSET()

Section 9.4, “Adding a New Character Set”

mysql_add_word()

Section 22.2.3.2, “Type-Specific Plugin Structures and Functions”

mysql_bind_param()

Section 21.10.7, “C API Prepared Statement Function Descriptions”

mysql_bind_result()

Section 21.10.7, “C API Prepared Statement Function Descriptions”

mysql_escape_string()

Section 5.3.1, “General Security Guidelines”

mysql_execute()

Section 21.10.7, “C API Prepared Statement Function Descriptions”

mysql_fetch()

Section 21.10.7, “C API Prepared Statement Function Descriptions”

mysql_fetch_column()

Section 21.10.7, “C API Prepared Statement Function Descriptions”

mysql_get_metadata()

Section 21.10.7, “C API Prepared Statement Function Descriptions”

mysql_library_xxx()

Section 21.9, “libmysqld, the Embedded MySQL Server Library”

mysql_list_tables()

Section 21.10.3.44, “mysql_list_tables()

mysql_param_count()

Section 21.10.7, “C API Prepared Statement Function Descriptions”

mysql_param_result()

Section 21.10.7, “C API Prepared Statement Function Descriptions”

mysql_parse()

Section 22.2.3.2, “Type-Specific Plugin Structures and Functions”

mysql_prepare()

Section 21.10.7, “C API Prepared Statement Function Descriptions”

mysql_real_escape_string()

Section 5.3.1, “General Security Guidelines”

mysql_send_long_data()

Section 21.10.7, “C API Prepared Statement Function Descriptions”

mysql_shutdown(X)

Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

mysql_shutdown(X,SHUTDOWN_DEFAULT)

Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”

old-password

Description

or

Section 11.10, “XML Functions”

password

Description

power

Section 2.13.5.3, “IBM-AIX notes”

pthread_exit()

Section 21.9, “libmysqld, the Embedded MySQL Server Library”

quote

Section 5.3.1, “General Security Guidelines”
Section 8.1.1, “Strings”

second

Section 21.10.5, “C API Prepared Statement Data types”

setrlimit()

Section 5.1.2, “Server Command Options”

space

Section 13.6.13.2.2, “InnoDB Tablespace Monitor Output”
Section 11.4.2, “Regular Expressions”

thr_setconcurrency()

Section 5.1.4, “Server System Variables”

uncompress

Section B.1.3.1, “Problems Linking to the MySQL Client Library”

upper

Section 11.4.2, “Regular Expressions”
Section 9.4.1, “The Character Definition Arrays”

user

Section 12.5.1.2, “DROP USER Syntax”
Section B.1.2.15, “Ignoring user
Section 21.10.3.49, “mysql_options()
Section 21.10.3.52, “mysql_real_connect()
Section 5.4.4, “Access Control, Stage 1: Connection Verification”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 5.5.2, “Adding User Accounts”
Section 5.5.6.1, “Administrator Guidelines for Password Security”
Section 5.5.5, “Assigning Account Passwords”
Section 5.5.9, “Auditing MySQL Account Activity”
Section 5.4.7, “Causes of Access-Denied Errors”
Section 3.1, “Connecting to and Disconnecting from the Server”
Section 13.6.4.2, “Converting Tables from Other Storage Engines to InnoDB
Section 2.12.5, “Copying MySQL Databases to Another Machine”
Section 17.3.4.5, “Defining a MySQL Cluster Management Server”
Description
Section 11.11.2, “Encryption and Compression Functions”
Section 5.3.1, “General Security Guidelines”
Section 5.3.5, “How to Run MySQL as a Normal User”
Section 5.5.4, “Limiting Account Resources”
Section 5.3.2, “Making MySQL Secure Against Attackers”
Section 5.5.6.3, “Password Hashing in MySQL”
Section 5.4.2, “Privilege System Grant Tables”
Section 5.4.1, “Privileges Provided by MySQL”
Section D.6, “Restrictions on Character Sets”
Section 2.11.3, “Securing the Initial MySQL Accounts”
Section 5.1.2, “Server Command Options”
Section 5.4.3, “Specifying Account Names”
Section 2.11.2.2, “Starting and Stopping MySQL Automatically”
Section 2.11.2, “Unix Post-Installation Procedures”
Section 2.12.1.1, “Upgrading from MySQL 5.0 to 5.1”
Section 5.5.1, “User Names and Passwords”
Section 5.5.7.2, “Using SSL Connections”
Section 11.10, “XML Functions”

version

Description
Section 22.2.3.1, “General Plugin Structures and Functions”
Section 5.1.4, “Server System Variables”

year

Section 11.12.2, “GROUP BY Modifiers”
Section 21.10.5, “C API Prepared Statement Data types”