Function Index

Symbols

[index top]

%

Section 1.8.4, "MySQL Extensions to Standard SQL"

A

[index top]

ABS()

Section 13.7.3.1, "CREATE FUNCTION Syntax for User-DefinedFunctions"

Section 23.3, "Adding New Functions to MySQL"

Section 12.6.2, "Mathematical Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

ACOS()

Section 12.6.2, "Mathematical Functions"

ADDDATE()

Section 12.7, "Date and Time Functions"

addslashes()

Section 6.1.7, "Client Programming Security Guidelines"

ADDTIME()

Section 12.7, "Date and Time Functions"

AES_DECRYPT()

Section 12.13, "Encryption and Compression Functions"

AES_ENCRYPT()

Section 12.13, "Encryption and Compression Functions"

Area()

Section 12.18.5.2, "Geometry Property Functions"

Section 12.18.5.2.6, "MultiPolygon Functions"

Section 12.18.5.2.5, "Polygon Functions"

AsBinary()

Section 12.18.4.5, "Fetching Spatial Data"

Section 12.18.5.1, "Geometry Format Conversion Functions"

ASCII()

Section 13.8.3, "HELP Syntax"

Section 12.5, "String Functions"

ASIN()

Section 12.6.2, "Mathematical Functions"

AsText()

Section 12.18.4.5, "Fetching Spatial Data"

Section 12.18.5.1, "Geometry Format Conversion Functions"

AsWKB()

Section 12.18.5.1, "Geometry Format Conversion Functions"

AsWKT()

Section 12.18.5.1, "Geometry Format Conversion Functions"

ATAN()

Section 12.6.2, "Mathematical Functions"

ATAN2()

Section 12.6.2, "Mathematical Functions"

AVG()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

Section 11.1.2, "Date and Time Type Overview"

Section 8.13.14.1, "Loose Index Scan"

Section 11.4.4, "The ENUM Type"

Section 11.4.5, "The SET Type"

B

[index top]

BdMPolyFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

BdMPolyFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

BdPolyFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

BdPolyFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

BENCHMARK()

Section 8.9.3.1, "How the Query Cache Operates"

Section 12.14, "Information Functions"

Section 8.12.1, "Measuring the Speed of Expressions and Functions"

Section 13.2.10.10, "Optimizing Subqueries"

Section 13.2.10.8, "Subqueries in the FROM Clause"

BIN()

Section 9.1.6, "Bit-Field Literals"

Section 12.5, "String Functions"

BIT_AND()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

BIT_COUNT()

Section 12.12, "Bit Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

BIT_LENGTH()

Section 12.5, "String Functions"

BIT_OR()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

BIT_XOR()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Boundary()

Section 12.18.5.2.1, "General Geometry Functions"

Buffer()

Section 12.18.5.3.2, "Spatial Operators"

C

[index top]

CAST()

Section 10.1.9.2, "CONVERT() andCAST()"

Section 9.1.6, "Bit-Field Literals"

Section 12.10, "Cast Functions and Operators"

Section 12.3.2, "Comparison Functions and Operators"

Section 11.3.7, "Conversion Between Date and Time Types"

Section 12.7, "Date and Time Functions"

Section 9.1.4, "Hexadecimal Literals"

Section 1.8.5, "MySQL Differences from Standard SQL"

Section 10.1.9.1, "Result Strings"

Section 10.1.7.7, "The BINARY Operator"

Section 12.2, "Type Conversion in Expression Evaluation"

Section 9.4, "User-Defined Variables"

CEIL()

Section 12.6.2, "Mathematical Functions"

CEILING()

Section 18.2.4.1, "LINEAR HASH Partitioning"

Section 12.6.2, "Mathematical Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

Centroid()

Section 12.18.5.2.6, "MultiPolygon Functions"

CHAR()

Section 12.10, "Cast Functions and Operators"

Section 12.13, "Encryption and Compression Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 12.5, "String Functions"

CHAR_LENGTH()

Section 12.5, "String Functions"

CHARACTER_LENGTH()

Section 12.5, "String Functions"

CHARSET()

Section 12.14, "Information Functions"

Section 10.1.9.1, "Result Strings"

COALESCE()

Section 13.2.9.2, "JOIN Syntax"

Section 12.3.2, "Comparison Functions and Operators"

COERCIBILITY()

Section 10.1.7.5, "Collation of Expressions"

Section 12.14, "Information Functions"

COLLATION()

Section C.5.5.1, "Case Sensitivity in String Searches"

Section 12.14, "Information Functions"

Section 10.1.9.1, "Result Strings"

COMPRESS()

Section 12.13, "Encryption and Compression Functions"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 5.1.4, "Server System Variables"

CONCAT()

Section 13.7.3.1, "CREATE FUNCTION Syntax for User-DefinedFunctions"

Section 12.17.1, "GROUP BY (Aggregate) Functions"

Section 13.7.5.14, "SHOW CREATE VIEW Syntax"

Section 12.10, "Cast Functions and Operators"

Section 10.1.7.5, "Collation of Expressions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 10.1.9.1, "Result Strings"

Section 5.1.7, "Server SQL Modes"

Section 12.5, "String Functions"

Section 10.1.8, "String Repertoire"

Section 20.29, "The INFORMATION_SCHEMA VIEWS Table"

Section 12.2, "Type Conversion in Expression Evaluation"

Section 12.11, "XML Functions"

CONCAT_WS()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

Section 12.5, "String Functions"

CONNECTION_ID()

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

Section 12.14, "Information Functions"

Section 21.9.9.3, "The threads Table"

Section 6.3.11.3, "The Audit Log File"

Contains()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

Section 1.4, "What Is New in MySQL 5.6"

CONV()

Section 12.6.2, "Mathematical Functions"

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

CONVERT()

Section 10.1.9.2, "CONVERT() andCAST()"

Section 12.10, "Cast Functions and Operators"

Section 10.1.3.5, "Character String Literal Character Set and Collation"

Section 12.3.2, "Comparison Functions and Operators"

CONVERT_TZ()

Section 12.7, "Date and Time Functions"

Section 8.9.3.1, "How the Query Cache Operates"

Section 16.4.1.29, "Replication and Time Zones"

Section 13.3.5.3, "Table-Locking Restrictions and Conditions"

ConvexHull()

Section 12.18.5.3.2, "Spatial Operators"

COS()

Section 12.6.2, "Mathematical Functions"

COT()

Section 12.6.2, "Mathematical Functions"

COUNT()

Section 13.7.3.1, "CREATE FUNCTION Syntax for User-DefinedFunctions"

Section 8.8.2, "EXPLAIN Output Format"

Section 12.17.1, "GROUP BY (Aggregate) Functions"

Section 3.3.4.8, "Counting Rows"

Section 8.2.1.2, "How MySQL Optimizes WHERE Clauses"

Section 8.13.14.1, "Loose Index Scan"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 18.1, "Overview of Partitioning in MySQL"

Section C.5.5.3, "Problems with NULL Values"

Section 5.1.7, "Server SQL Modes"

Section 19.5.3, "Updatable and Insertable Views"

Section 19.5.2, "View Processing Algorithms"

CRC32()

Section 12.6.2, "Mathematical Functions"

Crosses()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

crypt()

Section 12.13, "Encryption and Compression Functions"

Section 5.1.4, "Server System Variables"

CURDATE()

Section 12.7, "Date and Time Functions"

Section 3.3.4.5, "Date Calculations"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

CURRENT_DATE

Section 13.1.17, "CREATE TABLE Syntax"

Section 11.5, "Data Type Default Values"

Section 12.7, "Date and Time Functions"

CURRENT_DATE()

Section 11.3.7, "Conversion Between Date and Time Types"

Section 12.7, "Date and Time Functions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

CURRENT_TIME

Section 12.7, "Date and Time Functions"

CURRENT_TIME()

Section 12.7, "Date and Time Functions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

CURRENT_TIMESTAMP

Section 13.1.11, "CREATE EVENT Syntax"

Section 13.1.17, "CREATE TABLE Syntax"

Section 11.3.5, "Automatic Initialization and Updating for TIMESTAMP andDATETIME"

Section 11.5, "Data Type Default Values"

Section 12.7, "Date and Time Functions"

CURRENT_TIMESTAMP()

Section 11.3.5, "Automatic Initialization and Updating for TIMESTAMP andDATETIME"

Section 12.7, "Date and Time Functions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

CURRENT_USER

Section 13.1.11, "CREATE EVENT Syntax"

Section 13.1.15, "CREATE PROCEDURE andCREATE FUNCTION Syntax"

Section 13.1.19, "CREATE TRIGGER Syntax"

Section 13.1.20, "CREATE VIEW Syntax"

Section 19.6, "Access Control for Stored Programs and Views"

Section 12.14, "Information Functions"

Section 5.2.4.3, "Mixed Binary Logging Format"

Section 6.2.2, "Privilege System Grant Tables"

Section 16.4.1.15, "Replication and System Functions"

Section 16.4.1.7, "Replication of CURRENT_USER()"

Section 6.2.3, "Specifying Account Names"

CURRENT_USER()

Section 13.1.11, "CREATE EVENT Syntax"

Section 13.1.15, "CREATE PROCEDURE andCREATE FUNCTION Syntax"

Section 13.1.19, "CREATE TRIGGER Syntax"

Section 13.1.20, "CREATE VIEW Syntax"

Section 13.7.1.7, "SET PASSWORD Syntax"

Section 6.2.4, "Access Control, Stage 1: Connection Verification"

Section 23.2.4.9.4, "Implementing Proxy User Support in Authentication Plugins"

Section 12.14, "Information Functions"

Section 5.2.4.3, "Mixed Binary Logging Format"

Section 6.3.8, "Proxy Users"

Section 16.4.1.15, "Replication and System Functions"

Section 16.4.1.7, "Replication of CURRENT_USER()"

Section 6.2.3, "Specifying Account Names"

Section 6.3.12, "SQL-Based MySQL Account Activity Auditing"

Section 10.1.12, "UTF-8 for Metadata"

Section 23.2.4.9.1, "Writing the Server-Side Authentication Plugin"

CURTIME()

Section 12.7, "Date and Time Functions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 11.3.6, "Fractional Seconds in Time Values"

Section 8.9.3.1, "How the Query Cache Operates"

Section 10.6, "MySQL Server Time Zone Support"

Section 16.4.1.13, "Replication and Fractional Seconds Support"

D

[index top]

DATABASE()

Section 13.1.21, "DROP DATABASE Syntax"

Section 16.1.4.4, "Binary Log Options and Variables"

Section 3.3.1, "Creating and Selecting a Database"

Section 3.4, "Getting Information About Databases and Tables"

Section 8.9.3.1, "How the Query Cache Operates"

Section 12.14, "Information Functions"

Section C.5.8, "Known Issues in MySQL"

Section 10.1.12, "UTF-8 for Metadata"

DATE()

Section 12.7, "Date and Time Functions"

DATE_ADD()

Section 13.1.11, "CREATE EVENT Syntax"

Section 12.6.1, "Arithmetic Operators"

Section 12.7, "Date and Time Functions"

Section 11.3, "Date and Time Types"

Section 3.3.4.5, "Date Calculations"

Section 9.5, "Expression Syntax"

DATE_FORMAT()

Section 22.8.18, "C API Prepared Statement Problems"

Section 12.7, "Date and Time Functions"

Section 10.7, "MySQL Server Locale Support"

Section 5.1.4, "Server System Variables"

DATE_SUB()

Section 12.7, "Date and Time Functions"

Section 11.3, "Date and Time Types"

DATEDIFF()

Section 12.7, "Date and Time Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

DAY()

Section 12.7, "Date and Time Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

DAYNAME()

Section 12.7, "Date and Time Functions"

Section 10.7, "MySQL Server Locale Support"

Section 5.1.4, "Server System Variables"

DAYOFMONTH()

Section 12.7, "Date and Time Functions"

Section 3.3.4.5, "Date Calculations"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

DAYOFWEEK()

Section 12.7, "Date and Time Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

DAYOFYEAR()

Section 12.7, "Date and Time Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

Section 18.2, "Partitioning Types"

DECODE()

Section 12.13, "Encryption and Compression Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

DEFAULT()

Section 13.2.5, "INSERT Syntax"

Section 13.2.8, "REPLACE Syntax"

Section 11.5, "Data Type Default Values"

Section 12.16, "Miscellaneous Functions"

DEGREES()

Section 12.6.2, "Mathematical Functions"

DES_DECRYPT()

Section 12.13, "Encryption and Compression Functions"

Section 5.1.3, "Server Command Options"

DES_ENCRYPT()

Section 12.13, "Encryption and Compression Functions"

Section 5.1.3, "Server Command Options"

Difference()

Section 12.18.5.3.2, "Spatial Operators"

Dimension()

Section 12.18.5.2.1, "General Geometry Functions"

Disjoint()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

E

[index top]

ELT()

Section C.5.8, "Known Issues in MySQL"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

ENCODE()

Section 12.13, "Encryption and Compression Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

ENCRYPT()

Section 12.13, "Encryption and Compression Functions"

Section 8.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.4, "Server System Variables"

Section 6.3.1, "User Names and Passwords"

EndPoint()

Section 12.18.5.2.3, "LineString Functions"

Section 12.18.5.2.4, "MultiLineString Functions"

Section 12.18.5.3.1, "Geometry Functions That Produce New Geometries"

Envelope()

Section 12.18.5.2.1, "General Geometry Functions"

Section 12.18.5.3.1, "Geometry Functions That Produce New Geometries"

Equals()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

EXP()

Section 12.6.2, "Mathematical Functions"

EXPORT_SET()

Section 12.5, "String Functions"

expr IN ()

Section 12.3.2, "Comparison Functions and Operators"

expr NOT IN ()

Section 12.3.2, "Comparison Functions and Operators"

ExteriorRing()

Section 12.18.5.2.5, "Polygon Functions"

Section 12.18.5.3.1, "Geometry Functions That Produce New Geometries"

EXTRACT()

Section 12.10, "Cast Functions and Operators"

Section 12.7, "Date and Time Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

ExtractValue()

Section 12.11, "XML Functions"

F

[index top]

FIELD()

Section 12.5, "String Functions"

FIND_IN_SET()

Section 12.5, "String Functions"

Section 11.4.5, "The SET Type"

FLOOR()

Section 12.6.1, "Arithmetic Operators"

Section 12.6.2, "Mathematical Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

FORMAT()

Section 12.6.2, "Mathematical Functions"

Section 12.16, "Miscellaneous Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 10.7, "MySQL Server Locale Support"

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

FOUND_ROWS()

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

Section 12.14, "Information Functions"

Section 5.2.4.3, "Mixed Binary Logging Format"

Section 16.4.1.15, "Replication and System Functions"

FROM_BASE64()

Section 12.5, "String Functions"

FROM_DAYS()

Section 12.7, "Date and Time Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

FROM_UNIXTIME()

Section 6.3.11.4, "Audit Log Plugin Logging Control"

Section 12.7, "Date and Time Functions"

Section 16.4.1.29, "Replication and Time Zones"

G

[index top]

GeomCollFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

GeomCollFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

GeometryCollection()

Section 12.18.4.2.3, "Creating Geometry Values Using MySQL-Specific Functions"

GeometryCollectionFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

GeometryCollectionFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

GeometryFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

GeometryFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

GeometryN()

Section 12.18.5.2.7, "GeometryCollection Functions"

Section 12.18.5.3.1, "Geometry Functions That Produce New Geometries"

GeometryType()

Section 12.18.5.2.1, "General Geometry Functions"

GeomFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

Section 12.18.5.1, "Geometry Format Conversion Functions"

Section 12.18.4.4, "Populating Spatial Columns"

GeomFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

Section 12.18.5.1, "Geometry Format Conversion Functions"

GET_FORMAT()

Section 12.7, "Date and Time Functions"

Section 10.7, "MySQL Server Locale Support"

GET_LOCK()

Section 13.1.11, "CREATE EVENT Syntax"

Section 13.7.6.4, "KILL Syntax"

Section 22.8.7.3, "mysql_change_user()"

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 22.8.16, "Controlling Automatic Reconnection Behavior"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 19.4.1, "Event Scheduler Overview"

Section 8.12.5.2, "General Thread States"

Section 8.9.3.1, "How the Query Cache Operates"

Section 12.16, "Miscellaneous Functions"

Section 16.4.1.15, "Replication and System Functions"

Section 13.3.5.3, "Table-Locking Restrictions and Conditions"

gethostbyaddr()

Section 8.11.5.2, "DNS Lookup Optimization and the Host Cache"

gethostbyaddr_r()

Section 8.11.5.2, "DNS Lookup Optimization and the Host Cache"

gethostbyname()

Section 8.11.5.2, "DNS Lookup Optimization and the Host Cache"

gethostbyname_r()

Section 8.11.5.2, "DNS Lookup Optimization and the Host Cache"

getrusage()

Section 17.5.10.18, "The ndbinfo threadstat Table"

gettimeofday()

Section 17.5.10.18, "The ndbinfo threadstat Table"

GLength()

Section 12.18.5.2.3, "LineString Functions"

Section 12.18.5.2.4, "MultiLineString Functions"

Section 12.18.7, "MySQL Conformance and Compatibility"

GREATEST()

Section 12.3.2, "Comparison Functions and Operators"

Section 10.1.9.1, "Result Strings"

GROUP_CONCAT()

Section 12.17.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.4, "Server System Variables"

GTID_SUBSET()

Section 16.1.3.1, "GTID Concepts"

Section 12.15, "GTID Functions"

GTID_SUBTRACT()

Section 16.1.3.1, "GTID Concepts"

Section 12.15, "GTID Functions"

H

[index top]

HEX()

Section 10.1.3.5, "Character String Literal Character Set and Collation"

Section 9.1.4, "Hexadecimal Literals"

Section 12.6.2, "Mathematical Functions"

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

HOUR()

Section 12.7, "Date and Time Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

I

[index top]

IF()

Section 13.6.5.2, "IF Syntax"

Section 12.4, "Control Flow Functions"

Section C.5.8, "Known Issues in MySQL"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 10.1.9.1, "Result Strings"

IFNULL()

Section 12.4, "Control Flow Functions"

Section C.5.5.3, "Problems with NULL Values"

IN

Section 12.3.1, "Operator Precedence"

IN()

Section 8.8.2, "EXPLAIN Output Format"

Section E.4, "Restrictions on Subqueries"

Section 8.13.1.1, "The Range Access Method for Single-Part Indexes"

Section 12.2, "Type Conversion in Expression Evaluation"

INET6_ATON()

Section 5.1.9, "IPv6 Support"

Section 12.16, "Miscellaneous Functions"

INET6_NTOA()

Section 5.1.9, "IPv6 Support"

Section 12.16, "Miscellaneous Functions"

INET_ATON()

Section 5.1.9, "IPv6 Support"

Section 12.16, "Miscellaneous Functions"

INET_NTOA()

Section 5.1.9, "IPv6 Support"

Section 12.16, "Miscellaneous Functions"

INSERT()

Section 12.5, "String Functions"

INSTR()

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

InteriorRingN()

Section 12.18.5.2.5, "Polygon Functions"

Section 12.18.5.3.1, "Geometry Functions That Produce New Geometries"

Intersection()

Section 12.18.5.3.2, "Spatial Operators"

Intersects()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

INTERVAL()

Section 12.3.2, "Comparison Functions and Operators"

IS_FREE_LOCK()

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 12.16, "Miscellaneous Functions"

Section 16.4.1.15, "Replication and System Functions"

IS_IPV4()

Section 12.16, "Miscellaneous Functions"

IS_IPV4_COMPAT()

Section 12.16, "Miscellaneous Functions"

IS_IPV4_MAPPED()

Section 12.16, "Miscellaneous Functions"

IS_IPV6()

Section 12.16, "Miscellaneous Functions"

IS_USED_LOCK()

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 12.16, "Miscellaneous Functions"

Section 16.4.1.15, "Replication and System Functions"

IsClosed()

Section 12.18.5.2.4, "MultiLineString Functions"

IsEmpty()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

Section 12.18.5.2.1, "General Geometry Functions"

ISNULL()

Section 12.3.2, "Comparison Functions and Operators"

IsRing()

Section 12.18.5.2.3, "LineString Functions"

IsSimple()

Section 12.18.5.2.1, "General Geometry Functions"

L

[index top]

LAST_DAY()

Section 12.7, "Date and Time Functions"

LAST_INSERT_ID()

Section 4.6.8.1, "mysqlbinlog Hex Dump Format"

Section 13.1.17, "CREATE TABLE Syntax"

Section 13.2.5.3, "INSERT ... ON DUPLICATE KEY UPDATE Syntax"

Section 13.2.5.2, "INSERT DELAYED Syntax"

Section 13.2.5, "INSERT Syntax"

Section 22.8.7.37, "mysql_insert_id()"

Section 22.8.11.16, "mysql_stmt_insert_id()"

Section 12.3.2, "Comparison Functions and Operators"

Section 22.8.16, "Controlling Automatic Reconnection Behavior"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

Section 22.8.15.3, "How to Get the Unique ID for the Last Inserted Row"

Section 12.14, "Information Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 16.4.1.1, "Replication and AUTO_INCREMENT"

Section 5.1.4, "Server System Variables"

Section 19.2.4, "Stored Procedures, Functions, Triggers, andLAST_INSERT_ID()"

Section 13.3.5.3, "Table-Locking Restrictions and Conditions"

Section 1.8.5.3, "Transaction and Atomic Operation Differences"

Section 16.4.4, "Troubleshooting Replication"

Section 19.5.3, "Updatable and Insertable Views"

Section 3.6.9, "Using AUTO_INCREMENT"

LCASE()

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

LEAST()

Section 12.3.2, "Comparison Functions and Operators"

Section 10.1.9.1, "Result Strings"

LEFT()

Section 12.10, "Cast Functions and Operators"

Section 12.5, "String Functions"

LENGTH()

Section 12.5, "String Functions"

Length()

Section 12.18.5.2.3, "LineString Functions"

Section 12.18.5.2.4, "MultiLineString Functions"

Section 12.18.7, "MySQL Conformance and Compatibility"

LineFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

Section 12.18.5.1, "Geometry Format Conversion Functions"

LineFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

Section 12.18.5.1, "Geometry Format Conversion Functions"

LineString()

Section 12.18.4.2.3, "Creating Geometry Values Using MySQL-Specific Functions"

LineStringFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

LineStringFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

LN()

Section 12.6.2, "Mathematical Functions"

LOAD_FILE()

Section 13.2.7, "LOAD XML Syntax"

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

Section 5.2.4.3, "Mixed Binary Logging Format"

Section 6.2.1, "Privileges Provided by MySQL"

Section 16.4.1.15, "Replication and System Functions"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 12.5, "String Functions"

LOCALTIME

Section 11.3.5, "Automatic Initialization and Updating for TIMESTAMP andDATETIME"

Section 12.7, "Date and Time Functions"

LOCALTIME()

Section 11.3.5, "Automatic Initialization and Updating for TIMESTAMP andDATETIME"

Section 12.7, "Date and Time Functions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

LOCALTIMESTAMP

Section 11.3.5, "Automatic Initialization and Updating for TIMESTAMP andDATETIME"

Section 12.7, "Date and Time Functions"

LOCALTIMESTAMP()

Section 11.3.5, "Automatic Initialization and Updating for TIMESTAMP andDATETIME"

Section 12.7, "Date and Time Functions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

LOCATE()

Section 12.5, "String Functions"

LOG()

Section 18.2.4.1, "LINEAR HASH Partitioning"

Section 12.6.2, "Mathematical Functions"

LOG10()

Section 12.6.2, "Mathematical Functions"

LOG2()

Section 12.6.2, "Mathematical Functions"

LOWER()

Section 12.10, "Cast Functions and Operators"

Section 10.1.7.9, "Collation and INFORMATION_SCHEMA Searches"

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

Section 10.1.14.1, "Unicode Character Sets"

LPAD()

Section 12.5, "String Functions"

LTRIM()

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

M

[index top]

MAKE_SET()

Section 12.5, "String Functions"

MAKEDATE()

Section 12.7, "Date and Time Functions"

MAKETIME()

Section 12.7, "Date and Time Functions"

MASTER_POS_WAIT()

Section 13.4.2.1, "CHANGE MASTER TO Syntax"

Section 13.4.2.2, "MASTER_POS_WAIT() Syntax"

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

Section 12.16, "Miscellaneous Functions"

MATCH

Section 9.5, "Expression Syntax"

MATCH ()

Section 12.9, "Full-Text Search Functions"

MATCH()

Section 14.2.3.12.3, "FULLTEXT Indexes"

Section 12.9.2, "Boolean Full-Text Searches"

Section 12.9.6, "Fine-Tuning MySQL Full-Text Search"

Section 12.9.5, "Full-Text Restrictions"

Section 12.9, "Full-Text Search Functions"

Section 12.9.1, "Natural Language Full-Text Searches"

Section 1.4, "What Is New in MySQL 5.6"

MAX()

Section 8.8.2, "EXPLAIN Output Format"

Section 12.17.1, "GROUP BY (Aggregate) Functions"

Section 8.3.1, "How MySQL Uses Indexes"

Section C.5.8, "Known Issues in MySQL"

Section 8.13.14.1, "Loose Index Scan"

Section 12.17.3, "MySQL Extensions to GROUP BY"

Section 11.1.1, "Numeric Type Overview"

Section 13.2.10.10, "Optimizing Subqueries"

Section 5.1.7, "Server SQL Modes"

Section 20.31.2, "The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table"

Section 11.3.8, "Two-Digit Years in Dates"

Section 19.5.3, "Updatable and Insertable Views"

Section 8.13.5, "Use of Index Extensions"

Section 3.6.9, "Using AUTO_INCREMENT"

Section 19.5.2, "View Processing Algorithms"

MBRContains()

Section 12.18.5.4.1, "Relations on Geometry Minimal Bounding Rectangles (MBRs)"

Section 12.18.6.2, "Using a Spatial Index"

MBRDisjoint()

Section 12.18.5.4.1, "Relations on Geometry Minimal Bounding Rectangles (MBRs)"

MBREqual()

Section 12.18.5.4.1, "Relations on Geometry Minimal Bounding Rectangles (MBRs)"

MBRIntersects()

Section 12.18.5.4.1, "Relations on Geometry Minimal Bounding Rectangles (MBRs)"

MBROverlaps()

Section 12.18.5.4.1, "Relations on Geometry Minimal Bounding Rectangles (MBRs)"

MBRTouches()

Section 12.18.5.4.1, "Relations on Geometry Minimal Bounding Rectangles (MBRs)"

MBRWithin()

Section 12.18.5.4.1, "Relations on Geometry Minimal Bounding Rectangles (MBRs)"

Section 12.18.6.2, "Using a Spatial Index"

MD5()

Section 18.2.5, "KEY Partitioning"

Section 12.13, "Encryption and Compression Functions"

Section 6.1.2.5, "Implications of Password Hashing Changes in MySQL 4.1 for ApplicationPrograms"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 9.2, "Schema Object Names"

Section 6.1.1, "Security Guidelines"

MICROSECOND()

Section 12.7, "Date and Time Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

MID()

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

MIN()

Section 8.8.2, "EXPLAIN Output Format"

Section 12.17.1, "GROUP BY (Aggregate) Functions"

Section 22.8.18, "C API Prepared Statement Problems"

Section 8.2.1.2, "How MySQL Optimizes WHERE Clauses"

Section 8.3.1, "How MySQL Uses Indexes"

Section C.5.8, "Known Issues in MySQL"

Section 8.13.14.1, "Loose Index Scan"

Section 12.17.3, "MySQL Extensions to GROUP BY"

Section 11.1.1, "Numeric Type Overview"

Section 13.2.10.10, "Optimizing Subqueries"

Section C.5.5.3, "Problems with NULL Values"

Section 11.3.8, "Two-Digit Years in Dates"

Section 19.5.3, "Updatable and Insertable Views"

Section 8.13.5, "Use of Index Extensions"

Section 19.5.2, "View Processing Algorithms"

MINUTE()

Section 12.7, "Date and Time Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

MLineFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

MLineFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

MOD()

Section 12.6.1, "Arithmetic Operators"

Section 3.3.4.5, "Date Calculations"

Section 12.6.2, "Mathematical Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

Section 5.1.7, "Server SQL Modes"

MONTH()

Section 12.7, "Date and Time Functions"

Section 3.3.4.5, "Date Calculations"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

Section 18.2, "Partitioning Types"

MONTHNAME()

Section 12.7, "Date and Time Functions"

Section 10.7, "MySQL Server Locale Support"

Section 5.1.4, "Server System Variables"

MPointFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

MPointFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

MPolyFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

MPolyFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

MultiLineString()

Section 12.18.4.2.3, "Creating Geometry Values Using MySQL-Specific Functions"

MultiLineStringFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

MultiLineStringFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

MultiPoint()

Section 12.18.4.2.3, "Creating Geometry Values Using MySQL-Specific Functions"

MultiPointFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

MultiPointFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

MultiPolygon()

Section 12.18.4.2.3, "Creating Geometry Values Using MySQL-Specific Functions"

MultiPolygonFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

MultiPolygonFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

my_open()

Section 5.1.6, "Server Status Variables"

N

[index top]

NAME_CONST()

Section 19.7, "Binary Logging of Stored Programs"

Section 12.16, "Miscellaneous Functions"

NOW()

Section 13.1.15, "CREATE PROCEDURE and CREATE FUNCTION Syntax"

Section 13.1.17, "CREATE TABLE Syntax"

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-Based Replication"

Section 11.3.5, "Automatic Initialization and Updating for TIMESTAMP andDATETIME"

Section 11.5, "Data Type Default Values"

Section 12.7, "Date and Time Functions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 11.3.6, "Fractional Seconds in Time Values"

Section 8.9.3.1, "How the Query Cache Operates"

Section 10.6, "MySQL Server Time Zone Support"

Section 16.4.1.15, "Replication and System Functions"

Section 16.4.1.29, "Replication and Time Zones"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 11.3.3, "The YEAR Type"

Section 10.6.2, "Time Zone Leap Second Support"

NULLIF()

Section 12.4, "Control Flow Functions"

NumGeometries()

Section 12.18.5.2.7, "GeometryCollection Functions"

NumInteriorRings()

Section 12.18.5.2.5, "Polygon Functions"

NumPoints()

Section 12.18.5.2.3, "LineString Functions"

O

[index top]

OCT()

Section 12.5, "String Functions"

OCTET_LENGTH()

Section 12.5, "String Functions"

OLD_PASSWORD()

Section C.5.2.4, "Client does not support authentication protocol"

Section 13.7.1.7, "SET PASSWORD Syntax"

Section 12.13, "Encryption and Compression Functions"

Section 6.1.2.5, "Implications of Password Hashing Changes in MySQL 4.1 for ApplicationPrograms"

Section 6.1.2.4, "Password Hashing in MySQL"

Section 23.2.3.8, "Password-Validation Plugins"

Section 5.1.4, "Server System Variables"

Section 6.1.2.6, "The Password Validation Plugin"

Section 1.4, "What Is New in MySQL 5.6"

ORD()

Section 12.5, "String Functions"

Overlaps()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

P

[index top]

PASSWORD()

Section 13.7.1.2, "CREATE USER Syntax"

Section C.5.2.15, "Ignoring user"

Section 18.2.5, "KEY Partitioning"

Section 13.7.1.7, "SET PASSWORD Syntax"

Section 6.2.4, "Access Control, Stage 1: Connection Verification"

Section 6.3.2, "Adding User Accounts"

Section 6.3.5, "Assigning Account Passwords"

Section 6.2.7, "Causes of Access-Denied Errors"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 12.13, "Encryption and Compression Functions"

Section 8.9.3.1, "How the Query Cache Operates"

Section 6.1.2.5, "Implications of Password Hashing Changes in MySQL 4.1 for ApplicationPrograms"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 6.1.2.4, "Password Hashing in MySQL"

Section 23.2.3.8, "Password-Validation Plugins"

Section 6.1.2.3, "Passwords and Logging"

Section 2.10.2, "Securing the Initial MySQL Accounts"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

Section 6.1.2.6, "The Password Validation Plugin"

Section 6.3.7.2, "The SHA-256 Authentication Plugin"

Section 6.3.1, "User Names and Passwords"

Section 1.4, "What Is New in MySQL 5.6"

PERIOD_ADD()

Section 12.7, "Date and Time Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

PERIOD_DIFF()

Section 12.7, "Date and Time Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

PI()

Section 9.2.4, "Function Name Parsing and Resolution"

Section 12.6.2, "Mathematical Functions"

POINT()

Section 12.18.3.1, "Well-Known Text (WKT) Format"

Point()

Section 12.18.4.2.3, "Creating Geometry Values Using MySQL-Specific Functions"

PointFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

Section 12.18.5.1, "Geometry Format Conversion Functions"

PointFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

Section 12.18.5.1, "Geometry Format Conversion Functions"

PointN()

Section 12.18.5.2.3, "LineString Functions"

Section 12.18.5.3.1, "Geometry Functions That Produce New Geometries"

PolyFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

PolyFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

Polygon()

Section 12.18.4.2.3, "Creating Geometry Values Using MySQL-Specific Functions"

PolygonFromText()

Section 12.18.4.2.1, "Creating Geometry Values Using WKT Functions"

PolygonFromWKB()

Section 12.18.4.2.2, "Creating Geometry Values Using WKB Functions"

POSITION()

Section 12.5, "String Functions"

POW()

Section 18.2.4, "HASH Partitioning"

Section 12.6.2, "Mathematical Functions"

POWER()

Section 18.2.4.1, "LINEAR HASH Partitioning"

Section 12.6.2, "Mathematical Functions"

Q

[index top]

QUARTER()

Section 12.7, "Date and Time Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

QUOTE()

Section 22.8.7.54, "mysql_real_escape_string()"

Section 12.5, "String Functions"

Section 9.1.1, "String Literals"

R

[index top]

RADIANS()

Section 12.6.2, "Mathematical Functions"

RAND()

Section 4.6.8.1, "mysqlbinlog Hex Dump Format"

Section 13.1.15, "CREATE PROCEDURE and CREATE FUNCTION Syntax"

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

Section 12.6.2, "Mathematical Functions"

Section 16.4.1.15, "Replication and System Functions"

Section 5.1.4, "Server System Variables"

RELEASE_LOCK()

Section 13.2.3, "DO Syntax"

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

Section 12.16, "Miscellaneous Functions"

Section 16.4.1.15, "Replication and System Functions"

Section 13.3.5.3, "Table-Locking Restrictions and Conditions"

REPEAT()

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

REPLACE()

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

REVERSE()

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

RIGHT()

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

ROUND()

Section 12.6.2, "Mathematical Functions"

Section 12.19, "Precision Math"

Section 12.19.5, "Precision Math Examples"

Section 12.19.4, "Rounding Behavior"

ROW_COUNT()

Section 13.2.1, "CALL Syntax"

Section 13.2.2, "DELETE Syntax"

Section 13.2.5, "INSERT Syntax"

Section 22.8.7.1, "mysql_affected_rows()"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 13.6.7.7.2, "Diagnostics Area Information Items"

Section 12.14, "Information Functions"

Section 5.2.4.3, "Mixed Binary Logging Format"

Section 16.4.1.15, "Replication and System Functions"

RPAD()

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

RTRIM()

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

S

[index top]

SCHEMA()

Section 12.14, "Information Functions"

SEC_TO_TIME()

Section 12.7, "Date and Time Functions"

SECOND()

Section 12.7, "Date and Time Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

SESSION_USER()

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 12.14, "Information Functions"

Section 10.1.12, "UTF-8 for Metadata"

setrlimit()

Section 5.1.3, "Server Command Options"

SHA()

Section 12.13, "Encryption and Compression Functions"

SHA1()

Section 12.13, "Encryption and Compression Functions"

Section 6.1.2.5, "Implications of Password Hashing Changes in MySQL 4.1 for ApplicationPrograms"

Section 6.1.1, "Security Guidelines"

SHA2()

Section 12.13, "Encryption and Compression Functions"

Section 6.1.2.5, "Implications of Password Hashing Changes in MySQL 4.1 for ApplicationPrograms"

Section 6.1.1, "Security Guidelines"

SIGN()

Section 12.6.2, "Mathematical Functions"

SIN()

Section 12.6.2, "Mathematical Functions"

Section 23.3.2.3, "UDF Argument Processing"

SLEEP()

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.12.5.2, "General Thread States"

Section 8.9.3.1, "How the Query Cache Operates"

Section 12.16, "Miscellaneous Functions"

Section 16.4.1, "Replication Features and Issues"

Section 20.31.3, "The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table"

SOUNDEX()

Section 23.3, "Adding New Functions to MySQL"

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

SPACE()

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

SQL_THREAD_WAIT_AFTER_GTIDS()

Section 12.15, "GTID Functions"

SQRT()

Section 12.6.2, "Mathematical Functions"

SRID()

Section 12.18.5.2.1, "General Geometry Functions"

ST_Contains()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

Section 1.4, "What Is New in MySQL 5.6"

ST_Crosses()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

ST_Disjoint()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

ST_Equals()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

ST_Intersects()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

ST_Overlaps()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

ST_Touches()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

ST_Within()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

StartPoint()

Section 12.18.5.2.3, "LineString Functions"

Section 12.18.5.2.4, "MultiLineString Functions"

Section 12.18.5.3.1, "Geometry Functions That Produce New Geometries"

STD()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

STDDEV()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

STDDEV_POP()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

STDDEV_SAMP()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

STR_TO_DATE()

Section 12.7, "Date and Time Functions"

Section 10.7, "MySQL Server Locale Support"

STRCMP()

Section C.5.5.2, "Problems Using DATE Columns"

Section 12.5.1, "String Comparison Functions"

SUBDATE()

Section 12.7, "Date and Time Functions"

SUBSTR()

Section 12.5, "String Functions"

SUBSTRING()

Section 10.1.9.1, "Result Strings"

Section 6.3.12, "SQL-Based MySQL Account Activity Auditing"

Section 12.5, "String Functions"

SUBSTRING_INDEX()

Section 12.5, "String Functions"

SUBTIME()

Section 12.7, "Date and Time Functions"

SUM()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

Section 23.3.2, "Adding a New User-Defined Function"

Section 11.1.2, "Date and Time Type Overview"

Section 8.13.14.1, "Loose Index Scan"

Section 18.1, "Overview of Partitioning in MySQL"

Section C.5.5.3, "Problems with NULL Values"

Section 11.4.4, "The ENUM Type"

Section 11.4.5, "The SET Type"

Section 19.5.3, "Updatable and Insertable Views"

Section 19.5.2, "View Processing Algorithms"

SymDifference()

Section 12.18.5.3.2, "Spatial Operators"

SYSDATE()

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 12.7, "Date and Time Functions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 11.3.6, "Fractional Seconds in Time Values"

Section 8.9.3.1, "How the Query Cache Operates"

Section 16.4.1.13, "Replication and Fractional Seconds Support"

Section 16.4.1.15, "Replication and System Functions"

Section 5.1.3, "Server Command Options"

Section 5.1.4, "Server System Variables"

SYSTEM_USER()

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 12.14, "Information Functions"

Section 10.1.12, "UTF-8 for Metadata"

T

[index top]

TAN()

Section 12.6.2, "Mathematical Functions"

thr_setconcurrency()

Section 5.1.4, "Server System Variables"

TIME()

Section 12.7, "Date and Time Functions"

TIME_FORMAT()

Section 12.7, "Date and Time Functions"

TIME_TO_SEC()

Section 12.7, "Date and Time Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

TIMEDIFF()

Section 12.7, "Date and Time Functions"

TIMESTAMP()

Section 12.7, "Date and Time Functions"

TIMESTAMPADD()

Section 12.7, "Date and Time Functions"

TIMESTAMPDIFF()

Section 12.7, "Date and Time Functions"

Section 3.3.4.5, "Date Calculations"

TO_BASE64()

Section 12.5, "String Functions"

TO_DAYS()

Section 18.2.4, "HASH Partitioning"

Section 12.7, "Date and Time Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 18.4, "Partition Pruning"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

Section 18.2, "Partitioning Types"

TO_SECONDS()

Section 12.7, "Date and Time Functions"

Section 18.4, "Partition Pruning"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

Section 18.2, "Partitioning Types"

Touches()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

TRIM()

Section 10.1.13, "Column Character Set Conversion"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

TRUNCATE()

Section 12.6.2, "Mathematical Functions"

U

[index top]

UCASE()

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

UNCOMPRESS()

Section 12.13, "Encryption and Compression Functions"

Section 2.9.4, "MySQL Source-Configuration Options"

Section 5.1.4, "Server System Variables"

UNCOMPRESSED_LENGTH()

Section 12.13, "Encryption and Compression Functions"

UNHEX()

Section 12.13, "Encryption and Compression Functions"

Section 12.5, "String Functions"

Union()

Section 12.18.5.3.2, "Spatial Operators"

UNIX_TIMESTAMP()

Section 18.2.1, "RANGE Partitioning"

Section 12.7, "Date and Time Functions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

Section C.5.4.6, "Time Zone Problems"

UpdateXML()

Section 12.11, "XML Functions"

UPPER()

Section 12.10, "Cast Functions and Operators"

Section 10.1.7.9, "Collation and INFORMATION_SCHEMA Searches"

Section 10.1.9.1, "Result Strings"

Section 12.5, "String Functions"

Section 10.1.8, "String Repertoire"

Section 10.1.14.1, "Unicode Character Sets"

USER()

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 10.1.7.5, "Collation of Expressions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

Section 23.2.4.9.4, "Implementing Proxy User Support in Authentication Plugins"

Section 12.14, "Information Functions"

Section 5.2.4.3, "Mixed Binary Logging Format"

Section 6.3.8, "Proxy Users"

Section 16.4.1.15, "Replication and System Functions"

Section 6.3.12, "SQL-Based MySQL Account Activity Auditing"

Section 10.1.12, "UTF-8 for Metadata"

Section 23.2.4.9.1, "Writing the Server-Side Authentication Plugin"

UTC_DATE

Section 12.7, "Date and Time Functions"

UTC_DATE()

Section 12.7, "Date and Time Functions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

UTC_TIME

Section 12.7, "Date and Time Functions"

UTC_TIME()

Section 12.7, "Date and Time Functions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

UTC_TIMESTAMP

Section 12.7, "Date and Time Functions"

UTC_TIMESTAMP()

Section 12.7, "Date and Time Functions"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 11.3.6, "Fractional Seconds in Time Values"

Section 10.6, "MySQL Server Time Zone Support"

Section 16.4.1.13, "Replication and Fractional Seconds Support"

UUID()

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 16.1.4.4, "Binary Log Options and Variables"

Section 19.7, "Binary Logging of Stored Programs"

Section 22.2.6, "Connector/Net Connection String Options Reference"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

Section 12.16, "Miscellaneous Functions"

Section 5.2.4.3, "Mixed Binary Logging Format"

Section 16.4.1.15, "Replication and System Functions"

Section 5.2.4.2, "Setting The Binary Log Format"

UUID_SHORT()

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section 16.1.2.3, "Determination of Safe and Unsafe Statements in Binary Logging"

Section 8.9.3.1, "How the Query Cache Operates"

Section 12.16, "Miscellaneous Functions"

V

[index top]

VALIDATE_PASSWORD_STRENGTH()

Section 12.13, "Encryption and Compression Functions"

Section 6.1.2.6.2, "Password Validation Plugin Options and Variables"

Section 23.2.3.8, "Password-Validation Plugins"

Section 6.1.2.6, "The Password Validation Plugin"

Section 1.4, "What Is New in MySQL 5.6"

VALUES()

Section 13.2.5.3, "INSERT ... ONDUPLICATE KEY UPDATE Syntax"

Section 12.16, "Miscellaneous Functions"

VAR_POP()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

VAR_SAMP()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

VARIANCE()

Section 12.17.1, "GROUP BY (Aggregate) Functions"

VERSION()

Section 16.1.2.1, "Advantages and Disadvantages of Statement-Based and Row-BasedReplication"

Section C.5.5.1, "Case Sensitivity in String Searches"

Section 10.1.7.5, "Collation of Expressions"

Section 12.14, "Information Functions"

Section 16.4.1.15, "Replication and System Functions"

Section 6.3.11.3, "The Audit Log File"

Section 10.1.12, "UTF-8 for Metadata"

W

[index top]

WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()

Section 12.15, "GTID Functions"

WEEK()

Section 12.7, "Date and Time Functions"

Section 5.1.4, "Server System Variables"

WEEKDAY()

Section 12.7, "Date and Time Functions"

Section 1.8.4, "MySQL Extensions to Standard SQL"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

Section 18.2, "Partitioning Types"

WEEKOFYEAR()

Section 12.7, "Date and Time Functions"

WEIGHT_STRING()

Section 10.4, "Adding a Collation to a Character Set"

Section C.5.5.1, "Case Sensitivity in String Searches"

Section 12.5, "String Functions"

Section 10.1.14.1, "Unicode Character Sets"

Within()

Section 12.18.5.4.2, "Functions That Test Spatial Relationships Between Geometries"

X

[index top]

X()

Section 12.18.5.2.2, "Point Functions"

Y

[index top]

Y()

Section 12.18.5.2.2, "Point Functions"

YEAR()

Section 18.2.4, "HASH Partitioning"

Section 18.2.1, "RANGE Partitioning"

Section 12.7, "Date and Time Functions"

Section 3.3.4.5, "Date Calculations"

Section 18.2.7, "How MySQL Partitioning Handles NULL"

Section 18.3.1, "Management of RANGE and LISTPartitions"

Section 18.4, "Partition Pruning"

Section 18.6.3, "Partitioning Limitations Relating to Functions"

Section 18.2, "Partitioning Types"

YEARWEEK()

Section 12.7, "Date and Time Functions"

Section 18.6.3, "Partitioning Limitations Relating to Functions"