Function Index
Prev   Next

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 25.4, “Adding New Functions to MySQL”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 12.6.2, “Mathematical Functions”
Section 19.6.3, “Partitioning Limitations Relating to Functions”

ACOS()

Section 12.6.2, “Mathematical Functions”

add()

Section 16.3.3.1, “Basic memcached Operations”

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”
Section 12.18.4, “Enterprise Encryption Function Descriptions”
Section 8.10.3.1, “How the Query Cache Operates”
Section 6.3.11.1, “OpenSSL Versus yaSSL”
Section 5.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.7”

AES_ENCRYPT()

Section 12.13, “Encryption and Compression Functions”
Section 12.18.4, “Enterprise Encryption Function Descriptions”
Section 8.10.3.1, “How the Query Cache Operates”
Section 6.3.11.1, “OpenSSL Versus yaSSL”
Section 5.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 12.19, “Miscellaneous Functions”
Section 12.20.3, “MySQL Handling of GROUP BY”
Section 5.1.7, “Server SQL Modes”

Area()

Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”

AsBinary()

Section 12.15.6, “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.15.6, “Geometry Format Conversion Functions”

AsWKB()

Section 12.15.6, “Geometry Format Conversion Functions”

AsWKT()

Section 12.15.6, “Geometry Format Conversion Functions”

ASYMMETRIC_DECRYPT()

Section 12.18.4, “Enterprise Encryption Function Descriptions”

ASYMMETRIC_DERIVE()

Section 12.18.4, “Enterprise Encryption Function Descriptions”

ASYMMETRIC_ENCRYPT()

Section 12.18.4, “Enterprise Encryption Function Descriptions”

ASYMMETRIC_SIGN()

Section 12.18.4, “Enterprise Encryption Function Descriptions”

ASYMMETRIC_VERIFY()

Section 12.18.4, “Enterprise Encryption Function Descriptions”

ATAN()

Section 12.6.2, “Mathematical Functions”

ATAN2()

Section 12.6.2, “Mathematical Functions”

AVG()

Section 11.1.2, “Date and Time Type Overview”
Section 12.20.1, “GROUP BY (Aggregate) Function Descriptions”
Section 8.2.1.16.1, “Loose Index Scan”
Section 11.4.4, “The ENUM Type”
Section 1.3.2, “The Main Features of MySQL”
Section 11.4.5, “The SET Type”

B

[index top]

BENCHMARK()

Section 8.10.3.1, “How the Query Cache Operates”
Section 12.14, “Information Functions”
Section 8.13.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.12, “Bit Functions and Operators”
Section 12.20.1, “GROUP BY (Aggregate) Function Descriptions”
Section 1.8.1, “MySQL Extensions to Standard SQL”

BIT_COUNT()

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

BIT_LENGTH()

Section 12.5, “String Functions”

BIT_OR()

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

BIT_XOR()

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

Buffer()

Section 12.15.8, “Spatial Operator Functions”

C

[index top]

CAST()

Section 12.12, “Bit Functions and Operators”
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 10.1.9.2, “CONVERT() and CAST()”
Section 12.7, “Date and Time Functions”
Section 12.16.2, “Functions That Create JSON Values”
Section 9.1.4, “Hexadecimal Literals”
Section 1.8.2, “MySQL Differences from Standard SQL”
Section 10.1.9.1, “Result Strings”
Section 10.1.7.7, “The BINARY Operator”
Section 11.6, “The JSON Data Type”
Section 12.2, “Type Conversion in Expression Evaluation”
Section 9.4, “User-Defined Variables”

CEIL()

Section 12.6.2, “Mathematical Functions”

CEILING()

Section 19.2.4.1, “LINEAR HASH Partitioning”
Section 12.6.2, “Mathematical Functions”
Section 19.6.3, “Partitioning Limitations Relating to Functions”

Centroid()

Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”

CHAR()

Section 12.10, “Cast Functions and Operators”
Section 12.13, “Encryption and Compression Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.5, “String Functions”

CHAR_LENGTH()

Section 12.5, “String Functions”
Section 10.1.14.1, “Unicode Character Sets”

CHARACTER_LENGTH()

Section 12.5, “String Functions”

CHARSET()

Section 12.14, “Information Functions”
Section 10.1.9.1, “Result Strings”

COALESCE()

Section 12.3.2, “Comparison Functions and Operators”
Section 13.2.9.2, “JOIN Syntax”

COERCIBILITY()

Section 10.1.7.5, “Collation of Expressions”
Section 12.14, “Information Functions”

COLLATION()

Section B.5.4.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 12.10, “Cast Functions and Operators”
Section 10.1.7.5, “Collation of Expressions”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 12.20.1, “GROUP BY (Aggregate) Function Descriptions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 10.1.9.1, “Result Strings”
Section 5.1.7, “Server SQL Modes”
Section 13.7.5.13, “SHOW CREATE VIEW Syntax”
Section 12.5, “String Functions”
Section 10.1.8, “String Repertoire”
Section 21.30, “The INFORMATION_SCHEMA VIEWS Table”
Section 12.2, “Type Conversion in Expression Evaluation”
Section 12.11, “XML Functions”

CONCAT_WS()

Section 12.20.1, “GROUP BY (Aggregate) Function Descriptions”
Section 12.5, “String Functions”

CONNECTION_ID()

Section 13.1.18, “CREATE TABLE Syntax”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.14, “Information Functions”
Section 13.7.6.4, “KILL Syntax”
Section 4.5.1.3, “mysql Logging”
Section 13.7.5.29, “SHOW PROCESSLIST Syntax”
Section 6.4.4.3, “The Audit Log File”
Section 22.9.15.3, “The threads Table”

Contains()

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

CONV()

Section 12.6.2, “Mathematical Functions”
Section 10.1.9.1, “Result Strings”
Section 12.5, “String Functions”

CONVERT()

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”
Section 10.1.9.2, “CONVERT() and CAST()”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”

CONVERT_TZ()

Section 12.7, “Date and Time Functions”
Section 8.10.3.1, “How the Query Cache Operates”
Section 5.1.4, “Server System Variables”
Section 13.3.5.3, “Table-Locking Restrictions and Conditions”
Section 5.2.3, “The General Query Log”
Section 5.2.5, “The Slow Query Log”

ConvexHull()

Section 12.15.8, “Spatial Operator Functions”

COS()

Section 12.6.2, “Mathematical Functions”

COT()

Section 12.6.2, “Mathematical Functions”

COUNT()

Section 3.3.4.8, “Counting Rows”
Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 12.20.1, “GROUP BY (Aggregate) Function Descriptions”
Section 8.2.1.2, “How MySQL Optimizes WHERE Clauses”
Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 18.1.6.3, “Limits Relating to Transaction Handling in MySQL Cluster”
Section 8.2.1.16.1, “Loose Index Scan”
Section 12.19, “Miscellaneous Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 19.1, “Overview of Partitioning in MySQL”
Section B.5.4.3, “Problems with NULL Values”
Section 5.1.7, “Server SQL Modes”
Section 1.3.2, “The Main Features of MySQL”
Section 20.5.3, “Updatable and Insertable Views”
Section 20.5.2, “View Processing Algorithms”

CRC32()

Section 12.6.2, “Mathematical Functions”

CREATE_ASYMMETRIC_PRIV_KEY()

Section 12.18.4, “Enterprise Encryption Function Descriptions”
Section 12.18.2, “Enterprise Encryption Usage and Examples”

CREATE_ASYMMETRIC_PUB_KEY()

Section 12.18.4, “Enterprise Encryption Function Descriptions”

CREATE_DH_PARAMETERS()

Section 12.18.4, “Enterprise Encryption Function Descriptions”
Section 12.18.2, “Enterprise Encryption Usage and Examples”

CREATE_DIGEST()

Section 12.18.4, “Enterprise Encryption Function Descriptions”

Crosses()

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

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 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”

CURRENT_DATE

Section 13.1.18, “CREATE TABLE Syntax”
Section 11.7, “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 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.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 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”

CURRENT_TIMESTAMP

Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.1.12, “CREATE EVENT Syntax”
Section 13.1.18, “CREATE TABLE Syntax”
Section 11.7, “Data Type Default Values”
Section 12.7, “Date and Time Functions”

CURRENT_TIMESTAMP()

Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 12.7, “Date and Time Functions”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”

CURRENT_USER

Section 20.6, “Access Control for Stored Programs and Views”
Section 13.7.1.1, “ALTER USER Syntax”
Section 13.1.12, “CREATE EVENT Syntax”
Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.20, “CREATE TRIGGER Syntax”
Section 13.1.21, “CREATE VIEW Syntax”
Section 12.14, “Information Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 6.2.2, “Privilege System Grant Tables”
Section 17.4.1.16, “Replication and System Functions”
Section 17.4.1.8, “Replication of CURRENT_USER()”
Section 13.7.5.12, “SHOW CREATE USER Syntax”
Section 6.2.3, “Specifying Account Names”

CURRENT_USER()

Section 6.2.4, “Access Control, Stage 1: Connection Verification”
Section 13.7.1.1, “ALTER USER Syntax”
Section 13.1.12, “CREATE EVENT Syntax”
Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.18, “CREATE TABLE Syntax”
Section 13.1.20, “CREATE TRIGGER Syntax”
Section 13.1.21, “CREATE VIEW Syntax”
Section 8.10.3.1, “How the Query Cache Operates”
Section 25.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.9, “Proxy Users”
Section 17.4.1.16, “Replication and System Functions”
Section 17.4.1.8, “Replication of CURRENT_USER()”
Section 13.7.1.7, “SET PASSWORD Syntax”
Section 13.7.5.12, “SHOW CREATE USER Syntax”
Section 6.2.3, “Specifying Account Names”
Section 6.3.14, “SQL-Based MySQL Account Activity Auditing”
Section 10.1.12, “UTF-8 for Metadata”
Section 25.2.4.9.1, “Writing the Server-Side Authentication Plugin”

CURTIME()

Section 12.7, “Date and Time Functions”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 10.6, “MySQL Server Time Zone Support”
Section 17.4.1.14, “Replication and Fractional Seconds Support”

D

[index top]

DATABASE()

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 3.3.1, “Creating and Selecting a Database”
Section 13.1.22, “DROP DATABASE Syntax”
Section 3.4, “Getting Information About Databases and Tables”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.14, “Information Functions”
Section B.5.7, “Known Issues in MySQL”
Section 10.1.12, “UTF-8 for Metadata”

DATE()

Section 12.7, “Date and Time Functions”

DATE_ADD()

Section 12.6.1, “Arithmetic Operators”
Section 13.1.12, “CREATE EVENT Syntax”
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 24.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 19.6.3, “Partitioning Limitations Relating to Functions”

DAY()

Section 12.7, “Date and Time Functions”
Section 19.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 19.6.3, “Partitioning Limitations Relating to Functions”

DAYOFWEEK()

Section 12.7, “Date and Time Functions”
Section 19.6.3, “Partitioning Limitations Relating to Functions”

DAYOFYEAR()

Section 12.7, “Date and Time Functions”
Section 19.6.3, “Partitioning Limitations Relating to Functions”
Section 19.2, “Partitioning Types”

DECODE()

Section 12.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 16.3.3.1, “Basic memcached Operations”

DEFAULT()

Section 11.7, “Data Type Default Values”
Section 13.2.5, “INSERT Syntax”
Section 12.19, “Miscellaneous Functions”
Section 13.2.8, “REPLACE Syntax”

DEGREES()

Section 12.6.2, “Mathematical Functions”

delete()

Section 16.3.3.1, “Basic memcached Operations”

DES_DECRYPT()

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

DES_ENCRYPT()

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

Dimension()

Section 12.15.7.1, “General Geometry Property Functions”

Disjoint()

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

Distance()

Section 12.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 10.1.9.1, “Result Strings”
Section 12.5, “String Functions”

ENCODE()

Section 12.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 12.13, “Encryption and Compression Functions”
Section 8.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 5.1.4, “Server System Variables”
Section 1.4, “What Is New in MySQL 5.7”

EndPoint()

Section 12.15.7.3, “LineString and MultiLineString Property Functions”

Envelope()

Section 12.15.7.1, “General Geometry Property Functions”

Equals()

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

EXP()

Section 13.1.18, “CREATE TABLE Syntax”
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.15.7.4, “Polygon and MultiPolygon Property Functions”

EXTRACT()

Section 12.10, “Cast Functions and Operators”
Section 12.7, “Date and Time Functions”
Section 19.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.2, “Mathematical Functions”
Section 19.6.3, “Partitioning Limitations Relating to Functions”

flush_all

Section 16.3.3.1, “Basic memcached Operations”

FORMAT()

Section 12.6.2, “Mathematical Functions”
Section 12.19, “Miscellaneous Functions”
Section 1.8.1, “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 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.14, “Information Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 17.4.1.16, “Replication and System Functions”

FROM_BASE64()

Section 12.5, “String Functions”

FROM_DAYS()

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

FROM_UNIXTIME()

Section 6.4.4.4, “Audit Log Plugin Logging Control”
Section 1.9.1, “Contributors to MySQL”
Section 12.7, “Date and Time Functions”
Section 17.4.1.32, “Replication and Time Zones”

G

[index top]

GeomCollFromText()

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

GeomCollFromWKB()

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

GeometryCollection()

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

GeometryCollectionFromText()

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

GeometryCollectionFromWKB()

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

GeometryFromText()

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

GeometryFromWKB()

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

GeometryN()

Section 12.15.7.5, “GeometryCollection Property Functions”

GeometryType()

Section 12.15.7.1, “General Geometry Property Functions”

GeomFromText()

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

GeomFromWKB()

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

get()

Section 16.3.3.1, “Basic memcached Operations”

GET_FORMAT()

Section 12.7, “Date and Time Functions”
Section 10.7, “MySQL Server Locale Support”

GET_LOCK

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

GET_LOCK()

Section 17.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 24.8.16, “Controlling Automatic Reconnection Behavior”
Section 13.1.12, “CREATE EVENT Syntax”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 20.4.1, “Event Scheduler Overview”
Section 8.14.2, “General Thread States”
Section 8.10.3.1, “How the Query Cache Operates”
Section 8.11.1, “Internal Locking Methods”
Section 13.7.6.4, “KILL Syntax”
Section 25.3.1.2.3, “Locking Service Monitoring”
Section 12.19, “Miscellaneous Functions”
Section 24.8.7.3, “mysql_change_user()”
Section 24.8.7.60, “mysql_reset_connection()”
Section 17.4.1.16, “Replication and System Functions”
Section 13.3.5.3, “Table-Locking Restrictions and Conditions”
Section 25.3.1, “The Locking Service”
Section 22.9.11.1, “The metadata_locks Table”
Section 23.4.4.14, “The ps_setup_save() Procedure”

gethostbyaddr()

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

gethostbyaddr_r()

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

gethostbyname()

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

gethostbyname_r()

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

getrusage()

Section 18.5.10.27, “The ndbinfo threadstat Table”

gettimeofday()

Section 18.5.10.27, “The ndbinfo threadstat Table”

GLength()

Section 12.15.7.3, “LineString and MultiLineString Property Functions”

GREATEST()

Section 12.3.2, “Comparison Functions and Operators”
Section 10.1.9.1, “Result Strings”
Section 11.6, “The JSON Data Type”

GROUP_CONCAT()

Section 12.20.1, “GROUP BY (Aggregate) Function Descriptions”
Section 8.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 5.1.4, “Server System Variables”
Section 11.6, “The JSON Data Type”
Section 1.3.2, “The Main Features of MySQL”

GTID_SUBSET()

Section 12.17, “Functions Used with Global Transaction IDs”
Section 17.1.3.1, “GTID Concepts”

GTID_SUBTRACT()

Section 12.17, “Functions Used with Global Transaction IDs”
Section 17.1.6.5, “Global Transaction ID Options and Variables”
Section 17.1.3.1, “GTID Concepts”

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 12.19, “Miscellaneous Functions”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 10.1.9.1, “Result Strings”
Section 2.10.4, “Securing the Initial MySQL Accounts”
Section 12.5, “String Functions”

HOUR()

Section 12.7, “Date and Time Functions”
Section 19.6.3, “Partitioning Limitations Relating to Functions”

I

[index top]

IF()

Section 12.4, “Control Flow Functions”
Section 13.6.5.2, “IF Syntax”
Section 14.13.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section B.5.7, “Known Issues in MySQL”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 10.1.9.1, “Result Strings”

IFNULL()

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

IN

Section 12.3.1, “Operator Precedence”

IN()

Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.3.4, “Limiting Memory Use for Range Optimization”
Section 8.3.9, “Optimizer Use of Generated Column Indexes”
Section 8.2.1.3.5, “Range Optimization of Row Constructor Expressions”
Section 8.2.1.20, “Row Constructor Expression Optimization”
Section 11.6, “The JSON Data Type”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 12.2, “Type Conversion in Expression Evaluation”

incr()

Section 16.3.3.1, “Basic memcached Operations”

INET6_ATON()

Section 5.1.9, “IPv6 Support”
Section 12.19, “Miscellaneous Functions”

INET6_NTOA()

Section 5.1.9, “IPv6 Support”
Section 12.19, “Miscellaneous Functions”

INET_ATON()

Section 5.1.9, “IPv6 Support”
Section 12.19, “Miscellaneous Functions”

INET_NTOA()

Section 5.1.9, “IPv6 Support”
Section 12.19, “Miscellaneous Functions”

INSERT()

Section 12.5, “String Functions”

INSTR()

Section 10.1.9.1, “Result Strings”
Section 12.5, “String Functions”

InteriorRingN()

Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”

Intersects()

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

INTERVAL()

Section 12.3.2, “Comparison Functions and Operators”

IS_FREE_LOCK()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.19, “Miscellaneous Functions”
Section 17.4.1.16, “Replication and System Functions”

IS_IPV4()

Section 12.19, “Miscellaneous Functions”

IS_IPV4_COMPAT()

Section 12.19, “Miscellaneous Functions”

IS_IPV4_MAPPED()

Section 12.19, “Miscellaneous Functions”

IS_IPV6()

Section 12.19, “Miscellaneous Functions”

IS_USED_LOCK()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.19, “Miscellaneous Functions”
Section 17.4.1.16, “Replication and System Functions”

IsClosed()

Section 12.15.7.3, “LineString and MultiLineString Property Functions”

IsEmpty()

Section 12.15.7.1, “General Geometry Property Functions”

ISNULL()

Section 12.3.2, “Comparison Functions and Operators”

IsSimple()

Section 12.15.7.1, “General Geometry Property Functions”

J

[index top]

JSON_APPEND()

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

JSON_ARRAY()

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

JSON_ARRAY_APPEND()

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

JSON_ARRAY_INSERT()

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

JSON_CONTAINS()

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

JSON_CONTAINS_PATH()

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

JSON_DEPTH()

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

JSON_EXTRACT()

Section 13.1.18, “CREATE TABLE Syntax”
Section 12.16.3, “Functions That Search JSON Values”
Section 11.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 5.7”

JSON_INSERT()

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

JSON_KEYS()

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

JSON_LENGTH()

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

JSON_MERGE()

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

JSON_OBJECT()

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

JSON_QUOTE()

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

JSON_REMOVE()

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

JSON_REPLACE()

Section 12.16.4, “Functions That Modify JSON Values”
Section 12.16.6, “JSON Path Syntax”
Section 11.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 5.7”

JSON_SEARCH()

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

JSON_SET()

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

JSON_TYPE()

Section 12.16.5, “Functions That Return JSON Value Attributes”
Section 12.16.3, “Functions That Search JSON Values”
Section 11.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 5.7”

JSON_UNQUOTE()

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

JSON_VALID()

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

L

[index top]

LAST_DAY()

Section 12.7, “Date and Time Functions”

LAST_INSERT_ID()

Section 12.3.2, “Comparison Functions and Operators”
Section 24.8.16, “Controlling Automatic Reconnection Behavior”
Section 13.1.18, “CREATE TABLE Syntax”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 24.8.15.3, “How to Get the Unique ID for the Last Inserted Row”
Section 12.14, “Information Functions”
Section 13.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 13.2.5, “INSERT Syntax”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 24.8.7.38, “mysql_insert_id()”
Section 24.8.7.60, “mysql_reset_connection()”
Section 24.8.11.16, “mysql_stmt_insert_id()”
Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 17.4.1.1, “Replication and AUTO_INCREMENT”
Section 17.4.1.16, “Replication and System Functions”
Section 5.1.4, “Server System Variables”
Section 20.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()”
Section 13.3.5.3, “Table-Locking Restrictions and Conditions”
Section 17.4.4, “Troubleshooting Replication”
Section 20.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”
Section 11.6, “The JSON Data Type”

LEFT()

Section 12.10, “Cast Functions and Operators”
Section 12.5, “String Functions”

LENGTH()

Section 12.5, “String Functions”

Length()

Section 11.5, “Extensions for Spatial Data”
Section 12.15.7.3, “LineString and MultiLineString Property Functions”

LineFromText()

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

LineFromWKB()

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

LineString()

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

LineStringFromText()

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

LineStringFromWKB()

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

LN()

Section 12.6.2, “Mathematical Functions”

LOAD_FILE()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 12.18.2, “Enterprise Encryption Usage and Examples”
Section 8.10.3.1, “How the Query Cache Operates”
Section 13.2.7, “LOAD XML Syntax”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 6.2.1, “Privileges Provided by MySQL”
Section 17.4.1.16, “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 and DATETIME”
Section 12.7, “Date and Time Functions”

LOCALTIME()

Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 12.7, “Date and Time Functions”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”

LOCALTIMESTAMP

Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 12.7, “Date and Time Functions”

LOCALTIMESTAMP()

Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 12.7, “Date and Time Functions”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”

LOCATE()

Section 12.5, “String Functions”

LOG()

Section 19.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 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 13.4.2.1, “CHANGE MASTER TO Syntax”
Section 17.2.3.1, “Commands for Operations on a Single Channel”
Section 17.2.3.2, “Compatibility with Previous Replication Statements”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.19, “Miscellaneous Functions”
Section A.13, “MySQL 5.7 FAQ: Replication”

MATCH

Section 9.5, “Expression Syntax”

MATCH ()

Section 12.9, “Full-Text Search Functions”

MATCH()

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 14.2.6.3, “InnoDB FULLTEXT Indexes”
MySQL Glossary
Section 12.9.1, “Natural Language Full-Text Searches”

MAX()

Section 12.20.1, “GROUP BY (Aggregate) Function Descriptions”
Section 8.3.1, “How MySQL Uses Indexes”
Section B.5.7, “Known Issues in MySQL”
Section 8.2.1.16.1, “Loose Index Scan”
Section 12.20.3, “MySQL Handling of GROUP BY”
Section 11.1.1, “Numeric Type Overview”
Section 13.2.10.10, “Optimizing Subqueries”
Section 5.1.7, “Server SQL Modes”
Section 11.6, “The JSON Data Type”
Section 1.3.2, “The Main Features of MySQL”
Section 11.3.8, “Two-Digit Years in Dates”
Section 20.5.3, “Updatable and Insertable Views”
Section 8.2.1.7, “Use of Index Extensions”
Section 3.6.9, “Using AUTO_INCREMENT”
Section 20.5.2, “View Processing Algorithms”

MBRContains()

Section 12.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 12.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 11.5.3.7, “Using Spatial Indexes”

MBRCoveredBy()

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

MBRCovers()

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

MBRDisjoint()

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

MBREqual()

Section 12.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 12.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 12.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 1.4, “What Is New in MySQL 5.7”

MBRIntersects()

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

MBROverlaps()

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

MBRTouches()

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

MBRWithin()

Section 12.15.9.3, “MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 12.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs)”
Section 11.5.3.7, “Using Spatial Indexes”

MD5()

Section 12.13, “Encryption and Compression Functions”
Section 19.2.5, “KEY Partitioning”
Section 1.8.1, “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 19.6.3, “Partitioning Limitations Relating to Functions”

MID()

Section 10.1.9.1, “Result Strings”
Section 12.5, “String Functions”

MIN()

Section 24.8.18, “C API Prepared Statement Problems”
Section 12.20.1, “GROUP BY (Aggregate) Function Descriptions”
Section 8.2.1.2, “How MySQL Optimizes WHERE Clauses”
Section 8.3.1, “How MySQL Uses Indexes”
Section B.5.7, “Known Issues in MySQL”
Section 8.2.1.16.1, “Loose Index Scan”
Section 12.20.3, “MySQL Handling of GROUP BY”
Section 11.1.1, “Numeric Type Overview”
Section 13.2.10.10, “Optimizing Subqueries”
Section B.5.4.3, “Problems with NULL Values”
Section 11.6, “The JSON Data Type”
Section 1.3.2, “The Main Features of MySQL”
Section 11.3.8, “Two-Digit Years in Dates”
Section 20.5.3, “Updatable and Insertable Views”
Section 8.2.1.7, “Use of Index Extensions”
Section 20.5.2, “View Processing Algorithms”

MINUTE()

Section 12.7, “Date and Time Functions”
Section 19.6.3, “Partitioning Limitations Relating to Functions”

MLineFromText()

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

MLineFromWKB()

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

MOD()

Section 12.6.1, “Arithmetic Operators”
Section 3.3.4.5, “Date Calculations”
Section 12.6.2, “Mathematical Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 19.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 19.6.3, “Partitioning Limitations Relating to Functions”
Section 19.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.15.3, “Functions That Create Geometry Values from WKT Values”

MPointFromWKB()

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

MPolyFromText()

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

MPolyFromWKB()

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

MultiLineString()

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

MultiLineStringFromText()

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

MultiLineStringFromWKB()

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

MultiPoint()

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

MultiPointFromText()

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

MultiPointFromWKB()

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

MultiPolygon()

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

MultiPolygonFromText()

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

MultiPolygonFromWKB()

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

my_open()

Section 5.1.6, “Server Status Variables”

N

[index top]

NAME_CONST()

Section 20.7, “Binary Logging of Stored Programs”
Section 12.19, “Miscellaneous Functions”

NOT IN()

Section 8.2.1.3.5, “Range Optimization of Row Constructor Expressions”

NOW()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.18, “CREATE TABLE Syntax”
Section 11.7, “Data Type Default Values”
Section 12.7, “Date and Time Functions”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 11.3.6, “Fractional Seconds in Time Values”
Section 8.10.3.1, “How the Query Cache Operates”
Section A.1, “MySQL 5.7 FAQ: General”
Section 10.6, “MySQL Server Time Zone Support”
Section 17.4.1.16, “Replication and System Functions”
Section 17.4.1.32, “Replication and Time Zones”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”
Section 23.4.3.21, “The metrics View”
Section 23.4.4.25, “The statement_performance_analyzer() Procedure”
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.15.7.5, “GeometryCollection Property Functions”

NumInteriorRings()

Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”

NumPoints()

Section 12.15.7.3, “LineString and MultiLineString Property Functions”

O

[index top]

OCT()

Section 12.5, “String Functions”

OCTET_LENGTH()

Section 12.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 13.7.1.2, “CREATE USER Syntax”
Section 12.13, “Encryption and Compression Functions”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 5.1.4, “Server System Variables”
Section 13.7.1.7, “SET PASSWORD Syntax”
Section 6.4.2, “The Password Validation Plugin”
Section 25.2.1, “Types of Plugins”
Section 1.4, “What Is New in MySQL 5.7”

ORD()

Section 12.5, “String Functions”

Overlaps()

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

P

[index top]

PASSWORD()

Section 6.2.4, “Access Control, Stage 1: Connection Verification”
Section 6.3.5, “Assigning Account Passwords”
Section 13.7.1.2, “CREATE USER Syntax”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 12.13, “Encryption and Compression Functions”
Section 8.10.3.1, “How the Query Cache Operates”
Section B.5.2.15, “Ignoring user”
Section 19.2.5, “KEY Partitioning”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 6.1.2.3, “Passwords and Logging”
Section 5.1.4, “Server System Variables”
Section 13.7.1.7, “SET PASSWORD Syntax”
Section 6.4.2, “The Password Validation Plugin”
Section 6.4.1.4, “The SHA-256 Authentication Plugin”
Section 6.2.7, “Troubleshooting Problems Connecting to MySQL”
Section 25.2.1, “Types of Plugins”
Section 1.4, “What Is New in MySQL 5.7”

PERIOD_ADD()

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

PERIOD_DIFF()

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

PI()

Section 9.2.4, “Function Name Parsing and Resolution”
Section 12.6.2, “Mathematical Functions”

Point()

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

PointFromText()

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

PointFromWKB()

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

PointN()

Section 12.15.7.3, “LineString and MultiLineString Property Functions”

PolyFromText()

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

PolyFromWKB()

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

Polygon()

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

PolygonFromText()

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

PolygonFromWKB()

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

POSITION()

Section 12.5, “String Functions”

POW()

Section 19.2.4, “HASH Partitioning”
Section 12.6.2, “Mathematical Functions”

POWER()

Section 19.2.4.1, “LINEAR HASH Partitioning”
Section 12.6.2, “Mathematical Functions”

pthread_mutex()

Section 1.9.1, “Contributors to MySQL”

Q

[index top]

QUARTER()

Section 12.7, “Date and Time Functions”
Section 19.6.3, “Partitioning Limitations Relating to Functions”

QUOTE()

Section 24.8.7.55, “mysql_real_escape_string()”
Section 24.8.7.56, “mysql_real_escape_string_quote()”
Section 12.5, “String Functions”
Section 9.1.1, “String Literals”

R

[index top]

RADIANS()

Section 12.6.2, “Mathematical Functions”

RAND()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.6.2, “Mathematical Functions”
Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
Section 17.4.1.16, “Replication and System Functions”
Section 5.1.4, “Server System Variables”

RANDOM_BYTES()

Section 12.13, “Encryption and Compression Functions”
Section 8.10.3.1, “How the Query Cache Operates”

RELEASE_ALL_LOCKS()

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

RELEASE_LOCK()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 13.2.3, “DO Syntax”
Section 8.10.3.1, “How the Query Cache Operates”
Section 8.11.1, “Internal Locking Methods”
Section 12.19, “Miscellaneous Functions”
Section 17.4.1.16, “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”

replace()

Section 16.3.3.1, “Basic memcached Operations”

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 14.13.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section 12.6.2, “Mathematical Functions”
Section 12.21, “Precision Math”
Section 12.21.5, “Precision Math Examples”
Section 12.21.4, “Rounding Behavior”

ROW_COUNT()

Section 13.2.1, “CALL Syntax”
Section 13.2.2, “DELETE Syntax”
Section 17.2.1.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 13.2.5, “INSERT Syntax”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 24.8.7.1, “mysql_affected_rows()”
Section 17.4.1.16, “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 19.6.3, “Partitioning Limitations Relating to Functions”

SESSION_USER()

Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 12.14, “Information Functions”
Section 10.1.12, “UTF-8 for Metadata”

set()

Section 16.3.3.1, “Basic memcached Operations”

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.1, “Security Guidelines”

SHA2()

Section 12.13, “Encryption and Compression Functions”
Section 6.1.1, “Security Guidelines”

SIGN()

Section 12.6.2, “Mathematical Functions”

SIN()

Section 12.6.2, “Mathematical Functions”
Section 25.4.2.3, “UDF Argument Processing”

SLEEP()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.14.2, “General Thread States”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.19, “Miscellaneous Functions”
Section 17.4.1, “Replication Features and Issues”

SOUNDEX()

Section 25.4, “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”

SQRT()

Section 12.6.2, “Mathematical Functions”

SRID()

Section 12.15.7.1, “General Geometry Property Functions”

ST_Area()

Section 12.15.7, “Geometry Property Functions”
Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”

ST_AsBinary()

Section 11.5.3.4, “Fetching Spatial Data”
Section 12.15.6, “Geometry Format Conversion Functions”

ST_AsGeoJSON()

Section 12.15.11, “Spatial GeoJSON Functions”
Section 11.6, “The JSON Data Type”

ST_AsText()

Section 11.5.3.4, “Fetching Spatial Data”
Section 12.15.6, “Geometry Format Conversion Functions”

ST_AsWKB()

Section 12.15.6, “Geometry Format Conversion Functions”

ST_AsWKT()

Section 12.15.6, “Geometry Format Conversion Functions”

ST_Buffer()

Section 12.15.8, “Spatial Operator Functions”

ST_Buffer_Strategy()

Section 5.1.4, “Server System Variables”
Section 12.15.8, “Spatial Operator Functions”

ST_Centroid()

Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”

ST_Contains()

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

ST_ConvexHull()

Section 12.15.8, “Spatial Operator Functions”

ST_Crosses()

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

ST_Difference()

Section 12.15.8, “Spatial Operator Functions”

ST_Dimension()

Section 12.15.7.1, “General Geometry Property Functions”

ST_Disjoint()

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

ST_Distance()

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

ST_Distance_Sphere()

Section 12.15.12, “Spatial Convenience Functions”

ST_EndPoint()

Section 12.15.7.3, “LineString and MultiLineString Property Functions”
Section 12.15.8, “Spatial Operator Functions”

ST_Envelope()

Section 12.15.7.1, “General Geometry Property Functions”
Section 12.15.8, “Spatial Operator Functions”

ST_Equals()

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

ST_ExteriorRing()

Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”
Section 12.15.8, “Spatial Operator Functions”

ST_GeoHash()

Section 12.15.10, “Spatial Geohash Functions”

ST_GeomCollFromText()

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

ST_GeomCollFromTxt()

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

ST_GeomCollFromWKB()

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

ST_GeometryCollectionFromText()

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

ST_GeometryCollectionFromWKB()

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

ST_GeometryFromText()

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

ST_GeometryFromWKB()

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

ST_GeometryN()

Section 12.15.7.5, “GeometryCollection Property Functions”
Section 12.15.8, “Spatial Operator Functions”

ST_GeometryType()

Section 12.15.7.1, “General Geometry Property Functions”

ST_GeomFromGeoJSON()

Section 12.15.11, “Spatial GeoJSON Functions”
Section 11.6, “The JSON Data Type”

ST_GeomFromText()

Section 12.15.3, “Functions That Create Geometry Values from WKT Values”
Section 11.5.3.3, “Populating Spatial Columns”
Section 11.5.3.1.1, “Well-Known Text (WKT) Format”

ST_GeomFromWKB()

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

ST_InteriorRingN()

Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”
Section 12.15.8, “Spatial Operator Functions”

ST_Intersection()

Section 12.15.8, “Spatial Operator Functions”

ST_Intersects()

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

ST_IsClosed()

Section 12.15.7.3, “LineString and MultiLineString Property Functions”

ST_IsEmpty()

Section 12.15.7.1, “General Geometry Property Functions”

ST_IsSimple()

Section 12.15.7.1, “General Geometry Property Functions”

ST_IsValid()

Section 12.15.12, “Spatial Convenience Functions”

ST_LatFromGeoHash()

Section 12.15.10, “Spatial Geohash Functions”

ST_Length()

Section 11.5, “Extensions for Spatial Data”
Section 12.15.7.3, “LineString and MultiLineString Property Functions”
Section 12.5, “String Functions”

ST_LineFromText()

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

ST_LineFromWKB()

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

ST_LineStringFromText()

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

ST_LineStringFromWKB()

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

ST_LongFromGeoHash()

Section 12.15.10, “Spatial Geohash Functions”

ST_MakeEnvelope()

Section 12.15.12, “Spatial Convenience Functions”

ST_MLineFromText()

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

ST_MLineFromWKB()

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

ST_MPointFromText()

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

ST_MPointFromWKB()

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

ST_MPolyFromText()

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

ST_MPolyFromWKB()

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

ST_MultiLineStringFromText()

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

ST_MultiLineStringFromWKB()

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

ST_MultiPointFromText()

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

ST_MultiPointFromWKB()

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

ST_MultiPolygonFromText()

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

ST_MultiPolygonFromWKB()

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

ST_NumGeometries()

Section 12.15.7.5, “GeometryCollection Property Functions”

ST_NumInteriorRing()

Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”

ST_NumInteriorRings()

Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”

ST_NumPoints()

Section 12.15.7.3, “LineString and MultiLineString Property Functions”

ST_Overlaps()

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

ST_PointFromGeoHash()

Section 12.15.10, “Spatial Geohash Functions”

ST_PointFromText()

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

ST_PointFromWKB()

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

ST_PointN()

Section 12.15.7.3, “LineString and MultiLineString Property Functions”
Section 12.15.8, “Spatial Operator Functions”

ST_PolyFromText()

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

ST_PolyFromWKB()

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

ST_PolygonFromText()

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

ST_PolygonFromWKB()

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

ST_Simplify()

Section 12.15.12, “Spatial Convenience Functions”

ST_SRID()

Section 12.15.7.1, “General Geometry Property Functions”

ST_StartPoint()

Section 12.15.7.3, “LineString and MultiLineString Property Functions”
Section 12.15.8, “Spatial Operator Functions”

ST_SymDifference()

Section 12.15.8, “Spatial Operator Functions”

ST_Touches()

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

ST_Union()

Section 12.15.8, “Spatial Operator Functions”

ST_Validate()

Section 12.15.12, “Spatial Convenience Functions”

ST_Within()

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

ST_X()

Section 12.15.7.2, “Point Property Functions”

ST_Y()

Section 12.15.7.2, “Point Property Functions”

StartPoint()

Section 12.15.7.3, “LineString and MultiLineString Property Functions”

STD()

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

STDDEV()

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

STDDEV_POP()

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

STDDEV_SAMP()

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

STR_TO_DATE()

Section 12.7, “Date and Time Functions”
Section 10.7, “MySQL Server Locale Support”

STRCMP()

Section B.5.4.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 12.5, “String Functions”

SUBSTRING_INDEX()

Section 6.3.14, “SQL-Based MySQL Account Activity Auditing”
Section 12.5, “String Functions”

SUBTIME()

Section 12.7, “Date and Time Functions”

SUM()

Section 25.4.2, “Adding a New User-Defined Function”
Section 11.1.2, “Date and Time Type Overview”
Section 12.20.1, “GROUP BY (Aggregate) Function Descriptions”
Section 8.2.1.16.1, “Loose Index Scan”
Section 12.19, “Miscellaneous Functions”
Section 19.1, “Overview of Partitioning in MySQL”
Section B.5.4.3, “Problems with NULL Values”
Section 11.4.4, “The ENUM Type”
Section 1.3.2, “The Main Features of MySQL”
Section 11.4.5, “The SET Type”
Section 20.5.3, “Updatable and Insertable Views”
Section 20.5.2, “View Processing Algorithms”

SYSDATE()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 12.7, “Date and Time Functions”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 17.4.1.14, “Replication and Fractional Seconds Support”
Section 17.4.1.16, “Replication and System Functions”
Section 5.1.3, “Server Command Options”
Section 5.1.4, “Server System Variables”

SYSTEM_USER()

Section 17.2.1.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 19.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 12.7, “Date and Time Functions”
Section 19.2.4, “HASH Partitioning”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 19.4, “Partition Pruning”
Section 19.6.3, “Partitioning Limitations Relating to Functions”
Section 19.2, “Partitioning Types”

TO_SECONDS()

Section 12.7, “Date and Time Functions”
Section 19.4, “Partition Pruning”
Section 19.6.3, “Partitioning Limitations Relating to Functions”
Section 19.2, “Partitioning Types”

Touches()

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

TRIM()

Section 10.1.13, “Column Character Set Conversion”
Section 1.8.1, “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”

UNIX_TIMESTAMP()

Section 12.7, “Date and Time Functions”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 19.6.3, “Partitioning Limitations Relating to Functions”
Section 19.2.1, “RANGE Partitioning”
Section 5.1.4, “Server System Variables”
Section 23.4.3.21, “The metrics View”
Section B.5.3.7, “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 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 13.7.1.1, “ALTER USER Syntax”
Section 10.1.7.5, “Collation of Expressions”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 25.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.9, “Proxy Users”
Section 17.4.1.16, “Replication and System Functions”
Section 6.3.14, “SQL-Based MySQL Account Activity Auditing”
Section 10.1.12, “UTF-8 for Metadata”
Section 25.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 17.2.1.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 17.2.1.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 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 10.6, “MySQL Server Time Zone Support”
Section 17.4.1.14, “Replication and Fractional Seconds Support”

UUID()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 20.7, “Binary Logging of Stored Programs”
Section 17.1.6.4, “Binary Logging Options and Variables”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.19, “Miscellaneous Functions”
Section 5.2.4.3, “Mixed Binary Logging Format”
Section 17.4.1.16, “Replication and System Functions”
Section 5.2.4.2, “Setting The Binary Log Format”

UUID_SHORT()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.19, “Miscellaneous Functions”

V

[index top]

VALIDATE_PASSWORD_STRENGTH()

Section 12.13, “Encryption and Compression Functions”
Section 6.4.2.2, “Password Validation Plugin Options and Variables”
Section 6.4.2, “The Password Validation Plugin”
Section 25.2.1, “Types of Plugins”

VALUES()

Section 13.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 12.19, “Miscellaneous Functions”

VAR_POP()

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

VAR_SAMP()

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

VARIANCE()

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

VERSION()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section B.5.4.1, “Case Sensitivity in String Searches”
Section 10.1.7.5, “Collation of Expressions”
Section 12.14, “Information Functions”
Section 17.4.1.16, “Replication and System Functions”
Section 6.4.4.3, “The Audit Log File”
Section 10.1.12, “UTF-8 for Metadata”

W

[index top]

WAIT_FOR_EXECUTED_GTID_SET()

Section 17.2.3.2, “Compatibility with Previous Replication Statements”
Section 12.17, “Functions Used with Global Transaction IDs”
Section 17.1.5.1, “Replication Mode Concepts”

WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()

Section 17.2.3.1, “Commands for Operations on a Single Channel”
Section 17.2.3.2, “Compatibility with Previous Replication Statements”
Section 12.17, “Functions Used with Global Transaction IDs”

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.1, “MySQL Extensions to Standard SQL”
Section 19.6.3, “Partitioning Limitations Relating to Functions”
Section 19.2, “Partitioning Types”

WEEKOFYEAR()

Section 12.7, “Date and Time Functions”

WEIGHT_STRING()

Section 10.4, “Adding a Collation to a Character Set”
Section B.5.4.1, “Case Sensitivity in String Searches”
Section 12.5, “String Functions”
Section 10.1.14.1, “Unicode Character Sets”

Within()

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

X

[index top]

X()

Section 12.15.7.2, “Point Property Functions”

Y

[index top]

Y()

Section 12.15.7.2, “Point Property Functions”

YEAR()

Section 12.7, “Date and Time Functions”
Section 3.3.4.5, “Date Calculations”
Section 19.2.4, “HASH Partitioning”
Section 19.2.7, “How MySQL Partitioning Handles NULL”
Section 19.3.1, “Management of RANGE and LIST Partitions”
Section 19.4, “Partition Pruning”
Section 19.6.3, “Partitioning Limitations Relating to Functions”
Section 19.2, “Partitioning Types”
Section 19.2.1, “RANGE Partitioning”

YEARWEEK()

Section 12.7, “Date and Time Functions”
Section 19.6.3, “Partitioning Limitations Relating to Functions”
Prev Up  Next
Command Index Home INFORMATION_SCHEMA Index