Function Index
   

Function Index

%

Section 1.8.4, “MySQL Extensions to Standard SQL”

ABS()

Section 12.7.3.1, “CREATE FUNCTION Синтаксис for User-Defined Functions”
Section 22.3, “Adding New Functions to MySQL”
Section 8.2.4, “Function Name Parsing and Resolution”
Section 17.5.3, “Partitioning Limitations Relating to Functions”

ABS(X)

Section 11.6.2, “Mathematical Functions”

ACOS(X)

Section 11.6.2, “Mathematical Functions”

ADDDATE()

Section 11.7, “Date and Time Functions”

ADDDATE(date,INTERVAL expr unit)

Section 11.7, “Date and Time Functions”

ADDDATE(expr,days)

Section 11.7, “Date and Time Functions”

ADDTIME()

Section 11.7, “Date and Time Functions”

ADDTIME(expr1,expr2)

Section 11.7, “Date and Time Functions”

AES_DECRYPT()

Section 11.13, “Encryption and Compression Functions”

AES_DECRYPT(crypt_str,key_str)

Section 11.13, “Encryption and Compression Functions”

AES_ENCRYPT()

Section 11.13, “Encryption and Compression Functions”
Section 11.2, “Type Conversion in Expression Evaluation”

AES_ENCRYPT(str,key_str)

Section 11.13, “Encryption and Compression Functions”

ASCII()

Section 12.8.3, “HELP Синтаксис”
Section 11.5, “String Functions”

ASCII(str)

Section 11.5, “String Functions”

ASIN(X)

Section 11.6.2, “Mathematical Functions”

ATAN(X)

Section 11.6.2, “Mathematical Functions”

ATAN(Y,X)

Section 11.6.2, “Mathematical Functions”

ATAN2(Y,X)

Section 11.6.2, “Mathematical Functions”

AVG()

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

AVG(DISTINCT)

Section 7.13.10.1, “Loose Index Scan”

AVG([DISTINCT] expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

Area()

Section 11.17.5.2, “Geometry Functions”

Area(mpoly)

Section 11.17.5.2.6, “MultiPolygon Functions”

Area(poly)

Section 11.17.5.2.5, “Polygon Functions”

AsBinary()

Section 11.17.4.5, “Fetching Spatial Data”

AsBinary(g)

Section 11.17.5.1, “Geometry Format Conversion Functions”

AsText()

Section 11.17.4.5, “Fetching Spatial Data”

AsText(g)

Section 11.17.5.1, “Geometry Format Conversion Functions”

AsWKB(g)

Section 11.17.5.1, “Geometry Format Conversion Functions”

AsWKT(g)

Section 11.17.5.1, “Geometry Format Conversion Functions”

BENCHMARK()

Section 7.9.3.1, “How the Query Cache Operates”
Section 11.14, “Information Functions”
Section 7.12.1, “Measuring the Speed of Expressions and Functions”
Section 7.2.1, “Optimizing SELECT Statements”
Section 12.2.10.10, “Optimizing Subqueries”
Section 12.2.10.8, “Subqueries in the FROM Clause”

BENCHMARK(10, (SELECT * FROM t))

Section 11.14, “Information Functions”

BENCHMARK(count,expr)

Section 11.14, “Information Functions”

BENCHMARK(loop_count,expression)

Section 7.12.1, “Measuring the Speed of Expressions and Functions”
Section 7.2.1, “Optimizing SELECT Statements”

BIN()

Section 8.1.6, “Bit-Field Literals”

BIN(N)

Section 11.5, “String Functions”

BIT_AND()

Section 1.8.4, “MySQL Extensions to Standard SQL”

BIT_AND(expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

BIT_COUNT()

Section 1.8.4, “MySQL Extensions to Standard SQL”

BIT_COUNT(N)

Section 11.12, “Bit Functions”

BIT_LENGTH(str)

Section 11.5, “String Functions”

BIT_OR()

Section 1.8.4, “MySQL Extensions to Standard SQL”

BIT_OR(expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

BIT_XOR()

Section 1.8.4, “MySQL Extensions to Standard SQL”

BIT_XOR(expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

BdMPolyFromText(wkt,srid)

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

BdMPolyFromWKB(wkb,srid)

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

BdPolyFromText(wkt,srid)

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

BdPolyFromWKB(wkb,srid)

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

Boundary(g)

Section 11.17.5.2.1, “General Geometry Functions”

Buffer(g,d)

Section 11.17.5.3.2, “Spatial Operators”

CAST()

Section 9.1.9.2, “CONVERT() and CAST()”
Section 8.1.6, “Bit-Field Literals”
Section 11.10, “Cast Functions and Operators”
Section 11.3.2, “Comparison Functions and Operators”
Section 10.3.5, “Conversion Between Date and Time Types”
Section 11.7, “Date and Time Functions”
Section 1.8.5, “MySQL Differences from Standard SQL”
Section 9.1.9.1, “Result Strings”
Section 11.2, “Type Conversion in Expression Evaluation”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”
Section 8.4, “User-Defined Variables”

CAST(... AS UNSIGNED)

Section 8.1.4, “Hexadecimal Literals”

CAST(... COLLATE ...)

Section 9.1.9.2, “CONVERT() and CAST()”

CAST(...) COLLATE ...

Section 9.1.9.2, “CONVERT() and CAST()”

CAST(expr AS CHAR)

Section 11.10, “Cast Functions and Operators”

CAST(expr AS type)

Section 11.10, “Cast Functions and Operators”

CAST(str AS BINARY)

Section 11.10, “Cast Functions and Operators”
Section 9.1.7.7, “The BINARY Operator”

CEIL()

Section 11.6.2, “Mathematical Functions”

CEIL(X)

Section 11.6.2, “Mathematical Functions”

CEILING()

Section 11.6.2, “Mathematical Functions”
Section 17.5.3, “Partitioning Limitations Relating to Functions”

CEILING(3.7004397181411)

Section 17.2.4.1, “LINEAR HASH Partitioning”

CEILING(X)

Section 11.6.2, “Mathematical Functions”

CHAR()

Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 9.1.9.1, “Result Strings”
Section 11.5, “String Functions”
Section 11.2, “Type Conversion in Expression Evaluation”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

CHAR(0)

Section 11.5, “String Functions”

CHAR(1,0)

Section 11.5, “String Functions”

CHAR(1,0,0)

Section 11.5, “String Functions”

CHAR(128 | key_num)

Section 11.13, “Encryption and Compression Functions”

CHAR(256)

Section 11.5, “String Functions”

CHAR(256*256)

Section 11.5, “String Functions”

CHAR(N)

Section 11.10, “Cast Functions and Operators”

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

Section 11.5, “String Functions”

CHARACTER_LENGTH()

Section 11.5, “String Functions”

CHARACTER_LENGTH(str)

Section 11.5, “String Functions”

CHARSET()

Section 9.1.9.1, “Result Strings”
Section 11.2, “Type Conversion in Expression Evaluation”

CHARSET(str)

Section 11.14, “Information Functions”

CHAR_LENGTH()

Section 11.5, “String Functions”

CHAR_LENGTH(str)

Section 11.5, “String Functions”

COALESCE(a.c1,b.c1)

Section 12.2.9.2, “JOIN Синтаксис”

COALESCE(value,...)

Section 11.3.2, “Comparison Functions and Operators”

COERCIBILITY()

Section 9.1.7.5, “Collation of Expressions”

COERCIBILITY(str)

Section 11.14, “Information Functions”

COLLATION()

Section C.5.5.1, “Case Sensitivity in String Searches”
Section 9.1.9.1, “Result Strings”
Section 11.2, “Type Conversion in Expression Evaluation”

COLLATION(str)

Section 11.14, “Information Functions”

COMPRESS()

Section 11.13, “Encryption and Compression Functions”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.3, “Server System Variables”
Section 11.2, “Type Conversion in Expression Evaluation”

COMPRESS(string_to_compress)

Section 11.13, “Encryption and Compression Functions”

CONCAT()

Section 12.7.3.1, “CREATE FUNCTION Синтаксис for User-Defined Functions”
Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section 12.7.5.14, “SHOW CREATE VIEW Синтаксис”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 9.1.9.1, “Result Strings”
Section 5.1.6, “Server SQL Modes”
Section 11.5, “String Functions”
Section 9.1.8, “String Repertoire”
Section 19.28, “The INFORMATION_SCHEMA VIEWS Table”
Section 11.2, “Type Conversion in Expression Evaluation”
Section 11.11, “XML Functions”

CONCAT(1, 'abc')

Section 9.1.7.5, “Collation of Expressions”
Section 11.2, “Type Conversion in Expression Evaluation”

CONCAT(str1,str2,...)

Section 11.5, “String Functions”

CONCAT_WS()

Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section 11.5, “String Functions”

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

Section 11.5, “String Functions”

CONNECTION_ID()

Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”
Section 11.14, “Information Functions”
Section 20.7.5.2, “The threads Table”

CONV()

Section 11.6.2, “Mathematical Functions”
Section 9.1.9.1, “Result Strings”

CONV(HEX(N),16,10)

Section 11.5, “String Functions”

CONV(N,10,16)

Section 11.5, “String Functions”

CONV(N,10,2)

Section 11.5, “String Functions”

CONV(N,10,8)

Section 11.6.2, “Mathematical Functions”
Section 11.5, “String Functions”

CONV(N,from_base,to_base)

Section 11.6.2, “Mathematical Functions”

CONVERT()

Section 9.1.9.2, “CONVERT() and CAST()”
Section 11.10, “Cast Functions and Operators”
Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 11.3.2, “Comparison Functions and Operators”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

CONVERT(... USING ...)

Section 9.1.9.2, “CONVERT() and CAST()”
Section 11.10, “Cast Functions and Operators”

CONVERT(expr USING transcoding_name)

Section 11.10, “Cast Functions and Operators”

CONVERT(expr,type)

Section 11.10, “Cast Functions and Operators”

CONVERT_TZ()

Section 11.7, “Date and Time Functions”
Section 7.9.3.1, “How the Query Cache Operates”
Section 12.3.5.3, “Table-Locking Restrictions and Conditions”

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

Section 15.4.1.28, “Replication and Time Zones”

CONVERT_TZ(dt,from_tz,to_tz)

Section 11.7, “Date and Time Functions”

COS(X)

Section 11.6.2, “Mathematical Functions”

COT(X)

Section 11.6.2, “Mathematical Functions”

COUNT()

Section 12.7.3.1, “CREATE FUNCTION Синтаксис for User-Defined Functions”
Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section 3.3.4.8, “Counting Rows”
Section 7.2.1.2, “How MySQL Optimizes WHERE Clauses”
Section 17.1, “Overview of Partitioning in MySQL”
Section C.5.5.3, “Problems with NULL Values”
Section 5.1.6, “Server SQL Modes”
Section 18.5.3, “Updatable and Insertable Views”
Section 18.5.2, “View Processing Algorithms”

COUNT(*)

Section 7.8.2, “EXPLAIN Output Format”
Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section 3.3.4.8, “Counting Rows”
Section 7.2.1.2, “How MySQL Optimizes WHERE Clauses”
Section C.5.5.3, “Problems with NULL Values”

COUNT(DISTINCT ...)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

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

Section 11.16.1, “GROUP BY (Aggregate) Functions”

COUNT(DISTINCT value_list)

Section 1.8.4, “MySQL Extensions to Standard SQL”

COUNT(DISTINCT)

Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section 7.13.10.1, “Loose Index Scan”

COUNT(expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

CRC32(expr)

Section 11.6.2, “Mathematical Functions”

CURDATE()

Section 3.3.4.5, “Date Calculations”
Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”

CURRENT_DATE

Section 12.1.17, “CREATE TABLE Синтаксис”
Section 10.1.4, “Data Type Default Values”
Section 11.7, “Date and Time Functions”

CURRENT_DATE()

Section 10.3.5, “Conversion Between Date and Time Types”
Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”

CURRENT_TIME

Section 11.7, “Date and Time Functions”

CURRENT_TIME()

Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”

CURRENT_TIME([fsp])

Section 11.7, “Date and Time Functions”

CURRENT_TIMESTAMP

Section 12.1.11, “CREATE EVENT Синтаксис”
Section 12.1.17, “CREATE TABLE Синтаксис”
Section 10.3.1.1, “TIMESTAMP Properties”
Section 10.1.4, “Data Type Default Values”
Section 11.7, “Date and Time Functions”

CURRENT_TIMESTAMP()

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”

CURRENT_TIMESTAMP([fsp])

Section 11.7, “Date and Time Functions”

CURRENT_USER

Section 12.1.11, “CREATE EVENT Синтаксис”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 12.1.19, “CREATE TRIGGER Синтаксис”
Section 12.1.20, “CREATE VIEW Синтаксис”
Section 18.6, “Access Control for Stored Programs and Views”
Section 11.14, “Information Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.11, “Replication and System Functions”
Section 5.4.3, “Specifying Account Names”

CURRENT_USER()

Section 12.1.11, “CREATE EVENT Синтаксис”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 12.1.19, “CREATE TRIGGER Синтаксис”
Section 12.1.20, “CREATE VIEW Синтаксис”
Section 12.7.1.6, “SET PASSWORD Синтаксис”
Section 5.4.4, “Access Control, Stage 1: Connection Verification”
Section 5.5.10, “Auditing MySQL Account Activity”
Section 22.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 11.14, “Information Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 5.5.7, “Proxy Users”
Section 15.4.1.11, “Replication and System Functions”
Section 5.4.3, “Specifying Account Names”
Section 9.1.12, “UTF-8 for Metadata”
Section 22.2.4.9.1, “Writing the Server-Side Authentication Plugin”

CURTIME()

Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 10.3.4, “Fractional Seconds in Time Values”
Section 7.9.3.1, “How the Query Cache Operates”
Section 9.6, “MySQL Server Time Zone Support”

CURTIME([fsp])

Section 11.7, “Date and Time Functions”

Centroid(mpoly)

Section 11.17.5.2.6, “MultiPolygon Functions”

Contains()

Section 11.17.5.4.2, “Functions That Test Spatial Relationships Between Geometries”
Section 1.4, “What Is New in MySQL 5.5”

Contains(g1,g2)

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

ConvexHull(g)

Section 11.17.5.3.2, “Spatial Operators”

Crosses(g1,g2)

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

DATABASE()

Section 12.1.21, “DROP DATABASE Синтаксис”
Section 3.3.1, “Creating and Selecting a Database”
Section 3.4, “Getting Information About Databases and Tables”
Section 7.9.3.1, “How the Query Cache Operates”
Section 11.14, “Information Functions”
Section C.5.8, “Known Issues in MySQL”
Section 9.1.12, “UTF-8 for Metadata”

DATE()

Section 11.7, “Date and Time Functions”

DATE(expr)

Section 11.7, “Date and Time Functions”

DATEDIFF()

Section 11.7, “Date and Time Functions”
Section 17.5.3, “Partitioning Limitations Relating to Functions”

DATEDIFF(expr1,expr2)

Section 11.7, “Date and Time Functions”

DATE_ADD()

Section 12.1.11, “CREATE EVENT Синтаксис”
Section 11.6.1, “Arithmetic Operators”
Section 3.3.4.5, “Date Calculations”
Section 11.7, “Date and Time Functions”
Section 10.3, “Date and Time Types”
Section 8.5, “Expression Синтаксис”

DATE_ADD(date,INTERVAL expr unit)

Section 11.7, “Date and Time Functions”

DATE_FORMAT()

Section 21.9.14, “C API Prepared Statement Problems”
Section 11.7, “Date and Time Functions”
Section 9.7, “MySQL Server Locale Support”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

DATE_FORMAT(date,format)

Section 11.7, “Date and Time Functions”

DATE_SUB()

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

DATE_SUB(date,INTERVAL expr unit)

Section 11.7, “Date and Time Functions”

DAY()

Section 11.7, “Date and Time Functions”
Section 17.5.3, “Partitioning Limitations Relating to Functions”

DAY(date)

Section 11.7, “Date and Time Functions”

DAYNAME()

Section 9.7, “MySQL Server Locale Support”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

DAYNAME(date)

Section 11.7, “Date and Time Functions”

DAYOFMONTH()

Section 3.3.4.5, “Date Calculations”
Section 11.7, “Date and Time Functions”
Section 17.5.3, “Partitioning Limitations Relating to Functions”

DAYOFMONTH(date)

Section 11.7, “Date and Time Functions”

DAYOFWEEK()

Section 17.5.3, “Partitioning Limitations Relating to Functions”

DAYOFWEEK(date)

Section 11.7, “Date and Time Functions”

DAYOFYEAR()

Section 11.7, “Date and Time Functions”
Section 17.5.3, “Partitioning Limitations Relating to Functions”
Section 17.2, “Partitioning Types”

DAYOFYEAR(date)

Section 11.7, “Date and Time Functions”

DECODE()

Section 11.13, “Encryption and Compression Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”

DECODE(crypt_str,pass_str)

Section 11.13, “Encryption and Compression Functions”

DEFAULT(col_name)

Section 12.2.5, “INSERT Синтаксис”
Section 12.2.8, “REPLACE Синтаксис”
Section 11.15, “Miscellaneous Functions”

DEFAULT(i)

Section 10.1.4, “Data Type Default Values”

DEGREES(X)

Section 11.6.2, “Mathematical Functions”

DES_DECRYPT()

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

DES_DECRYPT(crypt_str[,key_str])

Section 11.13, “Encryption and Compression Functions”

DES_ENCRYPT()

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

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

Section 11.13, “Encryption and Compression Functions”

Difference(g1,g2)

Section 11.17.5.3.2, “Spatial Operators”

Dimension(g)

Section 11.17.5.2.1, “General Geometry Functions”

Disjoint(g1,g2)

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

ELT()

Section C.5.8, “Known Issues in MySQL”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 9.1.9.1, “Result Strings”
Section 11.5, “String Functions”

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

Section 11.5, “String Functions”

ENCODE()

Section 11.13, “Encryption and Compression Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”

ENCODE(str,pass_str)

Section 11.13, “Encryption and Compression Functions”

ENCRYPT()

Section 11.13, “Encryption and Compression Functions”
Section 7.9.3.1, “How the Query Cache Operates”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section E.7, “Restrictions on Character Sets”
Section 5.1.3, “Server System Variables”
Section 5.5.1, “User Names and Passwords”

ENCRYPT(str[,salt])

Section 11.13, “Encryption and Compression Functions”

EXP()

Section 11.6.2, “Mathematical Functions”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

EXP(X)

Section 11.6.2, “Mathematical Functions”

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

Section 11.5, “String Functions”

EXTRACT()

Section 11.10, “Cast Functions and Operators”
Section 11.7, “Date and Time Functions”
Section 17.5.3, “Partitioning Limitations Relating to Functions”

EXTRACT(WEEK FROM col)

Section 17.5.3, “Partitioning Limitations Relating to Functions”

EXTRACT(unit FROM date)

Section 11.7, “Date and Time Functions”

EndPoint()

Section 11.17.5.2.3, “LineString Functions”
Section 11.17.5.2.4, “MultiLineString Functions”

EndPoint(ls)

Section 11.17.5.2.3, “LineString Functions”
Section 11.17.5.3.1, “Geometry Functions That Produce New Geometries”

Envelope(g)

Section 11.17.5.2.1, “General Geometry Functions”
Section 11.17.5.3.1, “Geometry Functions That Produce New Geometries”

Equals(g1,g2)

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

ExteriorRing(poly)

Section 11.17.5.2.5, “Polygon Functions”
Section 11.17.5.3.1, “Geometry Functions That Produce New Geometries”

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

Section 11.11, “XML Functions”

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

Section 11.11, “XML Functions”

ExtractValue()

Section 1.4, “What Is New in MySQL 5.5”
Section 11.11, “XML Functions”

ExtractValue(xml_frag, xpath_expr)

Section 11.11, “XML Functions”

FIELD()

Section 11.5, “String Functions”

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

Section 11.5, “String Functions”

FIND_IN_SET()

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

FIND_IN_SET(str,strlist)

Section 11.5, “String Functions”

FLOOR()

Section 11.6.1, “Arithmetic Operators”
Section 11.6.2, “Mathematical Functions”
Section 17.5.3, “Partitioning Limitations Relating to Functions”

FLOOR(X)

Section 11.6.2, “Mathematical Functions”

FLOOR(i RAND() * (j

Section 11.6.2, “Mathematical Functions”

FORMAT()

Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 9.7, “MySQL Server Locale Support”
Section 9.1.9.1, “Result Strings”

FORMAT(X,D)

Section 11.6.2, “Mathematical Functions”
Section 11.15, “Miscellaneous Functions”
Section 11.5, “String Functions”

FORMAT(X,D[,locale])

Section 11.5, “String Functions”

FOUND_ROWS()

Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”
Section 11.14, “Information Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.11, “Replication and System Functions”

FROM_BASE64()

Section 11.5, “String Functions”

FROM_BASE64(str)

Section 11.5, “String Functions”

FROM_DAYS()

Section 11.7, “Date and Time Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”

FROM_DAYS(N)

Section 11.7, “Date and Time Functions”

FROM_UNIXTIME()

Section 11.7, “Date and Time Functions”
Section 15.4.1.28, “Replication and Time Zones”

FROM_UNIXTIME(unix_timestamp)

Section 11.7, “Date and Time Functions”

FROM_UNIXTIME(unix_timestamp,format)

Section 11.7, “Date and Time Functions”

GET_FORMAT()

Section 11.7, “Date and Time Functions”
Section 9.7, “MySQL Server Locale Support”

GET_FORMAT(DATE,'EUR')

Section 11.7, “Date and Time Functions”

GET_FORMAT(DATE,'INTERNAL')

Section 11.7, “Date and Time Functions”

GET_FORMAT(DATE,'ISO')

Section 11.7, “Date and Time Functions”

GET_FORMAT(DATE,'JIS')

Section 11.7, “Date and Time Functions”

GET_FORMAT(DATE,'USA')

Section 11.7, “Date and Time Functions”

GET_FORMAT(DATETIME,'EUR')

Section 11.7, “Date and Time Functions”

GET_FORMAT(DATETIME,'INTERNAL')

Section 11.7, “Date and Time Functions”

GET_FORMAT(DATETIME,'ISO')

Section 11.7, “Date and Time Functions”

GET_FORMAT(DATETIME,'JIS')

Section 11.7, “Date and Time Functions”

GET_FORMAT(DATETIME,'USA')

Section 11.7, “Date and Time Functions”

GET_FORMAT(TIME,'EUR')

Section 11.7, “Date and Time Functions”

GET_FORMAT(TIME,'INTERNAL')

Section 11.7, “Date and Time Functions”

GET_FORMAT(TIME,'ISO')

Section 11.7, “Date and Time Functions”

GET_FORMAT(TIME,'JIS')

Section 11.7, “Date and Time Functions”

GET_FORMAT(TIME,'USA')

Section 11.7, “Date and Time Functions”

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

Section 11.7, “Date and Time Functions”

GET_LOCK()

Section 12.1.11, “CREATE EVENT Синтаксис”
Section 12.7.6.4, “KILL Синтаксис”
Section 21.9.3.3, “mysql_change_user()”
Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 21.9.12, “Controlling Automatic Reconnection Behavior”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 18.4.1, “Event Scheduler Overview”
Section 7.12.5.2, “General Thread States”
Section 7.9.3.1, “How the Query Cache Operates”
Section 7.10.1, “Internal Locking Methods”
Section 11.15, “Miscellaneous Functions”
Section 15.4.1.11, “Replication and System Functions”
Section 12.3.5.3, “Table-Locking Restrictions and Conditions”

GET_LOCK(str,timeout)

Section 11.15, “Miscellaneous Functions”

GLength()

Section 11.17.5.2.3, “LineString Functions”
Section 11.17.5.2.4, “MultiLineString Functions”
Section 11.17.7, “MySQL Conformance and Compatibility”

GLength(ls)

Section 11.17.5.2.3, “LineString Functions”

GLength(mls)

Section 11.17.5.2.4, “MultiLineString Functions”

GREATEST()

Section 11.3.2, “Comparison Functions and Operators”
Section 9.1.9.1, “Result Strings”

GREATEST(value1,value2,...)

Section 11.3.2, “Comparison Functions and Operators”

GREATEST(x,NULL)

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

GROUP_CONCAT()

Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section C.5.8, “Known Issues in MySQL”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 5.1.3, “Server System Variables”

GROUP_CONCAT(expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

GeomCollFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

GeomCollFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

GeomFromText()

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”
Section 11.17.4.4, “Populating Spatial Columns”

GeomFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”
Section 11.17.5.1, “Geometry Format Conversion Functions”

GeomFromWKB()

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

GeomFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”
Section 11.17.5.1, “Geometry Format Conversion Functions”

GeometryCollection(g1,g2,...)

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

GeometryCollectionFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

GeometryCollectionFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

GeometryFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

GeometryFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

GeometryN(gc,N)

Section 11.17.5.2.7, “GeometryCollection Functions”
Section 11.17.5.3.1, “Geometry Functions That Produce New Geometries”

GeometryType(g)

Section 11.17.5.2.1, “General Geometry Functions”

HEX()

Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 8.1.4, “Hexadecimal Literals”
Section 9.1.9.1, “Result Strings”
Section 11.5, “String Functions”

HEX(N)

Section 11.5, “String Functions”

HEX(N_or_S)

Section 11.6.2, “Mathematical Functions”

HEX(str)

Section 11.5, “String Functions”

HOUR()

Section 17.5.3, “Partitioning Limitations Relating to Functions”

HOUR(time)

Section 11.7, “Date and Time Functions”

IF()

Section 12.6.5.2, “IF Синтаксис”
Section 11.4, “Control Flow Functions”
Section C.5.8, “Known Issues in MySQL”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 9.1.9.1, “Result Strings”

IF(expr1,expr2,expr3)

Section 11.4, “Control Flow Functions”

IFNULL()

Section 11.4, “Control Flow Functions”
Section C.5.5.3, “Problems with NULL Values”

IFNULL(expr1,expr2)

Section 11.4, “Control Flow Functions”

IN

Section 11.3.1, “Operator Precedence”

IN()

Section 7.8.2, “EXPLAIN Output Format”
Section 7.13.1.1, “The Range Access Method for Single-Часть Indexes”
Section 11.2, “Type Conversion in Expression Evaluation”

IN(value_list)

Section E.4, “Restrictions on Subqueries”

INET6_ATON()

Section 11.15, “Miscellaneous Functions”

INET6_ATON(expr)

Section 11.15, “Miscellaneous Functions”

INET6_NTOA()

Section 11.15, “Miscellaneous Functions”

INET6_NTOA(expr)

Section 11.15, “Miscellaneous Functions”

INET_ATON()

Section 11.15, “Miscellaneous Functions”

INET_ATON(expr)

Section 11.15, “Miscellaneous Functions”

INET_NTOA()

Section 11.15, “Miscellaneous Functions”

INET_NTOA(expr)

Section 11.15, “Miscellaneous Functions”

INSERT(str,pos,len,newstr)

Section 11.5, “String Functions”

INSTR()

Section 9.1.9.1, “Result Strings”

INSTR(str,substr)

Section 11.5, “String Functions”

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

Section 11.3.2, “Comparison Functions and Operators”

ISNULL()

Section 11.3.2, “Comparison Functions and Operators”

ISNULL(expr)

Section 11.3.2, “Comparison Functions and Operators”

IS_FREE_LOCK()

Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 15.4.1.11, “Replication and System Functions”

IS_FREE_LOCK(str)

Section 11.15, “Miscellaneous Functions”

IS_IPV4()

Section 11.15, “Miscellaneous Functions”

IS_IPV4(expr)

Section 11.15, “Miscellaneous Functions”

IS_IPV4_COMPAT(expr)

Section 11.15, “Miscellaneous Functions”

IS_IPV4_MAPPED(expr)

Section 11.15, “Miscellaneous Functions”

IS_IPV6()

Section 11.15, “Miscellaneous Functions”

IS_IPV6(expr)

Section 11.15, “Miscellaneous Functions”

IS_USED_LOCK()

Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 15.4.1.11, “Replication and System Functions”

IS_USED_LOCK(str)

Section 11.15, “Miscellaneous Functions”

InteriorRingN(poly,N)

Section 11.17.5.2.5, “Polygon Functions”
Section 11.17.5.3.1, “Geometry Functions That Produce New Geometries”

Intersection(g1,g2)

Section 11.17.5.3.2, “Spatial Operators”

Intersects(g1,g2)

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

IsClosed(mls)

Section 11.17.5.2.4, “MultiLineString Functions”

IsEmpty()

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

IsEmpty(g)

Section 11.17.5.2.1, “General Geometry Functions”

IsRing(ls)

Section 11.17.5.2.3, “LineString Functions”

IsSimple()

Section 11.17.5.2.1, “General Geometry Functions”

IsSimple(g)

Section 11.17.5.2.1, “General Geometry Functions”

LAST_DAY()

Section 11.7, “Date and Time Functions”

LAST_DAY(date)

Section 11.7, “Date and Time Functions”

LAST_INSERT_ID()

Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 12.1.17, “CREATE TABLE Синтаксис”
Section 12.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Синтаксис”
Section 12.2.5.2, “INSERT DELAYED Синтаксис”
Section 12.2.5, “INSERT Синтаксис”
Section 21.9.3.37, “mysql_insert_id()”
Section 11.3.2, “Comparison Functions and Operators”
Section 21.9.12, “Controlling Automatic Reconnection Behavior”
Описание
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”
Section 21.9.11.3, “How to Get the Unique ID for the Last Inserted Row”
Section 11.14, “Information Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 15.4.1.1, “Replication and AUTO_INCREMENT”
Section 5.1.3, “Server System Variables”
Section 18.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()”
Section 12.3.5.3, “Table-Locking Restrictions and Conditions”
Section 1.8.5.3, “Transaction and Atomic Operation Differences”
Section 15.4.4, “Troubleshooting Replication”
Section 18.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 Синтаксис”
Section 21.9.3.37, “mysql_insert_id()”
Section 21.9.7.16, “mysql_stmt_insert_id()”
Section 11.14, “Information Functions”

LCASE()

Section 9.1.9.1, “Result Strings”
Section 11.5, “String Functions”

LCASE(str)

Section 11.5, “String Functions”

LEAST()

Section 11.3.2, “Comparison Functions and Operators”
Section 9.1.9.1, “Result Strings”

LEAST(value1,value2,...)

Section 11.3.2, “Comparison Functions and Operators”

LEAST(x,NULL)

Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

LEFT()

Section 11.10, “Cast Functions and Operators”

LEFT(str,len)

Section 11.5, “String Functions”

LENGTH()

Section 11.5, “String Functions”

LENGTH(str)

Section 11.5, “String Functions”

LN()

Section 11.6.2, “Mathematical Functions”

LN(X)

Section 11.6.2, “Mathematical Functions”

LOAD_FILE()

Section 12.2.7, “LOAD XML Синтаксис”
Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 5.4.1, “Privileges Provided by MySQL”
Section 15.4.1.11, “Replication and System Functions”
Section 5.3.4, “Security-Related mysqld Options”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”

LOAD_FILE(file_name)

Section 11.5, “String Functions”

LOCALTIME

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

LOCALTIME()

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”

LOCALTIME([fsp])

Section 11.7, “Date and Time Functions”

LOCALTIMESTAMP

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

LOCALTIMESTAMP()

Section 10.3.1.1, “TIMESTAMP Properties”
Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”

LOCALTIMESTAMP([fsp])

Section 11.7, “Date and Time Functions”

LOCATE()

Section 11.5, “String Functions”

LOCATE(substr,str)

Section 11.5, “String Functions”

LOCATE(substr,str,pos)

Section 11.5, “String Functions”

LOG()

Section 11.6.2, “Mathematical Functions”

LOG(10,X)

Section 11.6.2, “Mathematical Functions”

LOG(2,13)

Section 17.2.4.1, “LINEAR HASH Partitioning”

LOG(B,X)

Section 11.6.2, “Mathematical Functions”

LOG(X)

Section 11.6.2, “Mathematical Functions”

LOG(X) / LOG(2)

Section 11.6.2, “Mathematical Functions”

LOG(X) / LOG(B)

Section 11.6.2, “Mathematical Functions”

LOG10(X)

Section 11.6.2, “Mathematical Functions”

LOG2()

Section 11.6.2, “Mathematical Functions”

LOG2(X)

Section 11.6.2, “Mathematical Functions”

LOWER()

Глава 19, INFORMATION_SCHEMA Tables
Section 11.10, “Cast Functions and Operators”
Section 9.1.7.9, “Collation and INFORMATION_SCHEMA Searches”
Section 9.1.9.1, “Result Strings”
Section 11.5, “String Functions”
Section 9.1.14.1, “Unicode Character Sets”

LOWER(str)

Section 11.5, “String Functions”

LPAD(str,len,padstr)

Section 11.5, “String Functions”

LTRIM()

Section 9.1.9.1, “Result Strings”

LTRIM(str)

Section 11.5, “String Functions”

Length()

Section 11.17.5.2.3, “LineString Functions”
Section 11.17.5.2.4, “MultiLineString Functions”
Section 11.17.7, “MySQL Conformance and Compatibility”

LineFromText()

Section 11.17.5.1, “Geometry Format Conversion Functions”

LineFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

LineFromWKB()

Section 11.17.5.1, “Geometry Format Conversion Functions”

LineFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

LineString(pt1,pt2,...)

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

LineStringFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

LineStringFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

MAKEDATE(year,dayofyear)

Section 11.7, “Date and Time Functions”

MAKETIME(hour,minute,second)

Section 11.7, “Date and Time Functions”

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

Section 11.5, “String Functions”

MASTER_POS_WAIT()

Section 12.4.2.2, “MASTER_POS_WAIT() Синтаксис”
Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”
Section 11.15, “Miscellaneous Functions”

MASTER_POS_WAIT(log_name,log_pos[,timeout])

Section 11.15, “Miscellaneous Functions”

MATCH

Section 8.5, “Expression Синтаксис”

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

Section 11.9, “Full-Text Search Functions”

MATCH()

Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 11.9.5, “Full-Text Restrictions”
Section 11.9, “Full-Text Search Functions”
Section 11.9.1, “Natural Language Full-Text Searches”

MATCH() ... AGAINST

Section 11.9, “Full-Text Search Functions”

MATCH() ... AGAINST()

Section 11.9.2, “Boolean Full-Text Searches”

MAX()

Section 7.8.2, “EXPLAIN Output Format”
Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section 11.16.3, “GROUP BY and HAVING with Hidden Columns”
Section 7.3.1, “How MySQL Uses Indexes”
Section C.5.8, “Known Issues in MySQL”
Section 7.13.10.1, “Loose Index Scan”
Section 12.2.10.10, “Optimizing Subqueries”
Section 10.3.6, “Two-Digit Years in Dates”
Section 18.5.3, “Updatable and Insertable Views”
Section 18.5.2, “View Processing Algorithms”

MAX(TP_THREAD_NUMBER)

Section 19.30.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”

MAX([DISTINCT] expr)

Section 11.16.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, “Numeric Type Overview”

MAX(t1.b)

Section 5.1.6, “Server SQL Modes”

MBRContains()

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

MBRContains(g1,g2)

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

MBRDisjoint(g1,g2)

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

MBREqual(g1,g2)

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

MBRIntersects(g1,g2)

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

MBROverlaps(g1,g2)

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

MBRTouches(g1,g2)

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

MBRWithin()

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

MBRWithin(g1,g2)

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

MD5()

Section 17.2.5, “KEY Partitioning”
Section 11.13, “Encryption and Compression Functions”
Section 5.3.1, “General Security Guidelines”
Section 5.3.2.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 8.2, “Schema Object Names”
Section 11.2, “Type Conversion in Expression Evaluation”

MD5(str)

Section 11.13, “Encryption and Compression Functions”

MICROSECOND()

Section 17.5.3, “Partitioning Limitations Relating to Functions”

MICROSECOND(expr)

Section 11.7, “Date and Time Functions”

MID()

Section 9.1.9.1, “Result Strings”

MID(str,pos,len)

Section 11.5, “String Functions”

MIN()

Section 7.8.2, “EXPLAIN Output Format”
Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section 11.16.3, “GROUP BY and HAVING with Hidden Columns”
Section 7.2.1.2, “How MySQL Optimizes WHERE Clauses”
Section 7.3.1, “How MySQL Uses Indexes”
Section C.5.8, “Known Issues in MySQL”
Section 7.13.10.1, “Loose Index Scan”
Section 12.2.10.10, “Optimizing Subqueries”
Section C.5.5.3, “Problems with NULL Values”
Section 10.3.6, “Two-Digit Years in Dates”
Section 18.5.3, “Updatable and Insertable Views”
Section 18.5.2, “View Processing Algorithms”

MIN([DISTINCT] expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

MIN(col_name)

Section 10.1.1, “Numeric Type Overview”

MIN(number-with-zerofill)

Section 21.9.14, “C API Prepared Statement Problems”

MINUTE()

Section 17.5.3, “Partitioning Limitations Relating to Functions”

MINUTE(time)

Section 11.7, “Date and Time Functions”

MLineFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

MLineFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

MOD()

Section 11.6.1, “Arithmetic Operators”
Section 3.3.4.5, “Date Calculations”
Section 11.6.2, “Mathematical Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 17.5.3, “Partitioning Limitations Relating to Functions”

MOD(N,0)

Section 11.6.2, “Mathematical Functions”

MOD(N,M)

Section 11.6.2, “Mathematical Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”

MOD(X,0)

Section 5.1.6, “Server SQL Modes”

MOD(something,12)

Section 3.3.4.5, “Date Calculations”

MONTH()

Section 3.3.4.5, “Date Calculations”
Section 17.5.3, “Partitioning Limitations Relating to Functions”
Section 17.2, “Partitioning Types”

MONTH(birth)

Section 3.3.4.5, “Date Calculations”

MONTH(date)

Section 11.7, “Date and Time Functions”

MONTHNAME()

Section 9.7, “MySQL Server Locale Support”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

MONTHNAME(date)

Section 11.7, “Date and Time Functions”

MPointFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

MPointFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

MPolyFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

MPolyFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

MultiLineString(ls1,ls2,...)

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

MultiLineStringFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

MultiLineStringFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

MultiPoint(pt1,pt2,...)

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

MultiPointFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

MultiPointFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

MultiPolygon(poly1,poly2,...)

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

MultiPolygonFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

MultiPolygonFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

NAME_CONST()

Section 18.7, “Binary Logging of Stored Programs”
Section 11.15, “Miscellaneous Functions”

NAME_CONST(name,value)

Section 11.15, “Miscellaneous Functions”

NOW()

Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 12.1.17, “CREATE TABLE Синтаксис”
Section 10.3.1.1, “TIMESTAMP Properties”
Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 10.1.4, “Data Type Default Values”
Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”
Section 9.6, “MySQL Server Time Zone Support”
Section 15.4.1.11, “Replication and System Functions”
Section 15.4.1.28, “Replication and Time Zones”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 10.3.3, “The YEAR Type”
Section 9.6.2, “Time Zone Leap Second Support”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

NOW([fsp])

Section 11.7, “Date and Time Functions”

NULLIF(expr1,expr2)

Section 11.4, “Control Flow Functions”

NumGeometries(gc)

Section 11.17.5.2.7, “GeometryCollection Functions”

NumInteriorRings(poly)

Section 11.17.5.2.5, “Polygon Functions”

NumPoints(ls)

Section 11.17.5.2.3, “LineString Functions”

OCT(N)

Section 11.6.2, “Mathematical Functions”
Section 11.5, “String Functions”

OCTET_LENGTH()

Section 11.5, “String Functions”

OCTET_LENGTH(str)

Section 11.5, “String Functions”

OLD_PASSWORD()

Section C.5.2.4, “Client does not support authentication protocol”
Section 12.7.1.6, “SET PASSWORD Синтаксис”
Section 11.13, “Encryption and Compression Functions”
Section 5.3.2.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 5.3.2.3, “Password Hashing in MySQL”

OLD_PASSWORD(str)

Section 11.13, “Encryption and Compression Functions”

ORD()

Section 11.5, “String Functions”

ORD(str)

Section 11.5, “String Functions”

Overlaps(g1,g2)

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

PASSWORD()

Section 12.7.1.1, “CREATE USER Синтаксис”
Section C.5.2.15, “Ignoring user”
Section 17.2.5, “KEY Partitioning”
Section 12.7.1.6, “SET PASSWORD Синтаксис”
Section 5.4.4, “Access Control, Stage 1: Connection Verification”
Section 5.5.2, “Adding User Accounts”
Section 5.3.2.1, “Administrator Guidelines for Password Security”
Section 5.5.5, “Assigning Account Passwords”
Section 5.4.7, “Causes of Access-Denied Ошибки”
Section 11.13, “Encryption and Compression Functions”
Section 5.3.2.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 5.3.2.3, “Password Hashing in MySQL”
Section 2.10.2, “Securing the Initial MySQL Accounts”
Section 11.2, “Type Conversion in Expression Evaluation”
Section 5.5.1, “User Names and Passwords”

PASSWORD(str)

Section 11.13, “Encryption and Compression Functions”

PERIOD_ADD()

Section 1.8.4, “MySQL Extensions to Standard SQL”

PERIOD_ADD(P,N)

Section 11.7, “Date and Time Functions”

PERIOD_DIFF()

Section 1.8.4, “MySQL Extensions to Standard SQL”

PERIOD_DIFF(P1,P2)

Section 11.7, “Date and Time Functions”

PI()

Section 8.2.4, “Function Name Parsing and Resolution”
Section 11.6.2, “Mathematical Functions”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

POINT()

Section 11.17.3.1, “Well-Known Text (WKT) Format”

POSITION(substr IN str)

Section 11.5, “String Functions”

POW()

Section 11.6.2, “Mathematical Functions”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

POW(5-int_col,3) + 6

Section 17.2.4, “HASH Partitioning”

POW(X,Y)

Section 11.6.2, “Mathematical Functions”

POWER(2,4)

Section 17.2.4.1, “LINEAR HASH Partitioning”

POWER(X,Y)

Section 11.6.2, “Mathematical Functions”

Point()

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

Point(x,y)

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

PointFromText()

Section 11.17.5.1, “Geometry Format Conversion Functions”

PointFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

PointFromWKB()

Section 11.17.5.1, “Geometry Format Conversion Functions”

PointFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

PointN(ls,N)

Section 11.17.5.2.3, “LineString Functions”
Section 11.17.5.3.1, “Geometry Functions That Produce New Geometries”

PolyFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

PolyFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

Polygon(ls1,ls2,...)

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

PolygonFromText(wkt[,srid])

Section 11.17.4.2.1, “Creating Geometry Values Using WKT Functions”

PolygonFromWKB(wkb[,srid])

Section 11.17.4.2.2, “Creating Geometry Values Using WKB Functions”

QUARTER()

Section 17.5.3, “Partitioning Limitations Relating to Functions”

QUARTER(date)

Section 11.7, “Date and Time Functions”

QUOTE()

Section 21.9.3.53, “mysql_real_escape_string()”
Section 8.1.1, “String Literals”

QUOTE(str)

Section 11.5, “String Functions”

RADIANS(X)

Section 11.6.2, “Mathematical Functions”

RAND()

Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 12.1.15, “CREATE PROCEDURE and CREATE FUNCTION Синтаксис”
Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Описание
Section 7.9.3.1, “How the Query Cache Operates”
Section 11.6.2, “Mathematical Functions”
Section 15.4.1.11, “Replication and System Functions”
Section 5.1.3, “Server System Variables”

RAND(N)

Section 11.6.2, “Mathematical Functions”

RELEASE_LOCK()

Section 12.2.3, “DO Синтаксис”
Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”
Section 7.10.1, “Internal Locking Methods”
Section 11.15, “Miscellaneous Functions”
Section 15.4.1.11, “Replication and System Functions”
Section 12.3.5.3, “Table-Locking Restrictions and Conditions”

RELEASE_LOCK(str)

Section 11.15, “Miscellaneous Functions”

REPEAT()

Section 9.1.9.1, “Result Strings”

REPEAT(str,count)

Section 11.5, “String Functions”

REPLACE()

Section 9.1.9.1, “Result Strings”
Section 11.5, “String Functions”

REPLACE(str,from_str,to_str)

Section 11.5, “String Functions”

REVERSE()

Section 9.1.9.1, “Result Strings”

REVERSE(str)

Section 11.5, “String Functions”

RIGHT()

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

RIGHT(str,len)

Section 11.5, “String Functions”

ROUND()

Section 11.6.2, “Mathematical Functions”
Section 11.18, “Precision Math”
Section 11.18.5, “Precision Math Examples”
Section C.5.5.8, “Problems with Floating-Point Values”
Section 11.18.4, “Rounding Behavior”

ROUND(X)

Section 11.6.2, “Mathematical Functions”

ROUND(X,D)

Section 11.6.2, “Mathematical Functions”

ROW_COUNT()

Section 12.2.1, “CALL Синтаксис”
Section 12.2.2, “DELETE Синтаксис”
Section 12.2.5, “INSERT Синтаксис”
Section 21.9.3.1, “mysql_affected_rows()”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 11.14, “Information Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.11, “Replication and System Functions”

RPAD()

Section 9.1.9.1, “Result Strings”

RPAD(str,len,padstr)

Section 11.5, “String Functions”

RTRIM()

Section 9.1.9.1, “Result Strings”

RTRIM(str)

Section 11.5, “String Functions”

SCHEMA()

Section 11.14, “Information Functions”

SECOND()

Section 17.5.3, “Partitioning Limitations Relating to Functions”

SECOND(time)

Section 11.7, “Date and Time Functions”

SEC_TO_TIME(seconds)

Section 11.7, “Date and Time Functions”

SESSION_USER()

Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 11.14, “Information Functions”
Section 9.1.12, “UTF-8 for Metadata”

SHA()

Section 11.13, “Encryption and Compression Functions”

SHA(str)

Section 11.13, “Encryption and Compression Functions”

SHA1()

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

SHA1(str)

Section 11.13, “Encryption and Compression Functions”

SHA2()

Section 11.13, “Encryption and Compression Functions”
Section 5.3.1, “General Security Guidelines”

SHA2(str, hash_length)

Section 11.13, “Encryption and Compression Functions”

SIGN(X)

Section 11.6.2, “Mathematical Functions”

SIN(3.14)

Section 22.3.2.3, “UDF Argument Processing”

SIN(X)

Section 11.6.2, “Mathematical Functions”

SLEEP()

Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.12.5.2, “General Thread States”
Section 7.9.3.1, “How the Query Cache Operates”
Section 11.15, “Miscellaneous Functions”
Section 15.4.1, “Replication Features and Issues”
Section 19.30.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”

SLEEP(duration)

Section 11.15, “Miscellaneous Functions”

SOUNDEX()

Section 22.3, “Adding New Functions to MySQL”
Section 9.1.9.1, “Result Strings”
Section 11.5, “String Functions”

SOUNDEX(expr1) = SOUNDEX(expr2)

Section 11.5, “String Functions”

SOUNDEX(str)

Section 11.5, “String Functions”

SPACE()

Section 9.1.9.1, “Result Strings”

SPACE(N)

Section 11.5, “String Functions”

SQRT(X)

Section 11.6.2, “Mathematical Functions”

SRID(g)

Section 11.17.5.2.1, “General Geometry Functions”

STD()

Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”

STD(expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

STDDEV()

Section 11.16.1, “GROUP BY (Aggregate) Functions”

STDDEV(expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

STDDEV_POP()

Section 11.16.1, “GROUP BY (Aggregate) Functions”

STDDEV_POP(expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

STDDEV_SAMP()

Section 11.16.1, “GROUP BY (Aggregate) Functions”

STDDEV_SAMP(expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

STRCMP()

Section C.5.5.2, “Problems Using DATE Columns”
Section 11.5.1, “String Comparison Functions”

STRCMP(expr1,expr2)

Section 11.5.1, “String Comparison Functions”

STR_TO_DATE()

Section 11.7, “Date and Time Functions”
Section 9.7, “MySQL Server Locale Support”

STR_TO_DATE(str,format)

Section 11.7, “Date and Time Functions”

ST_Contains()

Section 11.17.5.4.2, “Functions That Test Spatial Relationships Between Geometries”
Section 1.4, “What Is New in MySQL 5.5”

ST_Contains(g1,g2)

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

ST_Crosses(g1,g2)

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

ST_Disjoint(g1,g2)

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

ST_Equals(g1,g2)

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

ST_Intersects(g1,g2)

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

ST_Overlaps(g1,g2)

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

ST_Touches(g1,g2)

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

ST_Within()

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

ST_Within(g1,g2)

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

SUBDATE()

Section 11.7, “Date and Time Functions”

SUBDATE(date,INTERVAL expr unit)

Section 11.7, “Date and Time Functions”

SUBDATE(expr,days)

Section 11.7, “Date and Time Functions”

SUBSTR()

Section 11.5, “String Functions”

SUBSTR(str FROM pos FOR len)

Section 11.5, “String Functions”

SUBSTR(str FROM pos)

Section 11.5, “String Functions”

SUBSTR(str,pos)

Section 11.5, “String Functions”

SUBSTR(str,pos,len)

Section 11.5, “String Functions”

SUBSTRING()

Section 5.5.10, “Auditing MySQL Account Activity”
Section 9.1.9.1, “Result Strings”
Section 11.5, “String Functions”
Section 10.4.3, “The BLOB and TEXT Types”

SUBSTRING(str FROM pos FOR len)

Section 11.5, “String Functions”

SUBSTRING(str FROM pos)

Section 11.5, “String Functions”

SUBSTRING(str,pos)

Section 11.5, “String Functions”

SUBSTRING(str,pos,len)

Section 11.5, “String Functions”

SUBSTRING_INDEX()

Section 11.5, “String Functions”

SUBSTRING_INDEX(str,delim,count)

Section 11.5, “String Functions”

SUBTIME()

Section 11.7, “Date and Time Functions”

SUBTIME(expr1,expr2)

Section 11.7, “Date and Time Functions”

SUM()

Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section 22.3.2, “Adding a New User-Defined Function”
Section 10.1.2, “Date and Time Type Overview”
Section 17.1, “Overview of Partitioning in MySQL”
Section C.5.5.3, “Problems with NULL Values”
Section 10.4.4, “The ENUM Type”
Section 10.4.5, “The SET Type”
Section 18.5.3, “Updatable and Insertable Views”
Section 18.5.2, “View Processing Algorithms”

SUM(DISTINCT)

Section 7.13.10.1, “Loose Index Scan”

SUM([DISTINCT] expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

SYSDATE()

Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 10.3.4, “Fractional Seconds in Time Values”
Section 7.9.3.1, “How the Query Cache Operates”
Section 15.4.1.11, “Replication and System Functions”
Section 5.1.2, “Server Command Options”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 5.1 to 5.5”

SYSTEM_USER()

Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 11.14, “Information Functions”
Section 9.1.12, “UTF-8 for Metadata”

StartPoint()

Section 11.17.5.2.3, “LineString Functions”
Section 11.17.5.2.4, “MultiLineString Functions”

StartPoint(ls)

Section 11.17.5.2.3, “LineString Functions”
Section 11.17.5.3.1, “Geometry Functions That Produce New Geometries”

SymDifference(g1,g2)

Section 11.17.5.3.2, “Spatial Operators”

TAN(X)

Section 11.6.2, “Mathematical Functions”

TIME(expr)

Section 11.7, “Date and Time Functions”

TIMEDIFF()

Section 11.7, “Date and Time Functions”

TIMEDIFF(expr1,expr2)

Section 11.7, “Date and Time Functions”

TIMESTAMP()

Section 11.7, “Date and Time Functions”

TIMESTAMP(expr)

Section 11.7, “Date and Time Functions”

TIMESTAMP(expr1,expr2)

Section 11.7, “Date and Time Functions”

TIMESTAMPADD()

Section 11.7, “Date and Time Functions”
Section 1.4, “What Is New in MySQL 5.5”

TIMESTAMPADD(unit,interval,datetime_expr)

Section 11.7, “Date and Time Functions”

TIMESTAMPDIFF()

Section 11.7, “Date and Time Functions”

TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)

Section 11.7, “Date and Time Functions”

TIME_FORMAT(time,format)

Section 11.7, “Date and Time Functions”

TIME_TO_SEC()

Section 17.5.3, “Partitioning Limitations Relating to Functions”

TIME_TO_SEC(time)

Section 11.7, “Date and Time Functions”

TO_BASE64()

Section 11.5, “String Functions”

TO_BASE64(str)

Section 11.5, “String Functions”

TO_DAYS()

Section 11.7, “Date and Time Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 17.4, “Partition Pruning”
Section 17.5.3, “Partitioning Limitations Relating to Functions”
Section 17.2, “Partitioning Types”

TO_DAYS(date)

Section 11.7, “Date and Time Functions”

TO_DAYS(date_col)

Section 17.2.4, “HASH Partitioning”

TO_SECONDS()

Section 11.7, “Date and Time Functions”
Section 17.4, “Partition Pruning”
Section 17.5.3, “Partitioning Limitations Relating to Functions”
Section 17.2, “Partitioning Types”
Section 1.4, “What Is New in MySQL 5.5”

TO_SECONDS(expr)

Section 11.7, “Date and Time Functions”

TRIM()

Section 9.1.13, “Column Character Set Conversion”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 9.1.9.1, “Result Strings”

TRIM([remstr FROM] str)

Section 11.5, “String Functions”

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

Section 11.5, “String Functions”

TRUNCATE()

Section 11.6.2, “Mathematical Functions”

TRUNCATE(X,D)

Section 11.6.2, “Mathematical Functions”

Touches(g1,g2)

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

UCASE()

Section 9.1.9.1, “Result Strings”
Section 11.5, “String Functions”

UCASE(str)

Section 11.5, “String Functions”

UNCOMPRESS()

Section 11.13, “Encryption and Compression Functions”
Section 2.9.4, “MySQL Source-Configuration Options”
Section 5.1.3, “Server System Variables”

UNCOMPRESS(string_to_uncompress)

Section 11.13, “Encryption and Compression Functions”

UNCOMPRESSED_LENGTH(compressed_string)

Section 11.13, “Encryption and Compression Functions”

UNHEX()

Section 11.13, “Encryption and Compression Functions”
Section 11.5, “String Functions”

UNHEX(str)

Section 11.5, “String Functions”

UNIX_TIMESTAMP()

Section 17.2.1, “RANGE Partitioning”
Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”
Section 17.5.3, “Partitioning Limitations Relating to Functions”
Section C.5.4.6, “Time Zone Problems”

UNIX_TIMESTAMP(date)

Section 11.7, “Date and Time Functions”

UNIX_TIMESTAMP(timestamp_column)

Section 17.2.1, “RANGE Partitioning”

UPPER()

Глава 19, INFORMATION_SCHEMA Tables
Section 11.10, “Cast Functions and Operators”
Section 9.1.7.9, “Collation and INFORMATION_SCHEMA Searches”
Section 9.1.9.1, “Result Strings”
Section 11.5, “String Functions”
Section 9.1.14.1, “Unicode Character Sets”

UPPER(X)

Section 9.1.9.1, “Result Strings”

UPPER(_utf8'abc')

Section 9.1.8, “String Repertoire”

UPPER(str)

Section 11.5, “String Functions”

USER()

Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 5.5.10, “Auditing MySQL Account Activity”
Section 9.1.7.5, “Collation of Expressions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”
Section 22.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 11.14, “Information Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 5.5.7, “Proxy Users”
Section 15.4.1.11, “Replication and System Functions”
Section 9.1.12, “UTF-8 for Metadata”
Section 22.2.4.9.1, “Writing the Server-Side Authentication Plugin”

UTC_DATE

Section 11.7, “Date and Time Functions”

UTC_DATE()

Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”

UTC_TIME

Section 11.7, “Date and Time Functions”

UTC_TIME()

Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”

UTC_TIME([fsp])

Section 11.7, “Date and Time Functions”

UTC_TIMESTAMP

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

UTC_TIMESTAMP()

Section 11.7, “Date and Time Functions”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 10.3.4, “Fractional Seconds in Time Values”
Section 9.6, “MySQL Server Time Zone Support”

UTC_TIMESTAMP([fsp])

Section 11.7, “Date and Time Functions”

UUID()

Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.1.3.4, “Binary Log Options and Variables”
Section 18.7, “Binary Logging of Stored Programs”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”
Section 11.15, “Miscellaneous Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 15.4.1.11, “Replication and System Functions”
Section 5.2.4.2, “Setting The Binary Log Format”

UUID_SHORT()

Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.9.3.1, “How the Query Cache Operates”
Section 11.15, “Miscellaneous Functions”

Union(g1,g2)

Section 11.17.5.3.2, “Spatial Operators”

UpdateXML()

Section 1.4, “What Is New in MySQL 5.5”
Section 11.11, “XML Functions”

UpdateXML(xml_target, xpath_expr, new_xml)

Section 11.11, “XML Functions”

VALUES()

Section 12.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Синтаксис”
Section 11.15, “Miscellaneous Functions”

VALUES(col_name)

Section 12.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Синтаксис”
Section 11.15, “Miscellaneous Functions”

VARIANCE()

Section 11.16.1, “GROUP BY (Aggregate) Functions”

VARIANCE(expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

VAR_POP()

Section 11.16.1, “GROUP BY (Aggregate) Functions”

VAR_POP(expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

VAR_SAMP()

Section 11.16.1, “GROUP BY (Aggregate) Functions”

VAR_SAMP(expr)

Section 11.16.1, “GROUP BY (Aggregate) Functions”

VERSION()

Section 15.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section C.5.5.1, “Case Sensitivity in String Searches”
Section 9.1.7.5, “Collation of Expressions”
Section 11.14, “Information Functions”
Section 15.4.1.11, “Replication and System Functions”
Section 9.1.12, “UTF-8 for Metadata”

WEEK()

Section 11.7, “Date and Time Functions”
Section 5.1.3, “Server System Variables”

WEEK(date,3)

Section 11.7, “Date and Time Functions”

WEEK(date[,mode])

Section 11.7, “Date and Time Functions”

WEEKDAY()

Section 11.7, “Date and Time Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 17.5.3, “Partitioning Limitations Relating to Functions”
Section 17.2, “Partitioning Types”

WEEKDAY(date)

Section 11.7, “Date and Time Functions”

WEEKOFYEAR()

Section 11.7, “Date and Time Functions”

WEEKOFYEAR(date)

Section 11.7, “Date and Time Functions”

WEIGHT_STRING()

Section 9.4, “Adding a Collation to a Character Set”
Section C.5.5.1, “Case Sensitivity in String Searches”
Section 11.5, “String Functions”
Section 9.1.14.1, “Unicode Character Sets”

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

Section 11.5, “String Functions”

WEIGHT_STRING(str1)

Section 11.5, “String Functions”

WEIGHT_STRING(str2)

Section 11.5, “String Functions”

Within()

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

Within(g1,g2)

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

X(p)

Section 11.17.5.2.2, “Point Functions”

Y(p)

Section 11.17.5.2.2, “Point Functions”

YEAR('1984-06-21')

Section 17.4, “Partition Pruning”

YEAR('1999-06-21')

Section 17.4, “Partition Pruning”

YEAR()

Section 3.3.4.5, “Date Calculations”
Section 17.4, “Partition Pruning”
Section 17.5.3, “Partitioning Limitations Relating to Functions”
Section 17.2, “Partitioning Types”

YEAR(NULL)

Section 17.2.7, “How MySQL Partitioning Handles NULL”

YEAR(date)

Section 11.7, “Date and Time Functions”

YEAR(date_col)

Section 17.2.4, “HASH Partitioning”

YEAR(dob)

Section 17.3.1, “Management of RANGE and LIST Partitions”

YEAR(separated)

Section 17.2.1, “RANGE Partitioning”

YEARWEEK()

Section 11.7, “Date and Time Functions”
Section 17.5.3, “Partitioning Limitations Relating to Functions”

YEARWEEK(date)

Section 11.7, “Date and Time Functions”

YEARWEEK(date,mode)

Section 11.7, “Date and Time Functions”

addslashes()

Section 5.3.1, “General Security Guidelines”

crypt()

Section 11.13, “Encryption and Compression Functions”
Section 5.1.3, “Server System Variables”

expr IN (value,...)

Section 11.3.2, “Comparison Functions and Operators”

expr NOT IN (value,...)

Section 11.3.2, “Comparison Functions and Operators”

gethostbyaddr()

Section 7.11.5.2, “How MySQL Uses DNS”

gethostbyaddr_r()

Section 7.11.5.2, “How MySQL Uses DNS”

gethostbyname()

Section 7.11.5.2, “How MySQL Uses DNS”

gethostbyname_r()

Section 7.11.5.2, “How MySQL Uses DNS”

my_open()

Section 5.1.5, “Server Status Variables”

setrlimit()

Section 5.1.2, “Server Command Options”

thr_setconcurrency()

Section 5.1.3, “Server System Variables”
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices
   
Command Index Начало INFORMATION_SCHEMA Index
    Поддержать сайт на родительском проекте КГБ