Function Index

Symbols | A | B | C | D | E | F | G | H | I | J | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y

Symbols

[index top]

%

Section 1.8.1, “MySQL Extensions to Standard SQL”

A

[index top]

ABS()

Section 26.4, “Adding New Functions to MySQL”
Section 14.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 13.6.2, “Mathematical Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

ACOS()

Section 13.6.2, “Mathematical Functions”

add()

Section 17.3.3.1, “Basic memcached Operations”

ADDDATE()

Section 13.7, “Date and Time Functions”

addslashes()

Section 7.1.7, “Client Programming Security Guidelines”

ADDTIME()

Section 13.7, “Date and Time Functions”

AES_DECRYPT()

Section 13.13, “Encryption and Compression Functions”
Section 13.18.4, “Enterprise Encryption Function Descriptions”
Section 9.10.3.1, “How the Query Cache Operates”
Section 7.4.1, “OpenSSL Versus yaSSL”
Section 6.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.7”

AES_ENCRYPT()

Section 13.13, “Encryption and Compression Functions”
Section 13.18.4, “Enterprise Encryption Function Descriptions”
Section 9.10.3.1, “How the Query Cache Operates”
Section 7.4.1, “OpenSSL Versus yaSSL”
Section 6.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.7”

ANY_VALUE()

Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section 13.19, “Miscellaneous Functions”
Section 13.20.3, “MySQL Handling of GROUP BY”
Section 6.1.7, “Server SQL Modes”

Area()

Section 13.15.7.4, “Polygon and MultiPolygon Property Functions”

AsBinary()

Section 13.15.6, “Geometry Format Conversion Functions”

ASCII()

Section 14.8.3, “HELP Syntax”
Section 13.5, “String Functions”

ASIN()

Section 13.6.2, “Mathematical Functions”

AsText()

Section 13.15.6, “Geometry Format Conversion Functions”

AsWKB()

Section 13.15.6, “Geometry Format Conversion Functions”

AsWKT()

Section 13.15.6, “Geometry Format Conversion Functions”

ASYMMETRIC_DECRYPT()

Section 13.18.4, “Enterprise Encryption Function Descriptions”

ASYMMETRIC_DERIVE()

Section 13.18.4, “Enterprise Encryption Function Descriptions”

ASYMMETRIC_ENCRYPT()

Section 13.18.4, “Enterprise Encryption Function Descriptions”

ASYMMETRIC_SIGN()

Section 13.18.4, “Enterprise Encryption Function Descriptions”

ASYMMETRIC_VERIFY()

Section 13.18.4, “Enterprise Encryption Function Descriptions”

ATAN()

Section 13.6.2, “Mathematical Functions”

ATAN2()

Section 13.6.2, “Mathematical Functions”

AVG()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 12.1.2, “Date and Time Type Overview”
Section 9.2.1.16.1, “Loose Index Scan”
Section 12.4.4, “The ENUM Type”
Section 1.3.2, “The Main Features of MySQL”
Section 12.4.5, “The SET Type”

B

[index top]

BENCHMARK()

Section 9.10.3.1, “How the Query Cache Operates”
Section 13.14, “Information Functions”
Section 9.13.1, “Measuring the Speed of Expressions and Functions”
Section 14.2.10.10, “Optimizing Subqueries”
Section 14.2.10.8, “Subqueries in the FROM Clause”

BIN()

Section 10.1.6, “Bit-Field Literals”
Section 13.5, “String Functions”

BIT_AND()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 13.12, “Bit Functions and Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”

BIT_COUNT()

Section 13.12, “Bit Functions and Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”

BIT_LENGTH()

Section 13.5, “String Functions”

BIT_OR()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 13.12, “Bit Functions and Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”

BIT_XOR()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 13.12, “Bit Functions and Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”

Buffer()

Section 13.15.8, “Spatial Operator Functions”

C

[index top]

CAST()

Section 13.12, “Bit Functions and Operators”
Section 10.1.6, “Bit-Field Literals”
Section 13.10, “Cast Functions and Operators”
Section 13.3.2, “Comparison Functions and Operators”
Section 12.3.7, “Conversion Between Date and Time Types”
Section 11.1.10.2, “CONVERT() and CAST()”
Section 13.7, “Date and Time Functions”
Section 13.16.2, “Functions That Create JSON Values”
Section 10.1.4, “Hexadecimal Literals”
Section 1.8.2, “MySQL Differences from Standard SQL”
Section 11.1.10.1, “Result Strings”
Section 11.1.8.6, “The BINARY Operator”
Section 12.6, “The JSON Data Type”
Section 13.2, “Type Conversion in Expression Evaluation”
Section 10.4, “User-Defined Variables”

CEIL()

Section 13.6.2, “Mathematical Functions”

CEILING()

Section 20.2.4.1, “LINEAR HASH Partitioning”
Section 13.6.2, “Mathematical Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

Centroid()

Section 13.15.7.4, “Polygon and MultiPolygon Property Functions”

CHAR()

Section 13.10, “Cast Functions and Operators”
Section 13.13, “Encryption and Compression Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 13.5, “String Functions”

CHAR_LENGTH()

Section 13.5, “String Functions”
Section 11.1.14.1, “Unicode Character Sets”

CHARACTER_LENGTH()

Section 13.5, “String Functions”

CHARSET()

Section 13.14, “Information Functions”
Section 11.1.10.1, “Result Strings”

COALESCE()

Section 13.3.2, “Comparison Functions and Operators”
Section 14.2.9.2, “JOIN Syntax”

COERCIBILITY()

Section 11.1.8.4, “Collation of Expressions”
Section 13.14, “Information Functions”

COLLATION()

Section B.5.4.1, “Case Sensitivity in String Searches”
Section 13.14, “Information Functions”
Section 11.1.10.1, “Result Strings”

COMPRESS()

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

CONCAT()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 13.10, “Cast Functions and Operators”
Section 11.1.8.4, “Collation of Expressions”
Section 14.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 11.1.10.1, “Result Strings”
Section 6.1.7, “Server SQL Modes”
Section 14.7.5.13, “SHOW CREATE VIEW Syntax”
Section 13.5, “String Functions”
Section 11.1.9, “String Repertoire”
Section 22.30, “The INFORMATION_SCHEMA VIEWS Table”
Section 13.2, “Type Conversion in Expression Evaluation”
Section 13.11, “XML Functions”

CONCAT_WS()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 13.5, “String Functions”

CONNECTION_ID()

Section 14.1.18.5, “CREATE TABLE and Generated Columns”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 13.14, “Information Functions”
Section 14.7.6.4, “KILL Syntax”
Section 5.5.1.3, “mysql Logging”
Section 14.7.5.29, “SHOW PROCESSLIST Syntax”
Section 7.5.4.4, “The Audit Log File”
Section 23.9.16.3, “The threads Table”

Contains()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 13.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”

CONV()

Section 13.6.2, “Mathematical Functions”
Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

CONVERT()

Section 13.10, “Cast Functions and Operators”
Section 11.1.4.5, “Character String Literal Character Set and Collation”
Section 13.3.2, “Comparison Functions and Operators”
Section 11.1.10.2, “CONVERT() and CAST()”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”

CONVERT_TZ()

Section 13.7, “Date and Time Functions”
Section 9.10.3.1, “How the Query Cache Operates”
Section 6.1.4, “Server System Variables”
Section 14.3.5.3, “Table-Locking Restrictions and Conditions”
Section 6.4.3, “The General Query Log”
Section 6.4.5, “The Slow Query Log”

ConvexHull()

Section 13.15.8, “Spatial Operator Functions”

COS()

Section 13.6.2, “Mathematical Functions”

COT()

Section 13.6.2, “Mathematical Functions”

COUNT()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 4.3.4.8, “Counting Rows”
Section 14.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 9.2.1.2, “How MySQL Optimizes WHERE Clauses”
Section 9.4.4, “Internal Temporary Table Use in MySQL”
Section 19.1.6.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 9.2.1.16.1, “Loose Index Scan”
Section 13.19, “Miscellaneous Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 20.1, “Overview of Partitioning in MySQL”
Section B.5.4.3, “Problems with NULL Values”
Section 6.1.7, “Server SQL Modes”
Section 1.3.2, “The Main Features of MySQL”
Section 21.5.3, “Updatable and Insertable Views”
Section 21.5.2, “View Processing Algorithms”

CRC32()

Section 13.6.2, “Mathematical Functions”

CREATE_ASYMMETRIC_PRIV_KEY()

Section 13.18.4, “Enterprise Encryption Function Descriptions”
Section 13.18.2, “Enterprise Encryption Usage and Examples”

CREATE_ASYMMETRIC_PUB_KEY()

Section 13.18.4, “Enterprise Encryption Function Descriptions”

CREATE_DH_PARAMETERS()

Section 13.18.4, “Enterprise Encryption Function Descriptions”
Section 13.18.2, “Enterprise Encryption Usage and Examples”

CREATE_DIGEST()

Section 13.18.4, “Enterprise Encryption Function Descriptions”

Crosses()

Section 13.15.9.1, “Spatial Relation Functions That Use Object Shapes”

crypt()

Section 13.13, “Encryption and Compression Functions”
Section 6.1.4, “Server System Variables”

CURDATE()

Section 13.7, “Date and Time Functions”
Section 4.3.4.5, “Date Calculations”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”

CURRENT_DATE

Section 14.1.18, “CREATE TABLE Syntax”
Section 12.7, “Data Type Default Values”
Section 13.7, “Date and Time Functions”

CURRENT_DATE()

Section 12.3.7, “Conversion Between Date and Time Types”
Section 13.7, “Date and Time Functions”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”

CURRENT_TIME

Section 13.7, “Date and Time Functions”

CURRENT_TIME()

Section 13.7, “Date and Time Functions”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”

CURRENT_TIMESTAMP

Section 12.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 14.1.12, “CREATE EVENT Syntax”
Section 14.1.18, “CREATE TABLE Syntax”
Section 12.7, “Data Type Default Values”
Section 13.7, “Date and Time Functions”

CURRENT_TIMESTAMP()

Section 12.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.7, “Date and Time Functions”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”

CURRENT_USER

Section 21.6, “Access Control for Stored Programs and Views”
Section 14.7.1.1, “ALTER USER Syntax”
Section 14.1.12, “CREATE EVENT Syntax”
Section 14.1.16, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 14.1.20, “CREATE TRIGGER Syntax”
Section 14.1.21, “CREATE VIEW Syntax”
Section 7.2.2, “Grant Tables”
Section 13.14, “Information Functions”
Section 6.4.4.3, “Mixed Binary Logging Format”
Section 18.4.1.16, “Replication and System Functions”
Section 18.4.1.8, “Replication of CURRENT_USER()”
Section 14.7.5.12, “SHOW CREATE USER Syntax”
Section 7.2.3, “Specifying Account Names”

CURRENT_USER()

Section 7.2.4, “Access Control, Stage 1: Connection Verification”
Section 14.7.1.1, “ALTER USER Syntax”
Section 14.1.12, “CREATE EVENT Syntax”
Section 14.1.16, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 14.1.18.5, “CREATE TABLE and Generated Columns”
Section 14.1.20, “CREATE TRIGGER Syntax”
Section 14.1.21, “CREATE VIEW Syntax”
Section 9.10.3.1, “How the Query Cache Operates”
Section 26.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 13.14, “Information Functions”
Section 6.4.4.3, “Mixed Binary Logging Format”
Section 7.5.2.2, “Password Validation Plugin Options and Variables”
Section 7.3.9, “Proxy Users”
Section 18.4.1.16, “Replication and System Functions”
Section 18.4.1.8, “Replication of CURRENT_USER()”
Section 14.7.1.7, “SET PASSWORD Syntax”
Section 14.7.5.12, “SHOW CREATE USER Syntax”
Section 7.2.3, “Specifying Account Names”
Section 7.3.11, “SQL-Based MySQL Account Activity Auditing”
Section 26.3.2, “The Keyring Service”
Section 7.5.3.4.2, “Using Keyring Functions”
Section 11.1.12, “UTF-8 for Metadata”
Section 26.2.4.9.1, “Writing the Server-Side Authentication Plugin”

CURTIME()

Section 13.7, “Date and Time Functions”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 11.6, “MySQL Server Time Zone Support”
Section 18.4.1.14, “Replication and Fractional Seconds Support”

D

[index top]

DATABASE()

Section 18.1.6.4, “Binary Logging Options and Variables”
Section 4.3.1, “Creating and Selecting a Database”
Section 14.1.22, “DROP DATABASE Syntax”
Section 4.4, “Getting Information About Databases and Tables”
Section 9.10.3.1, “How the Query Cache Operates”
Section 13.14, “Information Functions”
Section B.5.7, “Known Issues in MySQL”
Section 11.1.12, “UTF-8 for Metadata”

DATE()

Section 13.7, “Date and Time Functions”

DATE_ADD()

Section 13.6.1, “Arithmetic Operators”
Section 14.1.12, “CREATE EVENT Syntax”
Section 13.7, “Date and Time Functions”
Section 12.3, “Date and Time Types”
Section 4.3.4.5, “Date Calculations”
Section 10.5, “Expression Syntax”

DATE_FORMAT()

Section 25.8.18, “C API Prepared Statement Problems”
Section 13.7, “Date and Time Functions”
Section 11.7, “MySQL Server Locale Support”
Section 6.1.4, “Server System Variables”

DATE_SUB()

Section 13.7, “Date and Time Functions”
Section 12.3, “Date and Time Types”

DATEDIFF()

Section 13.7, “Date and Time Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

DAY()

Section 13.7, “Date and Time Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

DAYNAME()

Section 13.7, “Date and Time Functions”
Section 11.7, “MySQL Server Locale Support”
Section 6.1.4, “Server System Variables”

DAYOFMONTH()

Section 13.7, “Date and Time Functions”
Section 4.3.4.5, “Date Calculations”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

DAYOFWEEK()

Section 13.7, “Date and Time Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

DAYOFYEAR()

Section 13.7, “Date and Time Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”
Section 20.2, “Partitioning Types”

DECODE()

Section 13.13, “Encryption and Compression Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 1.4, “What Is New in MySQL 5.7”

decr()

Section 17.3.3.1, “Basic memcached Operations”

DEFAULT()

Section 14.1.8.3, “ALTER TABLE and Generated Columns”
Section 12.7, “Data Type Default Values”
Section 14.2.5, “INSERT Syntax”
Section 13.19, “Miscellaneous Functions”
Section 14.2.8, “REPLACE Syntax”

DEGREES()

Section 13.6.2, “Mathematical Functions”

delete()

Section 17.3.3.1, “Basic memcached Operations”

DES_DECRYPT()

Section 13.13, “Encryption and Compression Functions”
Section 6.1.3, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.7”

DES_ENCRYPT()

Section 13.13, “Encryption and Compression Functions”
Section 6.1.3, “Server Command Options”
Section 1.4, “What Is New in MySQL 5.7”

Dimension()

Section 13.15.7.1, “General Geometry Property Functions”

Disjoint()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 13.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”

Distance()

Section 13.15.9.1, “Spatial Relation Functions That Use Object Shapes”

E

[index top]

ELT()

Section B.5.7, “Known Issues in MySQL”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

ENCODE()

Section 13.13, “Encryption and Compression Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 1.4, “What Is New in MySQL 5.7”

ENCRYPT()

Section 1.9.1, “Contributors to MySQL”
Section 13.13, “Encryption and Compression Functions”
Section 9.10.3.1, “How the Query Cache Operates”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section C.7, “Restrictions on Character Sets”
Section 6.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.7”

EndPoint()

Section 13.15.7.3, “LineString and MultiLineString Property Functions”

Envelope()

Section 13.15.7.1, “General Geometry Property Functions”

Equals()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 13.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”

EXP()

Section 14.1.18, “CREATE TABLE Syntax”
Section 13.6.2, “Mathematical Functions”

EXPORT_SET()

Section 13.5, “String Functions”

expr IN ()

Section 13.3.2, “Comparison Functions and Operators”

expr NOT IN ()

Section 13.3.2, “Comparison Functions and Operators”

ExteriorRing()

Section 13.15.7.4, “Polygon and MultiPolygon Property Functions”

EXTRACT()

Section 13.10, “Cast Functions and Operators”
Section 13.7, “Date and Time Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

ExtractValue()

Section 13.11, “XML Functions”

F

[index top]

FIELD()

Section 13.5, “String Functions”

FIND_IN_SET()

Section 13.5, “String Functions”
Section 12.4.5, “The SET Type”

FLOOR()

Section 13.6.2, “Mathematical Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

flush_all

Section 17.3.3.1, “Basic memcached Operations”

FORMAT()

Section 13.6.2, “Mathematical Functions”
Section 13.19, “Miscellaneous Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 11.7, “MySQL Server Locale Support”
Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

FOUND_ROWS()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 13.14, “Information Functions”
Section 6.4.4.3, “Mixed Binary Logging Format”
Section 18.4.1.16, “Replication and System Functions”

FROM_BASE64()

Section 13.5, “String Functions”

FROM_DAYS()

Section 13.7, “Date and Time Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”

FROM_UNIXTIME()

Section 7.5.4.5, “Audit Log Logging Control”
Section 1.9.1, “Contributors to MySQL”
Section 13.7, “Date and Time Functions”
Section 18.4.1.32, “Replication and Time Zones”

G

[index top]

GeomCollFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

GeomCollFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

GeometryCollection()

Section 13.15.5, “MySQL-Specific Functions That Create Geometry Values”

GeometryCollectionFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

GeometryCollectionFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

GeometryFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

GeometryFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

GeometryN()

Section 13.15.7.5, “GeometryCollection Property Functions”

GeometryType()

Section 13.15.7.1, “General Geometry Property Functions”

GeomFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

GeomFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

get()

Section 17.3.3.1, “Basic memcached Operations”

GET_FORMAT()

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

GET_LOCK

Section B.3, “Server Error Codes and Messages”

GET_LOCK()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section 25.8.16, “Controlling Automatic Reconnection Behavior”
Section 14.1.12, “CREATE EVENT Syntax”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 21.4.1, “Event Scheduler Overview”
Section 9.14.2, “General Thread States”
Section 9.10.3.1, “How the Query Cache Operates”
Section 9.11.1, “Internal Locking Methods”
Section 14.7.6.4, “KILL Syntax”
Section 26.3.1.2.3, “Locking Service Monitoring”
Section 13.19, “Miscellaneous Functions”
Section 25.8.7.3, “mysql_change_user()”
Section 25.8.7.60, “mysql_reset_connection()”
Section 18.4.1.16, “Replication and System Functions”
Section 14.3.5.3, “Table-Locking Restrictions and Conditions”
Section 26.3.1, “The Locking Service”
Section 23.9.12.1, “The metadata_locks Table”
Section 24.4.4.14, “The ps_setup_save() Procedure”

gethostbyaddr()

Section 9.12.6.2, “DNS Lookup Optimization and the Host Cache”

gethostbyaddr_r()

Section 9.12.6.2, “DNS Lookup Optimization and the Host Cache”

gethostbyname()

Section 9.12.6.2, “DNS Lookup Optimization and the Host Cache”

gethostbyname_r()

Section 9.12.6.2, “DNS Lookup Optimization and the Host Cache”

getrusage()

Section 19.5.10.35, “The ndbinfo threadstat Table”

gettimeofday()

Section 19.5.10.35, “The ndbinfo threadstat Table”

GLength()

Section 13.15.7.3, “LineString and MultiLineString Property Functions”

GREATEST()

Section 13.3.2, “Comparison Functions and Operators”
Section 11.1.10.1, “Result Strings”
Section 12.6, “The JSON Data Type”

GROUP_CONCAT()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 9.4.4, “Internal Temporary Table Use in MySQL”
Section B.5.7, “Known Issues in MySQL”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 6.1.4, “Server System Variables”
Section 12.6, “The JSON Data Type”
Section 1.3.2, “The Main Features of MySQL”

GTID_SUBSET()

Section 13.17, “Functions Used with Global Transaction IDs”
Section 18.1.3.1, “GTID Concepts”

GTID_SUBTRACT()

Section 13.17, “Functions Used with Global Transaction IDs”
Section 18.1.6.5, “Global Transaction ID Options and Variables”
Section 18.1.3.1, “GTID Concepts”

H

[index top]

HEX()

Section 11.1.4.5, “Character String Literal Character Set and Collation”
Section 10.1.4, “Hexadecimal Literals”
Section 7.5.3.4.3, “Keyring Function Reference”
Section 13.6.2, “Mathematical Functions”
Section 13.19, “Miscellaneous Functions”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 11.1.10.1, “Result Strings”
Section 2.10.4, “Securing the Initial MySQL Accounts”
Section 13.5, “String Functions”
Section 7.5.3.4.2, “Using Keyring Functions”

HOUR()

Section 13.7, “Date and Time Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

I

[index top]

IF()

Section 13.4, “Control Flow Functions”
Section 14.6.5.2, “IF Syntax”
Section 15.15.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section B.5.7, “Known Issues in MySQL”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 11.1.10.1, “Result Strings”

IFNULL()

Section 13.4, “Control Flow Functions”
Section B.5.4.3, “Problems with NULL Values”

IN

Section 13.3.1, “Operator Precedence”

IN()

Section 9.8.2, “EXPLAIN Output Format”
Section 9.2.1.3.4, “Limiting Memory Use for Range Optimization”
Section 9.3.9, “Optimizer Use of Generated Column Indexes”
Section 9.2.1.3.5, “Range Optimization of Row Constructor Expressions”
Section 9.2.1.20, “Row Constructor Expression Optimization”
Section 12.6, “The JSON Data Type”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 13.2, “Type Conversion in Expression Evaluation”

incr()

Section 17.3.3.1, “Basic memcached Operations”

INET6_ATON()

Section 6.1.8, “IPv6 Support”
Section 13.19, “Miscellaneous Functions”

INET6_NTOA()

Section 6.1.8, “IPv6 Support”
Section 13.19, “Miscellaneous Functions”

INET_ATON()

Section 6.1.8, “IPv6 Support”
Section 13.19, “Miscellaneous Functions”

INET_NTOA()

Section 6.1.8, “IPv6 Support”
Section 13.19, “Miscellaneous Functions”

INSERT()

Section 13.5, “String Functions”

INSTR()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

InteriorRingN()

Section 13.15.7.4, “Polygon and MultiPolygon Property Functions”

Intersects()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 13.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”

INTERVAL()

Section 13.3.2, “Comparison Functions and Operators”

IS_FREE_LOCK()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 13.19, “Miscellaneous Functions”
Section 18.4.1.16, “Replication and System Functions”

IS_IPV4()

Section 13.19, “Miscellaneous Functions”

IS_IPV4_COMPAT()

Section 13.19, “Miscellaneous Functions”

IS_IPV4_MAPPED()

Section 13.19, “Miscellaneous Functions”

IS_IPV6()

Section 13.19, “Miscellaneous Functions”

IS_USED_LOCK()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 13.19, “Miscellaneous Functions”
Section 18.4.1.16, “Replication and System Functions”

IsClosed()

Section 13.15.7.3, “LineString and MultiLineString Property Functions”

IsEmpty()

Section 13.15.7.1, “General Geometry Property Functions”

ISNULL()

Section 13.3.2, “Comparison Functions and Operators”

IsSimple()

Section 13.15.7.1, “General Geometry Property Functions”

J

[index top]

JSON_APPEND()

Section 13.16.4, “Functions That Modify JSON Values”
Section 1.4, “What Is New in MySQL 5.7”

JSON_ARRAY()

Section 13.16.2, “Functions That Create JSON Values”
Section 12.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 5.7”

JSON_ARRAY_APPEND()

Section 13.16.4, “Functions That Modify JSON Values”
Section 1.4, “What Is New in MySQL 5.7”

JSON_ARRAY_INSERT()

Section 13.16.4, “Functions That Modify JSON Values”
Section 1.4, “What Is New in MySQL 5.7”

JSON_CONTAINS()

Section 13.16.3, “Functions That Search JSON Values”
Section 1.4, “What Is New in MySQL 5.7”

JSON_CONTAINS_PATH()

Section 13.16.3, “Functions That Search JSON Values”
Section 13.16.6, “JSON Path Syntax”
Section 1.4, “What Is New in MySQL 5.7”

JSON_DEPTH()

Section 13.16.5, “Functions That Return JSON Value Attributes”
Section 1.4, “What Is New in MySQL 5.7”

JSON_EXTRACT()

Section 13.16.3, “Functions That Search JSON Values”
Section 14.1.18.6, “Secondary Indexes and Generated Virtual Columns”
Section 12.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 5.7”

JSON_INSERT()

Section 13.16.4, “Functions That Modify JSON Values”
Section 12.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 5.7”

JSON_KEYS()

Section 13.16.3, “Functions That Search JSON Values”
Section 1.4, “What Is New in MySQL 5.7”

JSON_LENGTH()

Section 13.16.5, “Functions That Return JSON Value Attributes”
Section 1.4, “What Is New in MySQL 5.7”

JSON_MERGE()

Section 13.16.4, “Functions That Modify JSON Values”
Section 12.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 5.7”

JSON_OBJECT()

Section 13.16.2, “Functions That Create JSON Values”
Section 12.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 5.7”

JSON_QUOTE()

Section 13.16.2, “Functions That Create JSON Values”
Section 1.4, “What Is New in MySQL 5.7”

JSON_REMOVE()

Section 13.16.4, “Functions That Modify JSON Values”
Section 1.4, “What Is New in MySQL 5.7”

JSON_REPLACE()

Section 13.16.4, “Functions That Modify JSON Values”
Section 13.16.6, “JSON Path Syntax”
Section 12.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 5.7”

JSON_SEARCH()

Section 13.16.3, “Functions That Search JSON Values”
Section 13.16.6, “JSON Path Syntax”
Section 1.4, “What Is New in MySQL 5.7”

JSON_SET()

Section 13.16.4, “Functions That Modify JSON Values”
Section 12.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 5.7”

JSON_TYPE()

Section 13.16.5, “Functions That Return JSON Value Attributes”
Section 13.16.3, “Functions That Search JSON Values”
Section 12.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 5.7”

JSON_UNQUOTE(

Section 13.16.3, “Functions That Search JSON Values”

JSON_UNQUOTE()

Section 13.16.4, “Functions That Modify JSON Values”
Section 9.3.9, “Optimizer Use of Generated Column Indexes”
Section 1.4, “What Is New in MySQL 5.7”

JSON_VALID()

Section 13.16.5, “Functions That Return JSON Value Attributes”
Section 1.4, “What Is New in MySQL 5.7”

L

[index top]

LAST_DAY()

Section 13.7, “Date and Time Functions”

LAST_INSERT_ID()

Section 13.3.2, “Comparison Functions and Operators”
Section 25.8.16, “Controlling Automatic Reconnection Behavior”
Section 14.1.18, “CREATE TABLE Syntax”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 25.8.15.3, “How to Get the Unique ID for the Last Inserted Row”
Section 13.14, “Information Functions”
Section 14.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 14.2.5, “INSERT Syntax”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 25.8.7.38, “mysql_insert_id()”
Section 25.8.7.60, “mysql_reset_connection()”
Section 25.8.11.16, “mysql_stmt_insert_id()”
Section 5.6.7.1, “mysqlbinlog Hex Dump Format”
Section 18.4.1.1, “Replication and AUTO_INCREMENT”
Section 18.4.1.16, “Replication and System Functions”
Section 6.1.4, “Server System Variables”
Section 21.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()”
Section 14.3.5.3, “Table-Locking Restrictions and Conditions”
Section 18.4.4, “Troubleshooting Replication”
Section 21.5.3, “Updatable and Insertable Views”
Section 4.6.9, “Using AUTO_INCREMENT”

LCASE()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

LEAST()

Section 13.3.2, “Comparison Functions and Operators”
Section 11.1.10.1, “Result Strings”
Section 12.6, “The JSON Data Type”

LEFT()

Section 13.10, “Cast Functions and Operators”
Section 13.5, “String Functions”

LENGTH()

Section 13.5, “String Functions”

Length()

Section 12.5, “Extensions for Spatial Data”
Section 13.15.7.3, “LineString and MultiLineString Property Functions”

LineFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

LineFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

LineString()

Section 13.15.5, “MySQL-Specific Functions That Create Geometry Values”

LineStringFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

LineStringFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

LN()

Section 13.6.2, “Mathematical Functions”

LOAD_FILE()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 13.18.2, “Enterprise Encryption Usage and Examples”
Section 9.10.3.1, “How the Query Cache Operates”
Section 14.2.7, “LOAD XML Syntax”
Section 6.4.4.3, “Mixed Binary Logging Format”
Section 7.2.1, “Privileges Provided by MySQL”
Section 18.4.1.16, “Replication and System Functions”
Section 6.1.3, “Server Command Options”
Section 6.1.4, “Server System Variables”
Section 13.5, “String Functions”

LOCALTIME

Section 12.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.7, “Date and Time Functions”

LOCALTIME()

Section 12.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.7, “Date and Time Functions”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”

LOCALTIMESTAMP

Section 12.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.7, “Date and Time Functions”

LOCALTIMESTAMP()

Section 12.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.7, “Date and Time Functions”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”

LOCATE()

Section 13.5, “String Functions”

LOG()

Section 20.2.4.1, “LINEAR HASH Partitioning”
Section 13.6.2, “Mathematical Functions”

LOG10()

Section 13.6.2, “Mathematical Functions”

LOG2()

Section 13.6.2, “Mathematical Functions”

LOWER()

Section 13.10, “Cast Functions and Operators”
Section 11.1.8.8, “Collation and INFORMATION_SCHEMA Searches”
Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”
Section 11.1.14.1, “Unicode Character Sets”

LPAD()

Section 13.5, “String Functions”

LTRIM()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

M

[index top]

MAKE_SET()

Section 13.5, “String Functions”

MAKEDATE()

Section 13.7, “Date and Time Functions”

MAKETIME()

Section 13.7, “Date and Time Functions”

MASTER_POS_WAIT()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 14.4.2.1, “CHANGE MASTER TO Syntax”
Section 18.2.3.1, “Commands for Operations on a Single Channel”
Section 18.2.3.2, “Compatibility with Previous Replication Statements”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 13.19, “Miscellaneous Functions”
Section A.13, “MySQL 5.7 FAQ: Replication”

MATCH

Section 10.5, “Expression Syntax”

MATCH ()

Section 13.9, “Full-Text Search Functions”

MATCH()

Section 13.9.2, “Boolean Full-Text Searches”
Section 13.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 13.9.5, “Full-Text Restrictions”
Section 13.9, “Full-Text Search Functions”
Section 15.8.10, “InnoDB FULLTEXT Indexes”
MySQL Glossary
Section 13.9.1, “Natural Language Full-Text Searches”

MAX()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 9.3.1, “How MySQL Uses Indexes”
Section B.5.7, “Known Issues in MySQL”
Section 9.2.1.16.1, “Loose Index Scan”
Section 12.1.1, “Numeric Type Overview”
Section 14.2.10.10, “Optimizing Subqueries”
Section 6.1.7, “Server SQL Modes”
Section 22.32.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 12.6, “The JSON Data Type”
Section 1.3.2, “The Main Features of MySQL”
Section 12.3.8, “Two-Digit Years in Dates”
Section 21.5.3, “Updatable and Insertable Views”
Section 9.2.1.7, “Use of Index Extensions”
Section 4.6.9, “Using AUTO_INCREMENT”
Section 21.5.2, “View Processing Algorithms”

MBRContains()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 13.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 12.5.3.7, “Using Spatial Indexes”

MBRCoveredBy()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”

MBRCovers()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”

MBRDisjoint()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 13.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”

MBREqual()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 1.4, “What Is New in MySQL 5.7”

MBREquals()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 13.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 1.4, “What Is New in MySQL 5.7”

MBRIntersects()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 13.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”

MBROverlaps()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 13.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”

MBRTouches()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”

MBRWithin()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 13.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 12.5.3.7, “Using Spatial Indexes”

MD5()

Section 13.13, “Encryption and Compression Functions”
Section 20.2.5, “KEY Partitioning”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 10.2, “Schema Object Names”
Section 7.1.1, “Security Guidelines”

MICROSECOND()

Section 13.7, “Date and Time Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

MID()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

MIN()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 25.8.18, “C API Prepared Statement Problems”
Section 9.2.1.2, “How MySQL Optimizes WHERE Clauses”
Section 9.3.1, “How MySQL Uses Indexes”
Section B.5.7, “Known Issues in MySQL”
Section 9.2.1.16.1, “Loose Index Scan”
Section 12.1.1, “Numeric Type Overview”
Section 14.2.10.10, “Optimizing Subqueries”
Section B.5.4.3, “Problems with NULL Values”
Section 12.6, “The JSON Data Type”
Section 1.3.2, “The Main Features of MySQL”
Section 12.3.8, “Two-Digit Years in Dates”
Section 21.5.3, “Updatable and Insertable Views”
Section 9.2.1.7, “Use of Index Extensions”
Section 21.5.2, “View Processing Algorithms”

MINUTE()

Section 13.7, “Date and Time Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

MLineFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

MLineFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

MOD()

Section 13.6.1, “Arithmetic Operators”
Section 4.3.4.5, “Date Calculations”
Section 13.6.2, “Mathematical Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 20.6.3, “Partitioning Limitations Relating to Functions”
Section 6.1.7, “Server SQL Modes”

MONTH()

Section 13.7, “Date and Time Functions”
Section 4.3.4.5, “Date Calculations”
Section 20.6.3, “Partitioning Limitations Relating to Functions”
Section 20.2, “Partitioning Types”

MONTHNAME()

Section 13.7, “Date and Time Functions”
Section 11.7, “MySQL Server Locale Support”
Section 6.1.4, “Server System Variables”

MPointFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

MPointFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

MPolyFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

MPolyFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

MultiLineString()

Section 13.15.5, “MySQL-Specific Functions That Create Geometry Values”

MultiLineStringFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

MultiLineStringFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

MultiPoint()

Section 13.15.5, “MySQL-Specific Functions That Create Geometry Values”

MultiPointFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

MultiPointFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

MultiPolygon()

Section 13.15.5, “MySQL-Specific Functions That Create Geometry Values”

MultiPolygonFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

MultiPolygonFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

my_open()

Section 6.1.6, “Server Status Variables”

N

[index top]

NAME_CONST()

Section 21.7, “Binary Logging of Stored Programs”
Section 13.19, “Miscellaneous Functions”

NOT IN()

Section 9.2.1.3.5, “Range Optimization of Row Constructor Expressions”

NOW()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 12.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 14.1.16, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 14.1.18.5, “CREATE TABLE and Generated Columns”
Section 14.1.18, “CREATE TABLE Syntax”
Section 12.7, “Data Type Default Values”
Section 13.7, “Date and Time Functions”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 12.3.6, “Fractional Seconds in Time Values”
Section 9.10.3.1, “How the Query Cache Operates”
Section A.1, “MySQL 5.7 FAQ: General”
Section 11.6, “MySQL Server Time Zone Support”
Section 18.4.1.16, “Replication and System Functions”
Section 18.4.1.32, “Replication and Time Zones”
Section 6.1.3, “Server Command Options”
Section 6.1.4, “Server System Variables”
Section 24.4.3.21, “The metrics View”
Section 24.4.4.25, “The statement_performance_analyzer() Procedure”
Section 12.3.3, “The YEAR Type”
Section 11.6.2, “Time Zone Leap Second Support”

NULLIF()

Section 13.4, “Control Flow Functions”

NumGeometries()

Section 13.15.7.5, “GeometryCollection Property Functions”

NumInteriorRings()

Section 13.15.7.4, “Polygon and MultiPolygon Property Functions”

NumPoints()

Section 13.15.7.3, “LineString and MultiLineString Property Functions”

O

[index top]

OCT()

Section 13.5, “String Functions”

OCTET_LENGTH()

Section 13.5, “String Functions”

OLD_PASSWORD()

Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section B.5.2.4, “Client does not support authentication protocol”
Section 14.7.1.2, “CREATE USER Syntax”
Section 13.13, “Encryption and Compression Functions”
Section 7.1.2.4, “Password Hashing in MySQL”
Section 6.1.4, “Server System Variables”
Section 14.7.1.7, “SET PASSWORD Syntax”
Section 7.5.2, “The Password Validation Plugin”
Section 26.2.1, “Types of Plugins”
Section 1.4, “What Is New in MySQL 5.7”

ORD()

Section 13.5, “String Functions”

Overlaps()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 13.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”

P

[index top]

PASSWORD()

Section 7.3.5, “Assigning Account Passwords”
Section 14.7.1.2, “CREATE USER Syntax”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 13.13, “Encryption and Compression Functions”
Section 9.10.3.1, “How the Query Cache Operates”
Section B.5.2.15, “Ignoring user”
Section 20.2.5, “KEY Partitioning”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 7.1.2.4, “Password Hashing in MySQL”
Section 7.5.2.2, “Password Validation Plugin Options and Variables”
Section 7.1.2.3, “Passwords and Logging”
Section 6.1.4, “Server System Variables”
Section 14.7.1.7, “SET PASSWORD Syntax”
Section 7.5.2, “The Password Validation Plugin”
Section 7.5.1.4, “The SHA-256 Authentication Plugin”
Section 7.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 26.2.1, “Types of Plugins”
Section 1.4, “What Is New in MySQL 5.7”

PERIOD_ADD()

Section 13.7, “Date and Time Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”

PERIOD_DIFF()

Section 13.7, “Date and Time Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”

PI()

Section 10.2.4, “Function Name Parsing and Resolution”
Section 13.6.2, “Mathematical Functions”

Point()

Section 13.15.5, “MySQL-Specific Functions That Create Geometry Values”
Section 12.5.3.1.1, “Well-Known Text (WKT) Format”

PointFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

PointFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

PointN()

Section 13.15.7.3, “LineString and MultiLineString Property Functions”

PolyFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

PolyFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

Polygon()

Section 13.15.5, “MySQL-Specific Functions That Create Geometry Values”

PolygonFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

PolygonFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

POSITION()

Section 13.5, “String Functions”

POW()

Section 20.2.4, “HASH Partitioning”
Section 13.6.2, “Mathematical Functions”

POWER()

Section 20.2.4.1, “LINEAR HASH Partitioning”
Section 13.6.2, “Mathematical Functions”

pthread_mutex()

Section 1.9.1, “Contributors to MySQL”

Q

[index top]

QUARTER()

Section 13.7, “Date and Time Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

QUOTE()

Section 25.8.7.55, “mysql_real_escape_string()”
Section 25.8.7.56, “mysql_real_escape_string_quote()”
Section 13.5, “String Functions”
Section 10.1.1, “String Literals”

R

[index top]

RADIANS()

Section 13.6.2, “Mathematical Functions”

RAND()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 14.1.16, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 13.6.2, “Mathematical Functions”
Section 5.6.7.1, “mysqlbinlog Hex Dump Format”
Section 18.4.1.16, “Replication and System Functions”
Section 6.1.4, “Server System Variables”

RANDOM_BYTES()

Section 13.13, “Encryption and Compression Functions”
Section 9.10.3.1, “How the Query Cache Operates”

RELEASE_ALL_LOCKS()

Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.7”
Section 9.10.3.1, “How the Query Cache Operates”
Section 13.19, “Miscellaneous Functions”

RELEASE_LOCK()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 14.2.3, “DO Syntax”
Section 9.10.3.1, “How the Query Cache Operates”
Section 9.11.1, “Internal Locking Methods”
Section 13.19, “Miscellaneous Functions”
Section 18.4.1.16, “Replication and System Functions”
Section 14.3.5.3, “Table-Locking Restrictions and Conditions”

REPEAT()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

REPLACE()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

replace()

Section 17.3.3.1, “Basic memcached Operations”

REVERSE()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

RIGHT()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

ROUND()

Section 15.15.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section 13.6.2, “Mathematical Functions”
Section 13.21, “Precision Math”
Section 13.21.5, “Precision Math Examples”
Section 13.21.4, “Rounding Behavior”

ROW_COUNT()

Section 14.2.1, “CALL Syntax”
Section 14.2.2, “DELETE Syntax”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 14.6.7.7.2, “Diagnostics Area Information Items”
Section 13.14, “Information Functions”
Section 14.2.5, “INSERT Syntax”
Section 6.4.4.3, “Mixed Binary Logging Format”
Section 25.8.7.1, “mysql_affected_rows()”
Section 18.4.1.16, “Replication and System Functions”

RPAD()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

RTRIM()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

S

[index top]

SCHEMA()

Section 13.14, “Information Functions”

SEC_TO_TIME()

Section 13.7, “Date and Time Functions”

SECOND()

Section 13.7, “Date and Time Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

SESSION_USER()

Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 13.14, “Information Functions”
Section 11.1.12, “UTF-8 for Metadata”

set()

Section 17.3.3.1, “Basic memcached Operations”

setrlimit()

Section 6.1.3, “Server Command Options”

SHA()

Section 13.13, “Encryption and Compression Functions”

SHA1()

Section 13.13, “Encryption and Compression Functions”
Section 7.1.1, “Security Guidelines”

SHA2()

Section 13.13, “Encryption and Compression Functions”
Section 7.1.1, “Security Guidelines”

SIGN()

Section 13.6.2, “Mathematical Functions”

SIN()

Section 13.6.2, “Mathematical Functions”
Section 26.4.2.3, “UDF Argument Processing”

SLEEP()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.14.2, “General Thread States”
Section 9.10.3.1, “How the Query Cache Operates”
Section 13.19, “Miscellaneous Functions”
Section 18.4.1, “Replication Features and Issues”
Section 22.32.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”

SOUNDEX()

Section 26.4, “Adding New Functions to MySQL”
Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

SPACE()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

SQRT()

Section 13.6.2, “Mathematical Functions”

SRID()

Section 13.15.7.1, “General Geometry Property Functions”

ST_Area()

Section 13.15.7, “Geometry Property Functions”
Section 13.15.7.4, “Polygon and MultiPolygon Property Functions”

ST_AsBinary()

Section 12.5.3.4, “Fetching Spatial Data”
Section 13.15.6, “Geometry Format Conversion Functions”

ST_AsGeoJSON()

Section 13.15.11, “Spatial GeoJSON Functions”
Section 12.6, “The JSON Data Type”

ST_AsText()

Section 12.5.3.4, “Fetching Spatial Data”
Section 13.15.6, “Geometry Format Conversion Functions”

ST_AsWKB()

Section 13.15.6, “Geometry Format Conversion Functions”

ST_AsWKT()

Section 13.15.6, “Geometry Format Conversion Functions”

ST_Buffer()

Section 13.15.8, “Spatial Operator Functions”

ST_Buffer_Strategy()

Section 6.1.4, “Server System Variables”
Section 13.15.8, “Spatial Operator Functions”

ST_Centroid()

Section 13.15.7.4, “Polygon and MultiPolygon Property Functions”

ST_Contains()

Section 13.15.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_ConvexHull()

Section 13.15.8, “Spatial Operator Functions”

ST_Crosses()

Section 13.15.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_Difference()

Section 13.15.8, “Spatial Operator Functions”

ST_Dimension()

Section 13.15.7.1, “General Geometry Property Functions”

ST_Disjoint()

Section 13.15.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_Distance()

Section 13.15.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_Distance_Sphere()

Section 13.15.12, “Spatial Convenience Functions”

ST_EndPoint()

Section 13.15.7.3, “LineString and MultiLineString Property Functions”
Section 13.15.8, “Spatial Operator Functions”

ST_Envelope()

Section 13.15.7.1, “General Geometry Property Functions”
Section 13.15.8, “Spatial Operator Functions”

ST_Equals()

Section 13.15.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_ExteriorRing()

Section 13.15.7.4, “Polygon and MultiPolygon Property Functions”
Section 13.15.8, “Spatial Operator Functions”

ST_GeoHash()

Section 13.15.10, “Spatial Geohash Functions”

ST_GeomCollFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_GeomCollFromTxt()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_GeomCollFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_GeometryCollectionFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_GeometryCollectionFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_GeometryFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_GeometryFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_GeometryN()

Section 13.15.7.5, “GeometryCollection Property Functions”
Section 13.15.8, “Spatial Operator Functions”

ST_GeometryType()

Section 13.15.7.1, “General Geometry Property Functions”

ST_GeomFromGeoJSON()

Section 13.15.11, “Spatial GeoJSON Functions”
Section 12.6, “The JSON Data Type”

ST_GeomFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”
Section 12.5.3.3, “Populating Spatial Columns”
Section 12.5.3.1.1, “Well-Known Text (WKT) Format”

ST_GeomFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_InteriorRingN()

Section 13.15.7.4, “Polygon and MultiPolygon Property Functions”
Section 13.15.8, “Spatial Operator Functions”

ST_Intersection()

Section 13.15.8, “Spatial Operator Functions”

ST_Intersects()

Section 13.15.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_IsClosed()

Section 13.15.7.3, “LineString and MultiLineString Property Functions”

ST_IsEmpty()

Section 13.15.7.1, “General Geometry Property Functions”

ST_IsSimple()

Section 13.15.7.1, “General Geometry Property Functions”

ST_IsValid()

Section 13.15.12, “Spatial Convenience Functions”

ST_LatFromGeoHash()

Section 13.15.10, “Spatial Geohash Functions”

ST_Length()

Section 12.5, “Extensions for Spatial Data”
Section 13.15.7.3, “LineString and MultiLineString Property Functions”
Section 13.5, “String Functions”

ST_LineFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_LineFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_LineStringFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_LineStringFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_LongFromGeoHash()

Section 13.15.10, “Spatial Geohash Functions”

ST_MakeEnvelope()

Section 13.15.12, “Spatial Convenience Functions”

ST_MLineFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_MLineFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_MPointFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”
Section 12.5.3.1.1, “Well-Known Text (WKT) Format”

ST_MPointFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_MPolyFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_MPolyFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_MultiLineStringFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_MultiLineStringFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_MultiPointFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_MultiPointFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_MultiPolygonFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_MultiPolygonFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_NumGeometries()

Section 13.15.7.5, “GeometryCollection Property Functions”

ST_NumInteriorRing()

Section 13.15.7.4, “Polygon and MultiPolygon Property Functions”

ST_NumInteriorRings()

Section 13.15.7.4, “Polygon and MultiPolygon Property Functions”

ST_NumPoints()

Section 13.15.7.3, “LineString and MultiLineString Property Functions”

ST_Overlaps()

Section 13.15.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_PointFromGeoHash()

Section 13.15.10, “Spatial Geohash Functions”

ST_PointFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_PointFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_PointN()

Section 13.15.7.3, “LineString and MultiLineString Property Functions”
Section 13.15.8, “Spatial Operator Functions”

ST_PolyFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_PolyFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_PolygonFromText()

Section 13.15.3, “Functions That Create Geometry Values from WKT Values”

ST_PolygonFromWKB()

Section 13.15.4, “Functions That Create Geometry Values from WKB Values”

ST_Simplify()

Section 13.15.12, “Spatial Convenience Functions”

ST_SRID()

Section 13.15.7.1, “General Geometry Property Functions”

ST_StartPoint()

Section 13.15.7.3, “LineString and MultiLineString Property Functions”
Section 13.15.8, “Spatial Operator Functions”

ST_SymDifference()

Section 13.15.8, “Spatial Operator Functions”

ST_Touches()

Section 13.15.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_Union()

Section 13.15.8, “Spatial Operator Functions”

ST_Validate()

Section 13.15.12, “Spatial Convenience Functions”

ST_Within()

Section 13.15.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_X()

Section 13.15.7.2, “Point Property Functions”

ST_Y()

Section 13.15.7.2, “Point Property Functions”

StartPoint()

Section 13.15.7.3, “LineString and MultiLineString Property Functions”

STD()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 1.3.2, “The Main Features of MySQL”

STDDEV()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”

STDDEV_POP()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”

STDDEV_SAMP()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”

STR_TO_DATE()

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

STRCMP()

Section B.5.4.2, “Problems Using DATE Columns”
Section 13.5.1, “String Comparison Functions”

SUBDATE()

Section 13.7, “Date and Time Functions”

SUBSTR()

Section 13.5, “String Functions”

SUBSTRING()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

SUBSTRING_INDEX()

Section 7.3.11, “SQL-Based MySQL Account Activity Auditing”
Section 13.5, “String Functions”

SUBTIME()

Section 13.7, “Date and Time Functions”

SUM()

Section 26.4.2, “Adding a New User-Defined Function”
Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 12.1.2, “Date and Time Type Overview”
Section 9.2.1.16.1, “Loose Index Scan”
Section 13.19, “Miscellaneous Functions”
Section 20.1, “Overview of Partitioning in MySQL”
Section B.5.4.3, “Problems with NULL Values”
Section 12.4.4, “The ENUM Type”
Section 1.3.2, “The Main Features of MySQL”
Section 12.4.5, “The SET Type”
Section 21.5.3, “Updatable and Insertable Views”
Section 21.5.2, “View Processing Algorithms”

SYSDATE()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 13.7, “Date and Time Functions”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 18.4.1.14, “Replication and Fractional Seconds Support”
Section 18.4.1.16, “Replication and System Functions”
Section 6.1.3, “Server Command Options”
Section 6.1.4, “Server System Variables”

SYSTEM_USER()

Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 13.14, “Information Functions”
Section 11.1.12, “UTF-8 for Metadata”

T

[index top]

TAN()

Section 13.6.2, “Mathematical Functions”

thr_setconcurrency()

Section 6.1.4, “Server System Variables”

TIME()

Section 13.7, “Date and Time Functions”

TIME_FORMAT()

Section 13.7, “Date and Time Functions”

TIME_TO_SEC()

Section 13.7, “Date and Time Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”

TIMEDIFF()

Section 13.7, “Date and Time Functions”

TIMESTAMP()

Section 13.7, “Date and Time Functions”

TIMESTAMPADD()

Section 13.7, “Date and Time Functions”

TIMESTAMPDIFF()

Section 13.7, “Date and Time Functions”
Section 4.3.4.5, “Date Calculations”

TO_BASE64()

Section 13.5, “String Functions”

TO_DAYS()

Section 13.7, “Date and Time Functions”
Section 20.2.4, “HASH Partitioning”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 20.4, “Partition Pruning”
Section 20.6.3, “Partitioning Limitations Relating to Functions”
Section 20.2, “Partitioning Types”

TO_SECONDS()

Section 13.7, “Date and Time Functions”
Section 20.4, “Partition Pruning”
Section 20.6.3, “Partitioning Limitations Relating to Functions”
Section 20.2, “Partitioning Types”

Touches()

Section 13.15.9.1, “Spatial Relation Functions That Use Object Shapes”

TRIM()

Section 11.1.13, “Column Character Set Conversion”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

TRUNCATE()

Section 13.6.2, “Mathematical Functions”

U

[index top]

UCASE()

Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”

UNCOMPRESS()

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

UNCOMPRESSED_LENGTH()

Section 13.13, “Encryption and Compression Functions”

UNHEX()

Section 13.13, “Encryption and Compression Functions”
Section 13.5, “String Functions”

UNIX_TIMESTAMP()

Section 13.7, “Date and Time Functions”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 20.6.3, “Partitioning Limitations Relating to Functions”
Section 20.2.1, “RANGE Partitioning”
Section 6.1.4, “Server System Variables”
Section 24.4.3.21, “The metrics View”
Section B.5.3.7, “Time Zone Problems”

UpdateXML()

Section 13.11, “XML Functions”

UPPER()

Section 13.10, “Cast Functions and Operators”
Section 11.1.8.8, “Collation and INFORMATION_SCHEMA Searches”
Section 11.1.10.1, “Result Strings”
Section 13.5, “String Functions”
Section 11.1.9, “String Repertoire”
Section 11.1.14.1, “Unicode Character Sets”

USER()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 14.7.1.1, “ALTER USER Syntax”
Section 11.1.8.4, “Collation of Expressions”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 26.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 13.14, “Information Functions”
Section 6.4.4.3, “Mixed Binary Logging Format”
Section 7.5.2.2, “Password Validation Plugin Options and Variables”
Section 7.3.9, “Proxy Users”
Section 18.4.1.16, “Replication and System Functions”
Section 7.3.11, “SQL-Based MySQL Account Activity Auditing”
Section 11.1.12, “UTF-8 for Metadata”
Section 26.2.4.9.1, “Writing the Server-Side Authentication Plugin”

UTC_DATE

Section 13.7, “Date and Time Functions”

UTC_DATE()

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

UTC_TIME

Section 13.7, “Date and Time Functions”

UTC_TIME()

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

UTC_TIMESTAMP

Section 13.7, “Date and Time Functions”

UTC_TIMESTAMP()

Section 13.7, “Date and Time Functions”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 11.6, “MySQL Server Time Zone Support”
Section 18.4.1.14, “Replication and Fractional Seconds Support”

UUID()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 21.7, “Binary Logging of Stored Programs”
Section 18.1.6.4, “Binary Logging Options and Variables”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 13.19, “Miscellaneous Functions”
Section 6.4.4.3, “Mixed Binary Logging Format”
Section 18.4.1.16, “Replication and System Functions”
Section 6.4.4.2, “Setting The Binary Log Format”

UUID_SHORT()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 18.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 9.10.3.1, “How the Query Cache Operates”
Section 13.19, “Miscellaneous Functions”

V

[index top]

VALIDATE_PASSWORD_STRENGTH()

Section 13.13, “Encryption and Compression Functions”
Section 7.5.2.2, “Password Validation Plugin Options and Variables”
Section 7.5.2, “The Password Validation Plugin”
Section 26.2.1, “Types of Plugins”

VALUES()

Section 14.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 13.19, “Miscellaneous Functions”

VAR_POP()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”

VAR_SAMP()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”

VARIANCE()

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”

VERSION()

Section 18.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section B.5.4.1, “Case Sensitivity in String Searches”
Section 11.1.8.4, “Collation of Expressions”
Section 13.14, “Information Functions”
Section 18.4.1.16, “Replication and System Functions”
Section 7.5.4.4, “The Audit Log File”
Section 11.1.12, “UTF-8 for Metadata”

W

[index top]

WAIT_FOR_EXECUTED_GTID_SET()

Section 18.2.3.2, “Compatibility with Previous Replication Statements”
Section 13.17, “Functions Used with Global Transaction IDs”
Section 18.1.5.1, “Replication Mode Concepts”

WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()

Section 18.2.3.1, “Commands for Operations on a Single Channel”
Section 18.2.3.2, “Compatibility with Previous Replication Statements”
Section 13.17, “Functions Used with Global Transaction IDs”

WEEK()

Section 13.7, “Date and Time Functions”
Section 6.1.4, “Server System Variables”

WEEKDAY()

Section 13.7, “Date and Time Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 20.6.3, “Partitioning Limitations Relating to Functions”
Section 20.2, “Partitioning Types”

WEEKOFYEAR()

Section 13.7, “Date and Time Functions”

WEIGHT_STRING()

Section 11.4, “Adding a Collation to a Character Set”
Section B.5.4.1, “Case Sensitivity in String Searches”
Section 13.5, “String Functions”
Section 11.1.14.1, “Unicode Character Sets”

Within()

Section 13.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 13.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”

X

[index top]

X()

Section 13.15.7.2, “Point Property Functions”

Y

[index top]

Y()

Section 13.15.7.2, “Point Property Functions”

YEAR()

Section 13.7, “Date and Time Functions”
Section 4.3.4.5, “Date Calculations”
Section 20.2.4, “HASH Partitioning”
Section 20.2.7, “How MySQL Partitioning Handles NULL”
Section 20.3.1, “Management of RANGE and LIST Partitions”
Section 20.4, “Partition Pruning”
Section 20.6.3, “Partitioning Limitations Relating to Functions”
Section 20.2, “Partitioning Types”
Section 20.2.1, “RANGE Partitioning”

YEARWEEK()

Section 13.7, “Date and Time Functions”
Section 20.6.3, “Partitioning Limitations Relating to Functions”