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 | Y

Symbols

[index top]

%

Section 1.8.1, “MySQL Extensions to Standard SQL”

A

[index top]

ABS()

Section 29.4, “Adding New Functions to MySQL”
Section 13.7.4.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 12.6.2, “Mathematical Functions”
Section 8.9.6, “Optimizer Statistics”
Section 23.6.3, “Partitioning Limitations Relating to Functions”

ACOS()

Section 12.6.2, “Mathematical Functions”

ADDDATE()

Section 12.7, “Date and Time Functions”

addslashes()

Section 6.1.7, “Client Programming Security Guidelines”

ADDTIME()

Section 12.7, “Date and Time Functions”

AES_DECRYPT()

Section 12.13, “Encryption and Compression Functions”
Section 12.19.4, “MySQL Enterprise Encryption Function Descriptions”
Section 5.1.8, “Server System Variables”
Section 1.4, “What Is New in MySQL 8.0”

AES_ENCRYPT()

Section 12.13, “Encryption and Compression Functions”
Section 12.19.4, “MySQL Enterprise Encryption Function Descriptions”
Section 5.1.8, “Server System Variables”
Section 1.4, “What Is New in MySQL 8.0”

ANY_VALUE()

Section 12.24, “Miscellaneous Functions”
Section 12.20.3, “MySQL Handling of GROUP BY”

ASCII()

Section 13.8.3, “HELP Syntax”
Section 12.5, “String Functions and Operators”

ASIN()

Section 12.6.2, “Mathematical Functions”

ASYMMETRIC_DECRYPT()

Section 12.19.4, “MySQL Enterprise Encryption Function Descriptions”

ASYMMETRIC_DERIVE()

Section 12.19.4, “MySQL Enterprise Encryption Function Descriptions”

ASYMMETRIC_ENCRYPT()

Section 12.19.4, “MySQL Enterprise Encryption Function Descriptions”

ASYMMETRIC_SIGN()

Section 12.19.4, “MySQL Enterprise Encryption Function Descriptions”

ASYMMETRIC_VERIFY()

Section 12.19.4, “MySQL Enterprise Encryption Function Descriptions”

ATAN()

Section 12.6.2, “Mathematical Functions”

ATAN2()

Section 12.6.2, “Mathematical Functions”

AVG(

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

AVG()

Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 11.1.2, “Date and Time Type Overview”
Section 8.2.1.16, “GROUP BY Optimization”
Section 11.4.4, “The ENUM Type”
Section 1.3.2, “The Main Features of MySQL”
Section 11.4.5, “The SET Type”
Section 1.4, “What Is New in MySQL 8.0”
Section 12.21.3, “Window Function Frame Specification”

B

[index top]

BENCHMARK()

Section 13.2.11.8, “Derived Tables”
Section 12.15, “Information Functions”
Section 8.13.1, “Measuring the Speed of Expressions and Functions”
Section 13.2.11.11, “Optimizing Subqueries”

BIN()

Section 9.1.5, “Bit-Value Literals”
Section 12.5, “String Functions and Operators”

BIN_TO_UUID()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.24, “Miscellaneous Functions”

BIT_AND()

Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 12.12, “Bit Functions and Operators”
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 and Operators”

BIT_OR()

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

BIT_XOR()

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

C

[index top]

CAN_ACCESS_COLUMN()

Section 12.23, “Internal Functions”

CAN_ACCESS_DATABASE()

Section 12.23, “Internal Functions”

CAN_ACCESS_TABLE()

Section 12.23, “Internal Functions”

CAN_ACCESS_VIEW()

Section 12.23, “Internal Functions”

CAST()

Section 12.12, “Bit Functions and Operators”
Section 9.1.5, “Bit-Value Literals”
Section 12.10, “Cast Functions and Operators”
Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.3.2, “Comparison Functions and Operators”
Section 11.3.6, “Conversion Between Date and Time Types”
Section 13.1.15, “CREATE INDEX Syntax”
Section 12.7, “Date and Time Functions”
Section 9.5, “Expressions”
Section 12.17.2, “Functions That Create JSON Values”
Section 12.17.3, “Functions That Search JSON Values”
Section 9.1.4, “Hexadecimal Literals”
Section 1.8.2, “MySQL Differences from Standard SQL”
Section 11.6, “The JSON Data Type”
Section 12.2, “Type Conversion in Expression Evaluation”
Section 9.4, “User-Defined Variables”
Section 1.4, “What Is New in MySQL 8.0”
Section 13.2.13, “WITH Syntax (Common Table Expressions)”

CEIL()

Section 12.6.2, “Mathematical Functions”

CEILING()

Section 23.2.4.1, “LINEAR HASH Partitioning”
Section 12.6.2, “Mathematical Functions”
Section 23.6.3, “Partitioning Limitations Relating to Functions”

CHAR()

Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.5, “String Functions and Operators”

CHAR_LENGTH()

Section 12.5, “String Functions and Operators”
Section 10.10.1, “Unicode Character Sets”

CHARACTER_LENGTH()

Section 12.5, “String Functions and Operators”

CHARSET()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.15, “Information Functions”

COALESCE()

Section 12.3.2, “Comparison Functions and Operators”
Section 13.2.10.2, “JOIN Syntax”
Section 13.2.13, “WITH Syntax (Common Table Expressions)”

COERCIBILITY()

Section 10.8.4, “Collation Coercibility in Expressions”
Section 12.15, “Information Functions”

COLLATION()

Section B.4.4.1, “Case Sensitivity in String Searches”
Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.15, “Information Functions”

COMPRESS()

Section 12.13, “Encryption and Compression Functions”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 5.1.8, “Server System Variables”

CONCAT()

Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 12.10, “Cast Functions and Operators”
Section 12.5.3, “Character Set and Collation of Function Results”
Section 10.2.1, “Character Set Repertoire”
Section 10.8.4, “Collation Coercibility in Expressions”
Section 13.7.4.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 12.3.3, “Logical Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 5.1.11, “Server SQL Modes”
Section 13.7.6.13, “SHOW CREATE VIEW Syntax”
Section 12.5, “String Functions and Operators”
Section 25.36, “The INFORMATION_SCHEMA VIEWS Table”
Section 12.2, “Type Conversion in Expression Evaluation”
Section 12.11, “XML Functions”

CONCAT_WS()

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

CONNECTION_ID()

Section 6.4.5.4, “Audit Log File Formats”
Section 13.1.20.7, “CHECK Constraints”
Section 13.1.20.9, “CREATE TABLE and Generated Columns”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 12.15, “Information Functions”
Section 13.7.7.4, “KILL Syntax”
Section 4.5.1.3, “mysql Client Logging”
Section 12.22, “Performance Schema Functions”
Section 13.7.6.29, “SHOW PROCESSLIST Syntax”
Section 25.19, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 26.12.18.5, “The threads Table”

CONV()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.6.2, “Mathematical Functions”
Section 12.5, “String Functions and Operators”

CONVERT()

Section 12.10, “Cast Functions and Operators”
Section 10.3.8, “Character Set Introducers”
Section 10.3.6, “Character String Literal Character Set and Collation”
Section 12.3.2, “Comparison Functions and Operators”
Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 6.4.8.3, “Using MySQL Enterprise Data Masking and De-Identification”
Section 1.4, “What Is New in MySQL 8.0”

CONVERT_TZ()

Section 12.7, “Date and Time Functions”
Section 8.3.14, “Indexed Lookups from TIMESTAMP Columns”
Section 13.3.6, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 5.1.8, “Server System Variables”
Section 5.4.3, “The General Query Log”
Section 5.4.5, “The Slow Query Log”

COS()

Section 12.6.2, “Mathematical Functions”

COT()

Section 12.6.2, “Mathematical Functions”

COUNT()

Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 3.3.4.8, “Counting Rows”
Section 13.7.4.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 8.2.1.16, “GROUP BY Optimization”
Section 12.15, “Information Functions”
Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 15.6.1.6, “Limits on InnoDB Tables”
Section 22.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 12.24, “Miscellaneous Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 8.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
Section B.4.4.3, “Problems with NULL Values”
Section 5.1.11, “Server SQL Modes”
Section 1.3.2, “The Main Features of MySQL”
Section 24.5.3, “Updatable and Insertable Views”
Section 8.2.1.1, “WHERE Clause Optimization”

CRC32()

Section 12.6.2, “Mathematical Functions”

CREATE_ASYMMETRIC_PRIV_KEY()

Section 12.19.4, “MySQL Enterprise Encryption Function Descriptions”
Section 12.19.2, “MySQL Enterprise Encryption Usage and Examples”
Section 4.9, “MySQL Environment Variables”

CREATE_ASYMMETRIC_PUB_KEY()

Section 12.19.4, “MySQL Enterprise Encryption Function Descriptions”

CREATE_DH_PARAMETERS()

Section 12.19.4, “MySQL Enterprise Encryption Function Descriptions”
Section 12.19.2, “MySQL Enterprise Encryption Usage and Examples”
Section 4.9, “MySQL Environment Variables”

CREATE_DIGEST()

Section 12.19.4, “MySQL Enterprise Encryption Function Descriptions”

CUME_DIST()

Section 12.21.1, “Window Function Descriptions”

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”

CURRENT_DATE

Section 11.7, “Data Type Default Values”
Section 12.7, “Date and Time Functions”

CURRENT_DATE()

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

CURRENT_ROLE()

Section 12.15, “Information Functions”
Section 6.2.10, “Using Roles”

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”

CURRENT_TIMESTAMP

Section 11.3.4, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.1.13, “CREATE EVENT Syntax”
Section 11.7, “Data Type Default Values”
Section 12.7, “Date and Time Functions”
Section 5.1.8, “Server System Variables”

CURRENT_TIMESTAMP()

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

CURRENT_USER

Section 13.7.1.1, “ALTER USER Syntax”
Section 13.1.13, “CREATE EVENT Syntax”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.22, “CREATE TRIGGER Syntax”
Section 13.1.23, “CREATE VIEW Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 6.2.3, “Grant Tables”
Section 12.15, “Information Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.14, “Replication and System Functions”
Section 17.4.1.8, “Replication of CURRENT_USER()”
Section 13.7.6.12, “SHOW CREATE USER Syntax”
Section 6.2.4, “Specifying Account Names”
Section 24.6, “Stored Object Access Control”

CURRENT_USER()

Section 6.2.6, “Access Control, Stage 1: Connection Verification”
Section 13.7.1.1, “ALTER USER Syntax”
Section 6.4.5.4, “Audit Log File Formats”
Section 13.1.20.7, “CHECK Constraints”
Section 6.4.2.1, “Connection-Control Plugin Installation”
Section 13.1.13, “CREATE EVENT Syntax”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.20.9, “CREATE TABLE and Generated Columns”
Section 13.1.22, “CREATE TRIGGER Syntax”
Section 13.1.23, “CREATE VIEW Syntax”
Section 13.7.1.6, “GRANT Syntax”
Section 29.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 12.15, “Information Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 6.4.3.2, “Password Validation Options and Variables”
Section 6.2.18, “Proxy Users”
Section 17.4.1.14, “Replication and System Functions”
Section 17.4.1.8, “Replication of CURRENT_USER()”
Section 13.7.1.10, “SET PASSWORD Syntax”
Section 13.7.6.12, “SHOW CREATE USER Syntax”
Section 6.2.4, “Specifying Account Names”
Section 6.2.5, “Specifying Role Names”
Section 6.2.22, “SQL-Based Account Activity Auditing”
Section 24.6, “Stored Object Access Control”
Section 29.3.2, “The Keyring Service”
Section 6.4.4.8.2, “Using General-Purpose Keyring Functions”
Section 10.2.2, “UTF-8 for Metadata”
Section 29.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 5.1.13, “MySQL Server Time Zone Support”

D

[index top]

DATABASE()

Section 3.3.1, “Creating and Selecting a Database”
Section 13.1.24, “DROP DATABASE Syntax”
Section 3.4, “Getting Information About Databases and Tables”
Section 12.15, “Information Functions”
Section B.4.7, “Known Issues in MySQL”
Section 10.2.2, “UTF-8 for Metadata”

DATE()

Section 12.7, “Date and Time Functions”

DATE_ADD()

Section 12.6.1, “Arithmetic Operators”
Section 12.7, “Date and Time Functions”
Section 11.3, “Date and Time Types”
Section 3.3.4.5, “Date Calculations”
Section 9.5, “Expressions”
Section 12.21.3, “Window Function Frame Specification”

DATE_FORMAT()

Section 28.7.26, “C API Prepared Statement Problems”
Section 12.10, “Cast Functions and Operators”
Section 12.7, “Date and Time Functions”
Section 10.15, “MySQL Server Locale Support”
Section 5.1.8, “Server System Variables”

DATE_SUB()

Section 12.7, “Date and Time Functions”
Section 11.3, “Date and Time Types”
Section 9.5, “Expressions”

DATEDIFF()

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

DAY()

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

DAYNAME()

Section 12.7, “Date and Time Functions”
Section 10.15, “MySQL Server Locale Support”
Section 5.1.8, “Server System Variables”

DAYOFMONTH()

Section 12.7, “Date and Time Functions”
Section 3.3.4.5, “Date Calculations”
Section 23.6.3, “Partitioning Limitations Relating to Functions”

DAYOFWEEK()

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

DAYOFYEAR()

Section 12.7, “Date and Time Functions”
Section 23.6.3, “Partitioning Limitations Relating to Functions”
Section 23.2, “Partitioning Types”

DECODE()

Section 12.13, “Encryption and Compression Functions”
Section 1.4, “What Is New in MySQL 8.0”

DEFAULT()

Section 13.1.9.2, “ALTER TABLE and Generated Columns”
Section 11.7, “Data Type Default Values”
Section 13.2.6, “INSERT Syntax”
Section 12.24, “Miscellaneous Functions”
Section 13.2.9, “REPLACE Syntax”

DEGREES()

Section 12.6.2, “Mathematical Functions”

DENSE_RANK()

Section 12.21.1, “Window Function Descriptions”

DES_DECRYPT()

Section 12.13, “Encryption and Compression Functions”
Section 1.4, “What Is New in MySQL 8.0”

DES_ENCRYPT()

Section 12.13, “Encryption and Compression Functions”
Section 1.4, “What Is New in MySQL 8.0”

E

[index top]

ELT()

Section 12.5.3, “Character Set and Collation of Function Results”
Section B.4.7, “Known Issues in MySQL”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.5, “String Functions and Operators”

ENCODE()

Section 12.13, “Encryption and Compression Functions”
Section 1.4, “What Is New in MySQL 8.0”

ENCRYPT()

Section 1.9.1, “Contributors to MySQL”
Section 12.13, “Encryption and Compression Functions”
Section 1.4, “What Is New in MySQL 8.0”

EXP()

Section 13.1.20, “CREATE TABLE Syntax”
Section 12.6.2, “Mathematical Functions”

EXPORT_SET()

Section 12.5, “String Functions and Operators”

EXTRACT()

Section 12.10, “Cast Functions and Operators”
Section 12.7, “Date and Time Functions”
Section 9.5, “Expressions”
Section 23.6.3, “Partitioning Limitations Relating to Functions”

ExtractValue()

Section 12.11, “XML Functions”

F

[index top]

FIELD()

Section 12.5, “String Functions and Operators”

FIND_IN_SET()

Section 12.5, “String Functions and Operators”
Section 11.4.5, “The SET Type”

FIRST_VALUE()

Section 12.21.1, “Window Function Descriptions”
Section 12.21.3, “Window Function Frame Specification”

FLOOR()

Section 12.6.2, “Mathematical Functions”
Section 12.20.3, “MySQL Handling of GROUP BY”
Section 8.9.6, “Optimizer Statistics”
Section 23.6.3, “Partitioning Limitations Relating to Functions”

FORMAT()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.6.2, “Mathematical Functions”
Section 12.24, “Miscellaneous Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 10.15, “MySQL Server Locale Support”
Section 12.5, “String Functions and Operators”

FORMAT_BYTES()

Section 12.22, “Performance Schema Functions”
Section 27.4.5.3, “The format_bytes() Function”

FORMAT_PICO_TIME()

Section 12.22, “Performance Schema Functions”
Section 27.4.5.6, “The format_time() Function”

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 12.15, “Information Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 17.4.1.14, “Replication and System Functions”
Section 13.2.10, “SELECT Syntax”
Section 1.4, “What Is New in MySQL 8.0”

FROM_BASE64()

Section 12.5, “String Functions and Operators”

FROM_DAYS()

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

FROM_UNIXTIME()

Section 1.9.1, “Contributors to MySQL”
Section 12.7, “Date and Time Functions”
Section 8.3.14, “Indexed Lookups from TIMESTAMP Columns”
Section 17.4.1.32, “Replication and Time Zones”

G

[index top]

GeomCollection()

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

GeometryCollection()

Section 12.16.6, “Geometry Format Conversion Functions”
Section 12.16.5, “MySQL-Specific Functions That Create Geometry Values”

GET_DD_COLUMN_PRIVILEGES()

Section 12.23, “Internal Functions”

GET_DD_CREATE_OPTIONS()

Section 12.23, “Internal Functions”

GET_DD_INDEX_SUB_PART_LENGTH()

Section 12.23, “Internal Functions”

GET_FORMAT()

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

GET_LOCK

Section B.3.1, “Server Error Message Reference”

GET_LOCK()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 28.7.28, “C API Automatic Reconnection Control”
Section 13.1.13, “CREATE EVENT Syntax”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 24.4.1, “Event Scheduler Overview”
Section 8.14.2, “General Thread States”
Section 18.9.2, “Group Replication Limitations”
Section 8.11.1, “Internal Locking Methods”
Section 13.7.7.4, “KILL Syntax”
Section 13.3.6, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 12.14, “Locking Functions”
Section 29.3.1.2.3, “Locking Service Monitoring”
Section 8.11.4, “Metadata Locking”
Section 28.7.7.3, “mysql_change_user()”
Section 28.7.7.60, “mysql_reset_connection()”
Section 17.4.1.14, “Replication and System Functions”
Section 29.3.1, “The Locking Service”
Section 26.12.12.3, “The metadata_locks Table”
Section 27.4.4.14, “The ps_setup_save() Procedure”

gethostbyaddr()

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

gethostbyname()

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

getrusage()

Section 22.5.10.43, “The ndbinfo threadstat Table”

gettimeofday()

Section 22.5.10.43, “The ndbinfo threadstat Table”

GREATEST()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.3.2, “Comparison Functions and Operators”
Section 11.6, “The JSON Data Type”

GROUP_CONCAT()

Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section B.4.7, “Known Issues in MySQL”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 5.1.8, “Server System Variables”
Section 11.6, “The JSON Data Type”
Section 1.3.2, “The Main Features of MySQL”

GROUPING()

Section 12.20.2, “GROUP BY Modifiers”
Section 12.24, “Miscellaneous Functions”
Section 12.21.2, “Window Function Concepts and Syntax”

GTID_INTERSECTION_WITH_UUID

Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”

GTID_IS_DISJOINT

Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”

GTID_IS_DISJOINT_UNION

Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”

GTID_IS_EQUAL

Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”

GTID_SUBSET

Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”

GTID_SUBSET()

Section 12.18, “Functions Used with Global Transaction Identifiers (GTIDs)”
Section 17.1.3.1, “GTID Format and Storage”
Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”

GTID_SUBTRACT

Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”

GTID_SUBTRACT()

Section 12.18, “Functions Used with Global Transaction Identifiers (GTIDs)”
Section 17.1.6.5, “Global Transaction ID Options and Variables”
Section 17.1.3.1, “GTID Format and Storage”
Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”

GTID_SUBTRACT_UUID

Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”

GTID_UNION

Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”

H

[index top]

HEX()

Section 9.1.5, “Bit-Value Literals”
Section 12.5.3, “Character Set and Collation of Function Results”
Section 10.3.6, “Character String Literal Character Set and Collation”
Section 6.4.4.8.3, “General-Purpose Keyring Function Reference”
Section 9.1.4, “Hexadecimal Literals”
Section 12.6.2, “Mathematical Functions”
Section 12.24, “Miscellaneous Functions”
Section 12.5, “String Functions and Operators”
Section 6.4.4.8.2, “Using General-Purpose Keyring Functions”

HOUR()

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

I

[index top]

ICU_VERSION()

Section 12.15, “Information Functions”

IF()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.4, “Control Flow Functions”
Section 13.6.5.2, “IF Syntax”
Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section B.4.7, “Known Issues in MySQL”
Section 1.8.1, “MySQL Extensions to Standard SQL”

IFNULL()

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

INET6_ATON()

Section 12.12, “Bit Functions and Operators”
Section 5.1.12, “IPv6 Support”
Section 12.24, “Miscellaneous Functions”

INET6_NTOA()

Section 5.1.12, “IPv6 Support”
Section 12.24, “Miscellaneous Functions”

INET_ATON()

Section 5.1.12, “IPv6 Support”
Section 12.24, “Miscellaneous Functions”

INET_NTOA()

Section 5.1.12, “IPv6 Support”
Section 12.24, “Miscellaneous Functions”

INSERT()

Section 12.5, “String Functions and Operators”

INSTR()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

INTERNAL_AUTO_INCREMENT()

Section 12.23, “Internal Functions”

INTERNAL_AVG_ROW_LENGTH()

Section 12.23, “Internal Functions”

INTERNAL_CHECK_TIME()

Section 12.23, “Internal Functions”

INTERNAL_CHECKSUM()

Section 12.23, “Internal Functions”

INTERNAL_DATA_FREE()

Section 12.23, “Internal Functions”

INTERNAL_DATA_LENGTH()

Section 12.23, “Internal Functions”

INTERNAL_DD_CHAR_LENGTH()

Section 12.23, “Internal Functions”

INTERNAL_GET_COMMENT_OR_ERROR()

Section 12.23, “Internal Functions”

INTERNAL_GET_VIEW_WARNING_OR_ERROR()

Section 12.23, “Internal Functions”

INTERNAL_INDEX_COLUMN_CARDINALITY()

Section 12.23, “Internal Functions”

INTERNAL_INDEX_LENGTH()

Section 12.23, “Internal Functions”

INTERNAL_KEYS_DISABLED()

Section 12.23, “Internal Functions”

INTERNAL_MAX_DATA_LENGTH()

Section 12.23, “Internal Functions”

INTERNAL_TABLE_ROWS()

Section 12.23, “Internal Functions”

INTERNAL_UPDATE_TIME()

Section 12.23, “Internal Functions”

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 12.14, “Locking Functions”
Section 17.4.1.14, “Replication and System Functions”

IS_IPV4()

Section 12.24, “Miscellaneous Functions”

IS_IPV4_COMPAT()

Section 12.24, “Miscellaneous Functions”

IS_IPV4_MAPPED()

Section 12.24, “Miscellaneous Functions”

IS_IPV6()

Section 12.24, “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 12.14, “Locking Functions”
Section 17.4.1.14, “Replication and System Functions”

IS_UUID()

Section 12.24, “Miscellaneous Functions”

IS_VISIBLE_DD_OBJECT()

Section 12.23, “Internal Functions”

ISNULL()

Section 12.3.2, “Comparison Functions and Operators”

J

[index top]

JSON_ARRAY()

Section 12.17.2, “Functions That Create JSON Values”
Section 12.17.3, “Functions That Search JSON Values”
Section 11.6, “The JSON Data Type”

JSON_ARRAY_APPEND()

Section 12.17.4, “Functions That Modify JSON Values”
Section 1.4, “What Is New in MySQL 8.0”

JSON_ARRAY_INSERT()

Section 12.17.4, “Functions That Modify JSON Values”

JSON_ARRAYAGG()

Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 12.17.2, “Functions That Create JSON Values”
Section 12.17.1, “JSON Function Reference”
Section 1.4, “What Is New in MySQL 8.0”

JSON_CONTAINS()

Section 13.1.15, “CREATE INDEX Syntax”
Section 12.17.3, “Functions That Search JSON Values”
Section 1.4, “What Is New in MySQL 8.0”

JSON_CONTAINS_PATH()

Section 12.17.3, “Functions That Search JSON Values”
Section 11.6, “The JSON Data Type”

JSON_DEPTH()

Section 12.17.5, “Functions That Return JSON Value Attributes”

JSON_EXTRACT()

Section 12.17.3, “Functions That Search JSON Values”
Section 12.17.7, “JSON Schema Validation Functions”
Section 13.1.20.10, “Secondary Indexes and Generated Columns”
Section 11.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 8.0”

JSON_INSERT()

Section 12.17.4, “Functions That Modify JSON Values”
Section 11.6, “The JSON Data Type”

JSON_KEYS()

Section 12.17.3, “Functions That Search JSON Values”
Section 6.2.3, “Grant Tables”

JSON_LENGTH()

Section 12.17.5, “Functions That Return JSON Value Attributes”

JSON_MERGE()

Section 12.17.4, “Functions That Modify JSON Values”
Section 1.4, “What Is New in MySQL 8.0”

JSON_MERGE_PATCH()

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

JSON_MERGE_PRESERVE()

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

JSON_OBJECT()

Section 12.17.2, “Functions That Create JSON Values”
Section 12.17.3, “Functions That Search JSON Values”
Section 11.6, “The JSON Data Type”

JSON_OBJECTAGG()

Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 12.17.2, “Functions That Create JSON Values”
Section 12.17.1, “JSON Function Reference”
Section 1.4, “What Is New in MySQL 8.0”

JSON_OVERLAPS()

Section 13.1.15, “CREATE INDEX Syntax”
Section 12.17.3, “Functions That Search JSON Values”
Section 1.4, “What Is New in MySQL 8.0”

JSON_PRETTY()

Section 12.17.1, “JSON Function Reference”
Section 12.17.7, “JSON Schema Validation Functions”
Section 12.17.8, “JSON Utility Functions”
Section 1.4, “What Is New in MySQL 8.0”

JSON_QUOTE()

Section 12.17.2, “Functions That Create JSON Values”
Section 12.17.8, “JSON Utility Functions”

JSON_REMOVE()

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 12.17.4, “Functions That Modify JSON Values”
Section 12.17.8, “JSON Utility Functions”
Section 11.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 8.0”

JSON_REPLACE()

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 12.17.4, “Functions That Modify JSON Values”
Section 12.17.8, “JSON Utility Functions”
Section 11.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 8.0”

JSON_SCHEMA_VALID()

Section 12.17.7, “JSON Schema Validation Functions”
Section 1.4, “What Is New in MySQL 8.0”

JSON_SCHEMA_VALIDATION_REPORT()

Section 12.17.7, “JSON Schema Validation Functions”
Section 1.4, “What Is New in MySQL 8.0”

JSON_SEARCH()

Section 12.17.3, “Functions That Search JSON Values”
Section 11.6, “The JSON Data Type”

JSON_SET()

Section 17.1.6.4, “Binary Logging Options and Variables”
Section 12.17.4, “Functions That Modify JSON Values”
Section 12.17.8, “JSON Utility Functions”
Section 11.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 8.0”

JSON_STORAGE_FREE()

Section 12.17.1, “JSON Function Reference”
Section 12.17.8, “JSON Utility Functions”
Section 11.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 8.0”

JSON_STORAGE_SIZE()

Section 12.17.1, “JSON Function Reference”
Section 12.17.8, “JSON Utility Functions”
Section 11.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 8.0”

JSON_TABLE()

Section 13.2.11.8, “Derived Tables”
Section 12.17.6, “JSON Table Functions”
Section 13.2.11.9, “Lateral Derived Tables”
Section 1.4, “What Is New in MySQL 8.0”

JSON_TYPE()

Section 12.17.5, “Functions That Return JSON Value Attributes”
Section 12.17.3, “Functions That Search JSON Values”
Section 11.6, “The JSON Data Type”

JSON_UNQUOTE(

Section 12.17.3, “Functions That Search JSON Values”

JSON_UNQUOTE()

Section 13.1.15, “CREATE INDEX Syntax”
Section 12.17.4, “Functions That Modify JSON Values”
Section 8.3.11, “Optimizer Use of Generated Column Indexes”
Section 13.1.20.10, “Secondary Indexes and Generated Columns”
Section 11.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 8.0”

JSON_VALID()

Section 12.17.5, “Functions That Return JSON Value Attributes”

L

[index top]

LAG()

Section 1.4, “What Is New in MySQL 8.0”
Section 12.21.1, “Window Function Descriptions”

LAST_DAY()

Section 12.7, “Date and Time Functions”

LAST_INSERT_ID()

Section 28.7.28, “C API Automatic Reconnection Control”
Section 12.3.2, “Comparison Functions and Operators”
Section 13.1.20, “CREATE TABLE Syntax”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 28.7.29.3, “How to Get the Unique ID for the Last Inserted Row”
Section 12.15, “Information Functions”
Section 13.2.6.2, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 13.2.6, “INSERT Syntax”
Section 13.3.6, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 28.7.7.38, “mysql_insert_id()”
Section 28.7.7.60, “mysql_reset_connection()”
Section 28.7.11.16, “mysql_stmt_insert_id()”
Section 17.4.1.1, “Replication and AUTO_INCREMENT”
Section 5.1.8, “Server System Variables”
Section 24.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()”
Section 17.4.4, “Troubleshooting Replication”
Section 24.5.3, “Updatable and Insertable Views”
Section 3.6.9, “Using AUTO_INCREMENT”

LAST_VALUE()

Section 12.21.1, “Window Function Descriptions”
Section 12.21.3, “Window Function Frame Specification”

LCASE()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

LEAD()

Section 12.21.1, “Window Function Descriptions”

LEAST()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.3.2, “Comparison Functions and Operators”
Section 11.6, “The JSON Data Type”

LEFT()

Section 12.5, “String Functions and Operators”

LENGTH()

Section 11.8, “Data Type Storage Requirements”
Section 12.5, “String Functions and Operators”
Section 11.5.3, “Supported Spatial Data Formats”

LineString()

Section 12.16.5, “MySQL-Specific Functions That Create Geometry 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 13.2.8, “LOAD XML Syntax”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 12.19.2, “MySQL Enterprise Encryption Usage and Examples”
Section 6.2.2, “Privileges Provided by MySQL”
Section 17.4.1.14, “Replication and System Functions”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 12.5, “String Functions and Operators”

LOCALTIME

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

LOCALTIME()

Section 11.3.4, “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.4, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 12.7, “Date and Time Functions”

LOCALTIMESTAMP()

Section 11.3.4, “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 and Operators”

LOG()

Section 23.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 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”
Section 10.10.1, “Unicode Character Sets”
Section 10.8.7, “Using Collation in INFORMATION_SCHEMA Searches”

LPAD()

Section 12.12, “Bit Functions and Operators”
Section 11.2.5, “Numeric Type Attributes”
Section 11.1.1, “Numeric Type Overview”
Section 12.5, “String Functions and Operators”
Section 1.4, “What Is New in MySQL 8.0”

LTRIM()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

M

[index top]

MAKE_SET()

Section 12.5, “String Functions and Operators”

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 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 12.24, “Miscellaneous Functions”
Section A.13, “MySQL 8.0 FAQ: Replication”

MATCH

Section 9.5, “Expressions”

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

MAX(

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

MAX()

Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 8.3.13, “Descending Indexes”
Section 8.2.1.16, “GROUP BY Optimization”
Section 8.3.1, “How MySQL Uses Indexes”
Section B.4.7, “Known Issues in MySQL”
Section 11.1.1, “Numeric Type Overview”
Section 8.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
Section 13.2.11.11, “Optimizing Subqueries”
Section 5.1.11, “Server SQL Modes”
Section 11.6, “The JSON Data Type”
Section 1.3.2, “The Main Features of MySQL”
Section 26.12.15.1, “The tp_thread_group_state Table”
Section 11.3.7, “Two-Digit Years in Dates”
Section 24.5.3, “Updatable and Insertable Views”
Section 8.3.10, “Use of Index Extensions”
Section 3.6.9, “Using AUTO_INCREMENT”
Section 8.2.1.20, “Window Function Optimization”
Section 13.2.13, “WITH Syntax (Common Table Expressions)”

MBRContains()

Section 12.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”
Section 11.5.11, “Using Spatial Indexes”

MBRCoveredBy()

Section 12.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”

MBRCovers()

Section 12.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”

MBRDisjoint()

Section 12.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”

MBREquals()

Section 12.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”

MBRIntersects()

Section 12.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”

MBROverlaps()

Section 12.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”

MBRTouches()

Section 12.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”

MBRWithin()

Section 12.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”
Section 11.5.11, “Using Spatial Indexes”

MD5()

Section 12.13, “Encryption and Compression Functions”
Section 23.2.5, “KEY Partitioning”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 9.2, “Schema Object Names”

MICROSECOND()

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

MID()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

MIN(

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

MIN()

Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 28.7.26, “C API Prepared Statement Problems”
Section 8.3.13, “Descending Indexes”
Section 8.2.1.16, “GROUP BY Optimization”
Section 8.3.1, “How MySQL Uses Indexes”
Section B.4.7, “Known Issues in MySQL”
Section 11.1.1, “Numeric Type Overview”
Section 8.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
Section 13.2.11.11, “Optimizing Subqueries”
Section B.4.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.7, “Two-Digit Years in Dates”
Section 24.5.3, “Updatable and Insertable Views”
Section 8.3.10, “Use of Index Extensions”
Section 8.2.1.1, “WHERE Clause Optimization”
Section 8.2.1.20, “Window Function Optimization”

MINUTE()

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

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 23.6.3, “Partitioning Limitations Relating to Functions”
Section 5.1.11, “Server SQL Modes”

MONTH()

Section 12.7, “Date and Time Functions”
Section 3.3.4.5, “Date Calculations”
Section 23.6.3, “Partitioning Limitations Relating to Functions”
Section 23.2, “Partitioning Types”

MONTHNAME()

Section 12.7, “Date and Time Functions”
Section 10.15, “MySQL Server Locale Support”
Section 5.1.8, “Server System Variables”

MultiLineString()

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

MultiPoint()

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

MultiPolygon()

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

my_open()

Section 5.1.10, “Server Status Variables”

N

[index top]

NAME_CONST()

Section 12.24, “Miscellaneous Functions”
Section 24.7, “Stored Program Binary Logging”

NOW()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 11.3.4, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.1.20.7, “CHECK Constraints”
Section 13.1.17, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 13.1.20.9, “CREATE TABLE and Generated Columns”
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.5, “Fractional Seconds in Time Values”
Section A.1, “MySQL 8.0 FAQ: General”
Section 5.1.13, “MySQL Server Time Zone Support”
Section 17.4.1.14, “Replication and System Functions”
Section 17.4.1.32, “Replication and Time Zones”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”
Section 27.4.3.21, “The metrics View”
Section 27.4.4.25, “The statement_performance_analyzer() Procedure”
Section 11.3.3, “The YEAR Type”

NTH_VALUE()

Section 12.21.1, “Window Function Descriptions”
Section 12.21.3, “Window Function Frame Specification”

NTILE()

Section 1.4, “What Is New in MySQL 8.0”
Section 12.21.1, “Window Function Descriptions”

NULLIF()

Section 12.4, “Control Flow Functions”

O

[index top]

OCT()

Section 12.5, “String Functions and Operators”

OCTET_LENGTH()

Section 12.5, “String Functions and Operators”

ORD()

Section 12.5, “String Functions and Operators”

P

[index top]

PASSWORD()

Section 12.13, “Encryption and Compression Functions”
Section 23.2.5, “KEY Partitioning”

PERCENT_RANK()

Section 12.21.1, “Window Function Descriptions”

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.16.5, “MySQL-Specific Functions That Create Geometry Values”
Section 11.5.3, “Supported Spatial Data Formats”

Polygon()

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

POSITION()

Section 12.5, “String Functions and Operators”

POW()

Section 8.2.1.19, “Function Call Optimization”
Section 23.2.4, “HASH Partitioning”
Section 12.6.2, “Mathematical Functions”

POWER()

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

PS_CURRENT_THREAD_ID()

Section 12.22, “Performance Schema Functions”
Section 27.4.5.15, “The ps_thread_id() Function”

PS_THREAD_ID()

Section 12.22, “Performance Schema Functions”
Section 27.4.5.15, “The ps_thread_id() Function”

pthread_mutex()

Section 1.9.1, “Contributors to MySQL”

Q

[index top]

QUARTER()

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

QUOTE()

Section 28.7.7.55, “mysql_real_escape_string()”
Section 28.7.7.56, “mysql_real_escape_string_quote()”
Section 12.5, “String Functions and Operators”
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.17, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.2.1.19, “Function Call Optimization”
Section 12.6.2, “Mathematical Functions”
Section 28.7.7.69, “mysql_session_track_get_first()”
Section 17.4.1.14, “Replication and System Functions”
Section 5.1.8, “Server System Variables”

RANDOM_BYTES()

Section 12.13, “Encryption and Compression Functions”

RANK()

Section 1.4, “What Is New in MySQL 8.0”
Section 12.21.1, “Window Function Descriptions”

REGEXP_INSTR()

Section 12.5.2, “Regular Expressions”
Section 1.4, “What Is New in MySQL 8.0”

REGEXP_LIKE()

Section 3.3.4.7, “Pattern Matching”
Section 12.5.2, “Regular Expressions”
Section 5.1.8, “Server System Variables”
Section 1.4, “What Is New in MySQL 8.0”

REGEXP_REPLACE()

Section 12.5.2, “Regular Expressions”
Section 1.4, “What Is New in MySQL 8.0”

REGEXP_SUBSTR()

Section 12.5.2, “Regular Expressions”
Section 1.4, “What Is New in MySQL 8.0”

RELEASE_ALL_LOCKS()

Section 12.14, “Locking 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.11.1, “Internal Locking Methods”
Section 13.3.6, “LOCK TABLES and UNLOCK TABLES Syntax”
Section 12.14, “Locking Functions”
Section 17.4.1.14, “Replication and System Functions”

REPEAT()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

REPLACE()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

REVERSE()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

RIGHT()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

ROLES_GRAPHML()

Section 12.15, “Information Functions”
Section 6.2.2, “Privileges Provided by MySQL”

ROUND()

Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 12.6.2, “Mathematical Functions”
Section 12.25, “Precision Math”
Section 12.25.5, “Precision Math Examples”
Section 12.25.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 12.15, “Information Functions”
Section 13.2.6, “INSERT Syntax”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 28.7.7.1, “mysql_affected_rows()”
Section 17.4.1.14, “Replication and System Functions”
Section 13.6.7.7, “The MySQL Diagnostics Area”

ROW_NUMBER()

Section 12.21.2, “Window Function Concepts and Syntax”
Section 12.21.1, “Window Function Descriptions”

RPAD()

Section 12.12, “Bit Functions and Operators”
Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

RTRIM()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

S

[index top]

SCHEMA()

Section 12.15, “Information Functions”

SEC_TO_TIME()

Section 12.7, “Date and Time Functions”

SECOND()

Section 12.7, “Date and Time Functions”
Section 23.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.15, “Information Functions”
Section 10.2.2, “UTF-8 for Metadata”

setrlimit()

Section 5.1.8, “Server System Variables”

SHA()

Section 12.13, “Encryption and Compression Functions”

SHA1()

Section 12.13, “Encryption and Compression Functions”

SHA2()

Section 12.13, “Encryption and Compression Functions”
Section 6.1.1, “Security Guidelines”
Section 1.4, “What Is New in MySQL 8.0”

SIGN()

Section 12.6.2, “Mathematical Functions”

SIN()

Section 12.6.2, “Mathematical Functions”
Section 29.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 12.24, “Miscellaneous Functions”
Section 26.12.15.2, “The tp_thread_group_stats Table”

SOUNDEX()

Section 29.4, “Adding New Functions to MySQL”
Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

SPACE()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

SQRT()

Section 12.6.2, “Mathematical Functions”

ST_Area()

Section 12.16.7, “Geometry Property Functions”
Section 12.16.7.4, “Polygon and MultiPolygon Property Functions”

ST_AsBinary()

Section 11.5.8, “Fetching Spatial Data”
Section 12.16.6, “Geometry Format Conversion Functions”

ST_AsGeoJSON()

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

ST_AsText()

Section 11.5.8, “Fetching Spatial Data”
Section 12.16.6, “Geometry Format Conversion Functions”

ST_AsWKB()

Section 12.16.6, “Geometry Format Conversion Functions”

ST_AsWKT()

Section 12.16.3, “Functions That Create Geometry Values from WKT Values”
Section 12.16.6, “Geometry Format Conversion Functions”

ST_Buffer()

Section 12.16.8, “Spatial Operator Functions”

ST_Buffer_Strategy()

Section 5.1.8, “Server System Variables”
Section 12.16.8, “Spatial Operator Functions”

ST_Centroid()

Section 12.16.7.4, “Polygon and MultiPolygon Property Functions”

ST_Contains()

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

ST_ConvexHull()

Section 12.16.8, “Spatial Operator Functions”

ST_Crosses()

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

ST_Difference()

Section 12.16.8, “Spatial Operator Functions”

ST_Dimension()

Section 12.16.7.1, “General Geometry Property Functions”

ST_Disjoint()

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

ST_Distance()

Section 12.16.12, “Spatial Convenience Functions”
Section 12.16.9.1, “Spatial Relation Functions That Use Object Shapes”
Section 25.29, “The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table”

ST_Distance_Sphere()

Section 12.16.12, “Spatial Convenience Functions”
Section 12.16.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_EndPoint()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”
Section 12.16.8, “Spatial Operator Functions”

ST_Envelope()

Section 12.16.7.1, “General Geometry Property Functions”
Section 12.16.8, “Spatial Operator Functions”

ST_Equals()

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

ST_ExteriorRing()

Section 12.16.7.4, “Polygon and MultiPolygon Property Functions”
Section 12.16.8, “Spatial Operator Functions”

ST_GeoHash()

Section 12.16.10, “Spatial Geohash Functions”

ST_GeomCollFromText()

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

ST_GeomCollFromTxt()

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

ST_GeomCollFromWKB()

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

ST_GeometryCollectionFromText()

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

ST_GeometryCollectionFromWKB()

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

ST_GeometryFromText()

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

ST_GeometryFromWKB()

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

ST_GeometryN()

Section 12.16.7.5, “GeometryCollection Property Functions”
Section 12.16.8, “Spatial Operator Functions”

ST_GeometryType()

Section 12.16.7.1, “General Geometry Property Functions”

ST_GeomFromGeoJSON()

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

ST_GeomFromText()

Section 12.16.3, “Functions That Create Geometry Values from WKT Values”
Section 12.16.6, “Geometry Format Conversion Functions”
Section 12.16.5, “MySQL-Specific Functions That Create Geometry Values”
Section 11.5.7, “Populating Spatial Columns”
Section 11.5.3, “Supported Spatial Data Formats”

ST_GeomFromWKB()

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

ST_InteriorRingN()

Section 12.16.7.4, “Polygon and MultiPolygon Property Functions”
Section 12.16.8, “Spatial Operator Functions”

ST_Intersection()

Section 12.16.8, “Spatial Operator Functions”

ST_Intersects()

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

ST_IsClosed()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”

ST_IsEmpty()

Section 12.16.7.1, “General Geometry Property Functions”

ST_IsSimple()

Section 12.16.7.1, “General Geometry Property Functions”

ST_IsValid()

Section 11.5.4, “Geometry Well-Formedness and Validity”
Section 12.16.12, “Spatial Convenience Functions”

ST_LatFromGeoHash()

Section 12.16.10, “Spatial Geohash Functions”

ST_Latitude()

Section 12.16.7.2, “Point Property Functions”

ST_Length()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”
Section 12.5, “String Functions and Operators”
Section 1.4, “What Is New in MySQL 8.0”

ST_LineFromText()

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

ST_LineFromWKB()

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

ST_LineStringFromText()

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

ST_LineStringFromWKB()

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

ST_LongFromGeoHash()

Section 12.16.10, “Spatial Geohash Functions”

ST_Longitude()

Section 12.16.7.2, “Point Property Functions”

ST_MakeEnvelope()

Section 12.16.12, “Spatial Convenience Functions”

ST_MLineFromText()

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

ST_MLineFromWKB()

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

ST_MPointFromText()

Section 12.16.3, “Functions That Create Geometry Values from WKT Values”
Section 11.5.3, “Supported Spatial Data Formats”

ST_MPointFromWKB()

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

ST_MPolyFromText()

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

ST_MPolyFromWKB()

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

ST_MultiLineStringFromText()

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

ST_MultiLineStringFromWKB()

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

ST_MultiPointFromText()

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

ST_MultiPointFromWKB()

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

ST_MultiPolygonFromText()

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

ST_MultiPolygonFromWKB()

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

ST_NumGeometries()

Section 12.16.7.5, “GeometryCollection Property Functions”

ST_NumInteriorRing()

Section 12.16.7.4, “Polygon and MultiPolygon Property Functions”

ST_NumInteriorRings()

Section 12.16.7.4, “Polygon and MultiPolygon Property Functions”

ST_NuminteriorRings()

Section 12.16.7.4, “Polygon and MultiPolygon Property Functions”

ST_NumPoints()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”

ST_Overlaps()

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

ST_PointFromGeoHash()

Section 12.16.10, “Spatial Geohash Functions”

ST_PointFromText()

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

ST_PointFromWKB()

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

ST_PointN()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”
Section 12.16.8, “Spatial Operator Functions”

ST_PolyFromText()

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

ST_PolyFromWKB()

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

ST_PolygonFromText()

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

ST_PolygonFromWKB()

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

ST_Simplify()

Section 12.16.12, “Spatial Convenience Functions”

ST_SRID()

Section 12.16.7.1, “General Geometry Property Functions”
Section 12.16.8, “Spatial Operator Functions”

ST_StartPoint()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”
Section 12.16.8, “Spatial Operator Functions”

ST_SwapXY()

Section 12.16.6, “Geometry Format Conversion Functions”

ST_SymDifference()

Section 12.16.8, “Spatial Operator Functions”

ST_Touches()

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

ST_Transform()

Section 12.16.7.1, “General Geometry Property Functions”
Section 12.16.8, “Spatial Operator Functions”

ST_Union()

Section 12.16.8, “Spatial Operator Functions”

ST_Validate()

Section 12.16.12, “Spatial Convenience Functions”

ST_Within()

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

ST_X()

Section 12.16.7.2, “Point Property Functions”
Section 11.5.3, “Supported Spatial Data Formats”

ST_Y()

Section 12.16.7.2, “Point Property Functions”

STATEMENT_DIGEST()

Section 12.13, “Encryption and Compression Functions”
Section 26.10, “Performance Schema Statement Digests and Sampling”

STATEMENT_DIGEST_TEXT()

Section 12.13, “Encryption and Compression Functions”
Section 26.10, “Performance Schema Statement Digests and Sampling”

STD()

Section 12.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 12.20.1, “Aggregate (GROUP BY) Function Descriptions”

STDDEV_POP()

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

STDDEV_SAMP()

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

STR_TO_DATE()

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

STRCMP()

Section B.4.4.2, “Problems Using DATE Columns”
Section 12.5.1, “String Comparison Functions and Operators”

SUBDATE()

Section 12.7, “Date and Time Functions”

SUBSTR()

Section 12.12, “Bit Functions and Operators”
Section 12.5, “String Functions and Operators”

SUBSTRING()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 13.1.15, “CREATE INDEX Syntax”
Section 12.5, “String Functions and Operators”

SUBSTRING_INDEX()

Section 6.2.22, “SQL-Based Account Activity Auditing”
Section 12.5, “String Functions and Operators”

SUBTIME()

Section 12.7, “Date and Time Functions”

SUM(

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

SUM()

Section 29.4.2, “Adding a New User-Defined Function”
Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 11.1.2, “Date and Time Type Overview”
Section 8.2.1.16, “GROUP BY Optimization”
Section 12.24, “Miscellaneous Functions”
Section 8.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
Section B.4.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 24.5.3, “Updatable and Insertable Views”
Section 1.4, “What Is New in MySQL 8.0”
Section 12.21.2, “Window Function Concepts and Syntax”
Section 12.21.3, “Window Function Frame Specification”

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 17.4.1.14, “Replication and System Functions”
Section 5.1.7, “Server Command Options”
Section 5.1.8, “Server System Variables”

SYSTEM_USER()

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

T

[index top]

TAN()

Section 12.6.2, “Mathematical Functions”

TIME()

Section 12.7, “Date and Time Functions”

TIME_FORMAT()

Section 12.10, “Cast Functions and Operators”
Section 12.7, “Date and Time Functions”

TIME_TO_SEC()

Section 12.7, “Date and Time Functions”
Section 23.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 and Operators”

TO_DAYS()

Section 12.7, “Date and Time Functions”
Section 23.2.4, “HASH Partitioning”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 23.4, “Partition Pruning”
Section 23.6.3, “Partitioning Limitations Relating to Functions”
Section 23.2, “Partitioning Types”

TO_SECONDS()

Section 12.7, “Date and Time Functions”
Section 23.4, “Partition Pruning”
Section 23.6.3, “Partitioning Limitations Relating to Functions”
Section 23.2, “Partitioning Types”

TRIM()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 10.7, “Column Character Set Conversion”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.5, “String Functions and Operators”

TRUNCATE()

Section 12.6.2, “Mathematical Functions”

U

[index top]

UCASE()

Section 12.5.3, “Character Set and Collation of Function Results”
Section 12.5, “String Functions and Operators”

UNCOMPRESS()

Section 12.13, “Encryption and Compression Functions”
Section 2.9.7, “MySQL Source-Configuration Options”
Section 5.1.8, “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 and Operators”

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.3.14, “Indexed Lookups from TIMESTAMP Columns”
Section 23.6.3, “Partitioning Limitations Relating to Functions”
Section 23.2.1, “RANGE Partitioning”
Section 5.1.8, “Server System Variables”
Section 27.4.3.21, “The metrics View”
Section B.4.3.7, “Time Zone Problems”

UpdateXML()

Section 12.11, “XML Functions”

UPPER()

Section 12.10, “Cast Functions and Operators”
Section 12.5.3, “Character Set and Collation of Function Results”
Section 10.2.1, “Character Set Repertoire”
Section 12.5, “String Functions and Operators”
Section 10.10.1, “Unicode Character Sets”
Section 10.8.7, “Using Collation in INFORMATION_SCHEMA Searches”

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.8.4, “Collation Coercibility in Expressions”
Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 29.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
Section 12.15, “Information Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 6.4.3.2, “Password Validation Options and Variables”
Section 6.2.18, “Proxy Users”
Section 17.4.1.14, “Replication and System Functions”
Section 6.2.22, “SQL-Based Account Activity Auditing”
Section 10.2.2, “UTF-8 for Metadata”
Section 29.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 5.1.13, “MySQL Server Time Zone Support”

UUID()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
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.2.1.19, “Function Call Optimization”
Section 12.24, “Miscellaneous Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 28.7.7.69, “mysql_session_track_get_first()”
Section 17.4.1.14, “Replication and System Functions”
Section 24.7, “Stored Program Binary Logging”

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 12.24, “Miscellaneous Functions”

UUID_TO_BIN()

Section 12.12, “Bit Functions and Operators”
Section 12.24, “Miscellaneous Functions”

V

[index top]

VALIDATE_PASSWORD_STRENGTH()

Section 12.13, “Encryption and Compression Functions”
Section 6.4.3.2, “Password Validation Options and Variables”
Section 6.4.3, “The Password Validation Component”
Section 29.2.1, “Types of Plugins”

VALUES()

Section 13.2.6.2, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 12.24, “Miscellaneous Functions”

VAR_POP()

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

VAR_SAMP()

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

VARIANCE()

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

VERSION()

Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 6.4.5.4, “Audit Log File Formats”
Section B.4.4.1, “Case Sensitivity in String Searches”
Section 10.8.4, “Collation Coercibility in Expressions”
Section 12.15, “Information Functions”
Section 17.4.1.14, “Replication and System Functions”
Section 10.2.2, “UTF-8 for Metadata”

W

[index top]

WAIT_FOR_EXECUTED_GTID_SET()

Section 17.2.3.2, “Compatibility with Previous Replication Statements”
Section 12.18, “Functions Used with Global Transaction Identifiers (GTIDs)”
Section 17.1.5.1, “Replication Mode Concepts”
Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”

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.18, “Functions Used with Global Transaction Identifiers (GTIDs)”
Section 17.1.3.7, “Stored Function Examples to Manipulate GTIDs”

WEEK()

Section 12.7, “Date and Time Functions”
Section 5.1.8, “Server System Variables”

WEEKDAY()

Section 12.7, “Date and Time Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 23.6.3, “Partitioning Limitations Relating to Functions”
Section 23.2, “Partitioning Types”

WEEKOFYEAR()

Section 12.7, “Date and Time Functions”

WEIGHT_STRING()

Section 10.13, “Adding a Collation to a Character Set”
Section B.4.4.1, “Case Sensitivity in String Searches”
Section 12.5, “String Functions and Operators”
Section 10.10.1, “Unicode Character Sets”

Y

[index top]

YEAR()

Section 12.7, “Date and Time Functions”
Section 3.3.4.5, “Date Calculations”
Section 23.2.4, “HASH Partitioning”
Section 23.2.7, “How MySQL Partitioning Handles NULL”
Section 23.3.1, “Management of RANGE and LIST Partitions”
Section 23.4, “Partition Pruning”
Section 23.6.3, “Partitioning Limitations Relating to Functions”
Section 23.2, “Partitioning Types”
Section 23.2.1, “RANGE Partitioning”

YEARWEEK()

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