MySQL :: MySQL 8.4 Reference Manual :: Function Index

Skip to Main Content

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

version 8.4

9.1
9.0
8.0
5.7

MySQL 8.4 Reference Manual / Indexes / Function Index

Function Index

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

Symbols

%

Section 1.7.1, “MySQL Extensions to Standard SQL”

A

ABS()

Section 15.7.4.1, “CREATE FUNCTION Statement for Loadable Functions”
Section 14.6.2, “Mathematical Functions”
Section 10.9.6, “Optimizer Statistics”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

ACOS()

Section 14.6.2, “Mathematical Functions”

ADDDATE()

Section 14.7, “Date and Time Functions”

addslashes()

Section 8.1.7, “Client Programming Security Guidelines”

ADDTIME()

Section 14.7, “Date and Time Functions”

AES_DECRYPT()

Section 14.13, “Encryption and Compression Functions”
Section 8.6.3, “MySQL Enterprise Encryption Usage and Examples”
Section 7.1.8, “Server System Variables”

AES_ENCRYPT()

Section 14.13, “Encryption and Compression Functions”
Section 8.6.3, “MySQL Enterprise Encryption Usage and Examples”
Section 7.1.8, “Server System Variables”

ANY_VALUE()

Section 14.19.2, “GROUP BY Modifiers”
Section 14.23, “Miscellaneous Functions”
Section 14.19.3, “MySQL Handling of GROUP BY”

ASCII()

Section 15.8.3, “HELP Statement”
Section 14.8, “String Functions and Operators”

ASIN()

Section 14.6.2, “Mathematical Functions”

asymmetric_decrypt()

Section 8.6.5, “MySQL Enterprise Encryption Component Function Descriptions”

asymmetric_encrypt()

Section 8.6.5, “MySQL Enterprise Encryption Component Function Descriptions”

asymmetric_sign()

Section 8.6.5, “MySQL Enterprise Encryption Component Function Descriptions”

asymmetric_verify()

Section 8.6.5, “MySQL Enterprise Encryption Component Function Descriptions”

asynchronous_connection_failover_add_managed

Section 19.4.9.1, “Asynchronous Connection Failover for Sources”
Section 29.12.11.8, “The replication_asynchronous_connection_failover Table”

asynchronous_connection_failover_add_managed()

Section 19.4.9.2, “Asynchronous Connection Failover for Replicas”
Section 14.18.3, “Asynchronous Replication Channel Failover Functions”
Section 15.4.2.2, “CHANGE REPLICATION SOURCE TO Statement”

asynchronous_connection_failover_add_source

Section 19.4.9.1, “Asynchronous Connection Failover for Sources”
Section 29.12.11.8, “The replication_asynchronous_connection_failover Table”

asynchronous_connection_failover_add_source()

Section 19.4.9.2, “Asynchronous Connection Failover for Replicas”
Section 14.18.3, “Asynchronous Replication Channel Failover Functions”
Section 15.4.2.2, “CHANGE REPLICATION SOURCE TO Statement”

asynchronous_connection_failover_delete_managed

Section 19.4.9.1, “Asynchronous Connection Failover for Sources”
Section 29.12.11.8, “The replication_asynchronous_connection_failover Table”

asynchronous_connection_failover_delete_managed()

Section 19.4.9.2, “Asynchronous Connection Failover for Replicas”
Section 14.18.3, “Asynchronous Replication Channel Failover Functions”
Section 15.4.2.2, “CHANGE REPLICATION SOURCE TO Statement”

asynchronous_connection_failover_delete_source

Section 19.4.9.1, “Asynchronous Connection Failover for Sources”
Section 29.12.11.8, “The replication_asynchronous_connection_failover Table”

asynchronous_connection_failover_delete_source()

Section 19.4.9.2, “Asynchronous Connection Failover for Replicas”
Section 14.18.3, “Asynchronous Replication Channel Failover Functions”
Section 15.4.2.2, “CHANGE REPLICATION SOURCE TO Statement”

asynchronous_connection_failover_reset()

Section 14.18.3, “Asynchronous Replication Channel Failover Functions”

ATAN()

Section 14.6.2, “Mathematical Functions”

ATAN2()

Section 14.6.2, “Mathematical Functions”

audit_api_message_emit_udf()

Section 8.4.6, “The Audit Message Component”
Section 8.4.5.8, “Writing Audit Log Filter Definitions”

audit_log_encryption_password_get()

Section 8.4.5.11, “Audit Log Reference”
Section 8.4.5.5, “Configuring Audit Logging Characteristics”

audit_log_encryption_password_set()

Section 8.4.5.11, “Audit Log Reference”
Section 8.4.5.5, “Configuring Audit Logging Characteristics”

audit_log_filter_flush()

Section 8.4.5.7, “Audit Log Filtering”
Section 8.4.5.11, “Audit Log Reference”

audit_log_filter_remove_filter()

Section 8.4.5.7, “Audit Log Filtering”
Section 8.4.5.11, “Audit Log Reference”

audit_log_filter_remove_user()

Section 8.4.5.7, “Audit Log Filtering”
Section 8.4.5.11, “Audit Log Reference”

audit_log_filter_set_filter()

Section 8.4.5.4, “Audit Log File Formats”
Section 8.4.5.7, “Audit Log Filtering”
Section 8.4.5.11, “Audit Log Reference”
Section 8.4.5.5, “Configuring Audit Logging Characteristics”

audit_log_filter_set_user()

Section 8.4.5.7, “Audit Log Filtering”
Section 8.4.5.11, “Audit Log Reference”

audit_log_read()

Section 8.4.5.11, “Audit Log Reference”
Section 8.4.5.5, “Configuring Audit Logging Characteristics”
Section 8.4.5.6, “Reading Audit Log Files”

audit_log_read_bookmark()

Section 8.4.5.11, “Audit Log Reference”
Section 8.4.5.6, “Reading Audit Log Files”

audit_log_rotate()

Section 8.4.5.11, “Audit Log Reference”
Section 8.4.5.5, “Configuring Audit Logging Characteristics”

AVG(

Section 14.19.1, “Aggregate Function Descriptions”

AVG()

Section 14.19.1, “Aggregate Function Descriptions”
Section 13.2.1, “Date and Time Data Type Syntax”
Section 10.2.1.17, “GROUP BY Optimization”
Section 13.3.5, “The ENUM Type”
Section 1.2.2, “The Main Features of MySQL”
Section 13.3.6, “The SET Type”
Section 14.20.3, “Window Function Frame Specification”

B

BENCHMARK()

Section 14.15, “Information Functions”
Section 10.13.1, “Measuring the Speed of Expressions and Functions”

BIN()

Section 11.1.5, “Bit-Value Literals”
Section 14.8, “String Functions and Operators”

BIN_TO_UUID()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.23, “Miscellaneous Functions”

BIT_AND()

Section 14.19.1, “Aggregate Function Descriptions”
Section 14.12, “Bit Functions and Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”

BIT_COUNT()

Section 14.12, “Bit Functions and Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”

BIT_LENGTH()

Section 14.8, “String Functions and Operators”

BIT_OR()

Section 14.19.1, “Aggregate Function Descriptions”
Section 14.12, “Bit Functions and Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”

BIT_XOR()

Section 14.19.1, “Aggregate Function Descriptions”
Section 14.12, “Bit Functions and Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”

C

CAN_ACCESS_COLUMN()

Section 14.22, “Internal Functions”

CAN_ACCESS_DATABASE()

Section 14.22, “Internal Functions”

CAN_ACCESS_TABLE()

Section 14.22, “Internal Functions”

CAN_ACCESS_USER()

Section 14.22, “Internal Functions”

CAN_ACCESS_VIEW()

Section 14.22, “Internal Functions”

CAST()

Section 14.12, “Bit Functions and Operators”
Section 11.1.5, “Bit-Value Literals”
Section 14.10, “Cast Functions and Operators”
Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.4.2, “Comparison Functions and Operators”
Section 13.2.8, “Conversion Between Date and Time Types”
Section 15.1.15, “CREATE INDEX Statement”
Section 14.7, “Date and Time Functions”
Section 11.5, “Expressions”
Section 14.17.2, “Functions That Create JSON Values”
Section 14.17.3, “Functions That Search JSON Values”
Section 11.1.4, “Hexadecimal Literals”
Section 1.7.2, “MySQL Differences from Standard SQL”
Section 15.5.1, “PREPARE Statement”
Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”
Section 13.5, “The JSON Data Type”
Section 14.3, “Type Conversion in Expression Evaluation”
Section 11.4, “User-Defined Variables”
Section 15.2.20, “WITH (Common Table Expressions)”

CAST(expr AS type

Section 14.10, “Cast Functions and Operators”

CEIL()

Section 14.6.2, “Mathematical Functions”

CEILING()

Section 26.2.4.1, “LINEAR HASH Partitioning”
Section 14.6.2, “Mathematical Functions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

CHAR()

Section 6.5.1.1, “mysql Client Options”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.8, “String Functions and Operators”

CHAR_LENGTH()

Section 14.8, “String Functions and Operators”
Section 12.10.1, “Unicode Character Sets”

CHARACTER_LENGTH()

Section 14.8, “String Functions and Operators”

CHARSET()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.15, “Information Functions”

COALESCE

Section 15.5.1, “PREPARE Statement”

COALESCE()

Section 14.4.2, “Comparison Functions and Operators”
Section 15.2.13.2, “JOIN Clause”
Section 15.5.1, “PREPARE Statement”
Section 15.2.20, “WITH (Common Table Expressions)”

COERCIBILITY()

Section 12.8.4, “Collation Coercibility in Expressions”
Section 14.15, “Information Functions”

COLLATION()

Section B.3.4.1, “Case Sensitivity in String Searches”
Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.15, “Information Functions”

COMPRESS()

Section 14.13, “Encryption and Compression Functions”
Section 2.8.7, “MySQL Source-Configuration Options”
Section 7.1.8, “Server System Variables”

CONCAT()

Section 14.19.1, “Aggregate Function Descriptions”
Section 14.10, “Cast Functions and Operators”
Section 14.8.3, “Character Set and Collation of Function Results”
Section 12.2.1, “Character Set Repertoire”
Section 12.8.4, “Collation Coercibility in Expressions”
Section 15.7.4.1, “CREATE FUNCTION Statement for Loadable Functions”
Section 14.4.3, “Logical Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 7.1.11, “Server SQL Modes”
Section 15.7.7.14, “SHOW CREATE VIEW Statement”
Section 14.8, “String Functions and Operators”
Section 28.3.47, “The INFORMATION_SCHEMA VIEWS Table”
Section 14.3, “Type Conversion in Expression Evaluation”
Section 14.11, “XML Functions”

CONCAT_WS()

Section 14.19.1, “Aggregate Function Descriptions”
Section 14.8, “String Functions and Operators”

CONNECTION_ID()

Section 8.4.5.4, “Audit Log File Formats”
Section 15.1.20.6, “CHECK Constraints”
Section 15.1.20.8, “CREATE TABLE and Generated Columns”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 14.15, “Information Functions”
Section 15.7.8.4, “KILL Statement”
Section 6.5.1.3, “mysql Client Logging”
Section 14.21, “Performance Schema Functions”
Section 7.1.8, “Server System Variables”
Section 15.7.7.31, “SHOW PROCESSLIST Statement”
Section 29.12.22.2, “The error_log Table”
Section 28.3.23, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 29.12.22.7, “The processlist Table”
Section 29.12.22.8, “The threads Table”
Section 29.12.16.1, “The tp_connections Table”

CONV()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.6.2, “Mathematical Functions”
Section 14.8, “String Functions and Operators”

CONVERT()

Section 14.10, “Cast Functions and Operators”
Section 12.3.8, “Character Set Introducers”
Section 12.3.6, “Character String Literal Character Set and Collation”
Section 14.4.2, “Comparison Functions and Operators”
Section A.11, “MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 6.5.1.1, “mysql Client Options”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

CONVERT_TZ()

Section 14.7, “Date and Time Functions”
Section 10.3.14, “Indexed Lookups from TIMESTAMP Columns”
Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”
Section 7.1.8, “Server System Variables”
Section 7.4.3, “The General Query Log”
Section 7.4.5, “The Slow Query Log”

COS()

Section 14.6.2, “Mathematical Functions”

COT()

Section 14.6.2, “Mathematical Functions”

COUNT()

Section 14.19.1, “Aggregate Function Descriptions”
Section 15.2.15.7, “Correlated Subqueries”
Section 5.3.4.8, “Counting Rows”
Section 15.7.4.1, “CREATE FUNCTION Statement for Loadable Functions”
Section 10.2.1.17, “GROUP BY Optimization”
Section 14.15, “Information Functions”
Section 17.22, “InnoDB Restrictions and Limitations”
Section 10.4.4, “Internal Temporary Table Use in MySQL”
Section 25.2.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 14.23, “Miscellaneous Functions”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 25.4.3.9.3, “NDB Cluster Status Variables”
Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
Section B.3.4.3, “Problems with NULL Values”
Section 7.1.11, “Server SQL Modes”
Section 1.2.2, “The Main Features of MySQL”
Section 27.5.3, “Updatable and Insertable Views”
Section 10.2.1.1, “WHERE Clause Optimization”

CRC32()

Section 14.6.2, “Mathematical Functions”

create_asymmetric_priv_key()

Section 8.6.5, “MySQL Enterprise Encryption Component Function Descriptions”

create_asymmetric_pub_key()

Section 8.6.5, “MySQL Enterprise Encryption Component Function Descriptions”

create_digest()

Section 8.6.5, “MySQL Enterprise Encryption Component Function Descriptions”

CUME_DIST()

Section 14.20.1, “Window Function Descriptions”

CURDATE()

Section 14.7, “Date and Time Functions”
Section 5.3.4.5, “Date Calculations”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”

CURRENT_DATE

Section 14.7, “Date and Time Functions”

CURRENT_DATE()

Section 13.2.8, “Conversion Between Date and Time Types”
Section 14.7, “Date and Time Functions”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”

CURRENT_ROLE()

Section 14.15, “Information Functions”
Section 8.2.10, “Using Roles”

CURRENT_TIME

Section 14.7, “Date and Time Functions”

CURRENT_TIME()

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

CURRENT_TIMESTAMP

Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 15.1.13, “CREATE EVENT Statement”
Section 15.1.20.8, “CREATE TABLE and Generated Columns”
Section 13.6, “Data Type Default Values”
Section 14.7, “Date and Time Functions”
Section 7.1.8, “Server System Variables”

CURRENT_TIMESTAMP()

Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 14.7, “Date and Time Functions”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”

CURRENT_USER

Section 15.7.1.1, “ALTER USER Statement”
Section 15.1.13, “CREATE EVENT Statement”
Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 15.1.22, “CREATE TRIGGER Statement”
Section 15.1.23, “CREATE VIEW Statement”
Section 15.7.1.6, “GRANT Statement”
Section 8.2.3, “Grant Tables”
Section 14.15, “Information Functions”
Section 7.4.4.3, “Mixed Binary Logging Format”
Section 19.5.1.14, “Replication and System Functions”
Section 19.5.1.8, “Replication of CURRENT_USER()”
Section 15.7.7.13, “SHOW CREATE USER Statement”
Section 8.2.4, “Specifying Account Names”
Section 27.6, “Stored Object Access Control”

CURRENT_USER()

Section 8.2.6, “Access Control, Stage 1: Connection Verification”
Section 15.7.1.1, “ALTER USER Statement”
Section 8.4.5.4, “Audit Log File Formats”
Section 15.1.20.6, “CHECK Constraints”
Section 8.4.2.1, “Connection-Control Plugin Installation”
Section 15.1.13, “CREATE EVENT Statement”
Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 15.1.20.8, “CREATE TABLE and Generated Columns”
Section 15.1.22, “CREATE TRIGGER Statement”
Section 15.1.23, “CREATE VIEW Statement”
Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”
Section 15.7.1.6, “GRANT Statement”
Section 14.15, “Information Functions”
Section 8.4.1.7, “LDAP Pluggable Authentication”
Section 7.4.4.3, “Mixed Binary Logging Format”
Section 8.2.15, “Password Management”
Section 8.4.3.2, “Password Validation Options and Variables”
Section 8.2.19, “Proxy Users”
Section 19.5.1.14, “Replication and System Functions”
Section 19.5.1.8, “Replication of CURRENT_USER()”
Section 15.7.1.10, “SET PASSWORD Statement”
Section 15.7.7.13, “SHOW CREATE USER Statement”
Section 8.2.4, “Specifying Account Names”
Section 8.2.5, “Specifying Role Names”
Section 8.2.23, “SQL-Based Account Activity Auditing”
Section 27.6, “Stored Object Access Control”
Section 7.6.9.2, “The Keyring Service”
Section 12.2.2, “UTF-8 for Metadata”

CURTIME()

Section 14.7, “Date and Time Functions”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.1.15, “MySQL Server Time Zone Support”

D

DATABASE()

Section 5.3.1, “Creating and Selecting a Database”
Section 15.1.24, “DROP DATABASE Statement”
Section 5.4, “Getting Information About Databases and Tables”
Section 14.15, “Information Functions”
Section B.3.7, “Known Issues in MySQL”
Section 12.2.2, “UTF-8 for Metadata”

DATE()

Section 14.7, “Date and Time Functions”

DATE_ADD()

Section 14.6.1, “Arithmetic Operators”
Section 13.2, “Date and Time Data Types”
Section 14.7, “Date and Time Functions”
Section 5.3.4.5, “Date Calculations”
Section 11.5, “Expressions”
Section 14.20.3, “Window Function Frame Specification”

DATE_FORMAT()

Section 14.10, “Cast Functions and Operators”
Section 14.7, “Date and Time Functions”
Section 12.16, “MySQL Server Locale Support”
Section 7.1.8, “Server System Variables”

DATE_SUB()

Section 13.2, “Date and Time Data Types”
Section 14.7, “Date and Time Functions”
Section 11.5, “Expressions”

DATEDIFF()

Section 14.7, “Date and Time Functions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

DAY()

Section 14.7, “Date and Time Functions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

DAYNAME()

Section 14.7, “Date and Time Functions”
Section 12.16, “MySQL Server Locale Support”
Section 7.1.8, “Server System Variables”

DAYOFMONTH()

Section 14.7, “Date and Time Functions”
Section 5.3.4.5, “Date Calculations”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

DAYOFWEEK()

Section 14.7, “Date and Time Functions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

DAYOFYEAR()

Section 14.7, “Date and Time Functions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”
Section 26.2, “Partitioning Types”

DEFAULT()

Section 15.1.9.2, “ALTER TABLE and Generated Columns”
Section 13.6, “Data Type Default Values”
Section 15.2.7, “INSERT Statement”
Section 14.23, “Miscellaneous Functions”
Section 15.2.12, “REPLACE Statement”

DEGREES()

Section 14.6.2, “Mathematical Functions”

DENSE_RANK()

Section 14.20.1, “Window Function Descriptions”

E

ELT()

Section 14.8.3, “Character Set and Collation of Function Results”
Section B.3.7, “Known Issues in MySQL”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.8, “String Functions and Operators”

EXP()

Section 15.1.20, “CREATE TABLE Statement”
Section 14.6.2, “Mathematical Functions”

EXPORT_SET()

Section 14.8, “String Functions and Operators”

EXTRACT()

Section 14.10, “Cast Functions and Operators”
Section 14.7, “Date and Time Functions”
Section 11.5, “Expressions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

ExtractValue()

Section 14.11, “XML Functions”

F

FIELD()

Section 14.8, “String Functions and Operators”

FIND_IN_SET()

Section 14.8, “String Functions and Operators”
Section 13.3.6, “The SET Type”

firewall_group_delist()

Section 8.4.7.4, “MySQL Enterprise Firewall Reference”

firewall_group_enlist()

Section 8.4.7.4, “MySQL Enterprise Firewall Reference”

FIRST_VALUE()

Section 14.20.1, “Window Function Descriptions”
Section 14.20.3, “Window Function Frame Specification”

FLOOR()

Section 14.6.2, “Mathematical Functions”
Section 14.19.3, “MySQL Handling of GROUP BY”
Section 10.9.6, “Optimizer Statistics”
Section 26.6.3, “Partitioning Limitations Relating to Functions”
Section 7.1.8, “Server System Variables”

flush_rewrite_rules()

Section 7.6.4.3.2, “Rewriter Query Rewrite Plugin Procedures and Functions”

FORMAT()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.6.2, “Mathematical Functions”
Section 14.23, “Miscellaneous Functions”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 12.16, “MySQL Server Locale Support”
Section 14.8, “String Functions and Operators”

FORMAT_BYTES()

Section 14.21, “Performance Schema Functions”
Section 30.4.5.3, “The format_bytes() Function”

FORMAT_PICO_TIME()

Section 14.21, “Performance Schema Functions”
Section 30.4.5.6, “The format_time() Function”

FOUND_ROWS()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 14.15, “Information Functions”
Section 7.4.4.3, “Mixed Binary Logging Format”
Section 19.5.1.14, “Replication and System Functions”
Section 15.2.13, “SELECT Statement”

FROM_BASE64()

Section 14.8, “String Functions and Operators”

FROM_DAYS()

Section 14.7, “Date and Time Functions”
Section 1.7.1, “MySQL Extensions to Standard SQL”

FROM_UNIXTIME()

Section 14.7, “Date and Time Functions”
Section 7.4.2.9, “Error Log Output Format”
Section 10.3.14, “Indexed Lookups from TIMESTAMP Columns”
Section 19.5.1.33, “Replication and Time Zones”

G

gen_blacklist()

Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”

gen_blocklist()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

gen_dictionary()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

gen_dictionary_drop()

Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”

gen_dictionary_load()

Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

gen_range()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

gen_rnd_canada_sin()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”

gen_rnd_email()

Section 8.5.1, “Data-Masking Components Versus the Data-Masking Plugin”
Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

gen_rnd_iban()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”

gen_rnd_pan()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

gen_rnd_ssn()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

gen_rnd_uk_nin()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”

gen_rnd_us_phone()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

gen_rnd_uuid()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”

GeomCollection()

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

GeometryCollection()

Section 14.16.6, “Geometry Format Conversion Functions”
Section 14.16.5, “MySQL-Specific Functions That Create Geometry Values”

GET_DD_COLUMN_PRIVILEGES()

Section 14.22, “Internal Functions”

GET_DD_CREATE_OPTIONS()

Section 14.22, “Internal Functions”

GET_DD_INDEX_SUB_PART_LENGTH()

Section 14.22, “Internal Functions”

GET_FORMAT()

Section 14.7, “Date and Time Functions”
Section 12.16, “MySQL Server Locale Support”

GET_LOCK()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.1.13, “CREATE EVENT Statement”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 27.4.1, “Event Scheduler Overview”
Section 10.14.3, “General Thread States”
Section 20.3.2, “Group Replication Limitations”
Section 10.11.1, “Internal Locking Methods”
Section 15.7.8.4, “KILL Statement”
Section 25.2.7.10, “Limitations Relating to Multiple NDB Cluster Nodes”
Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”
Section 14.14, “Locking Functions”
Section 10.11.4, “Metadata Locking”
Section 19.5.1.14, “Replication and System Functions”
Section 7.6.9.1, “The Locking Service”
Section 7.6.9.1.2, “The Locking Service Function Interface”
Section 29.12.13.3, “The metadata_locks Table”
Section 30.4.4.14, “The ps_setup_save() Procedure”

getrusage()

Section 25.6.17.64, “The ndbinfo threadstat Table”

gettimeofday()

Section 25.6.17.64, “The ndbinfo threadstat Table”

GREATEST()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.4.2, “Comparison Functions and Operators”
Section 13.5, “The JSON Data Type”

GROUP_CONCAT()

Section 14.19.1, “Aggregate Function Descriptions”
Section 10.4.4, “Internal Temporary Table Use in MySQL”
Section B.3.7, “Known Issues in MySQL”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 7.1.8, “Server System Variables”
Section 13.5, “The JSON Data Type”
Section 1.2.2, “The Main Features of MySQL”

group_replication_disable_member_action

Section 19.4.9.2, “Asynchronous Connection Failover for Replicas”
Section 14.18.3, “Asynchronous Replication Channel Failover Functions”
Section 20.5.1.5, “Configuring Member Actions”
Section 14.18.1.5, “Functions to Set and Reset Group Replication Member Actions”
Section 19.4.9, “Switching Sources and Replicas with Asynchronous Connection Failover”

group_replication_disable_member_action()

Section 15.4.2.2, “CHANGE REPLICATION SOURCE TO Statement”
Section 20.5.1.5, “Configuring Member Actions”
Section 14.18.1.5, “Functions to Set and Reset Group Replication Member Actions”
Section 29.12.11.12, “The replication_group_configuration_version Table”
Section 29.12.11.14, “The replication_group_member_actions Table”

group_replication_enable_member_action

Section 20.5.1.5, “Configuring Member Actions”
Section 14.18.1.5, “Functions to Set and Reset Group Replication Member Actions”

group_replication_enable_member_action()

Section 14.18.1.5, “Functions to Set and Reset Group Replication Member Actions”
Section 29.12.11.12, “The replication_group_configuration_version Table”
Section 29.12.11.14, “The replication_group_member_actions Table”

group_replication_get_communication_protocol()

Section 14.18.1.4, “Functions to Inspect and Set the Group Replication Communication Protocol Version”
Section 20.9.1, “Group Replication System Variables”
Section 20.7.5, “Message Fragmentation”
Section 20.5.1.4, “Setting a Group's Communication Protocol Version”
Section 20.7.3, “Single Consensus Leader”

group_replication_get_write_concurrency()

Section 14.18.1.3, “Functions to Inspect and Configure the Maximum Consensus Instances of a Group”
Section 20.5.1.3, “Using Group Replication Group Write Consensus”

group_replication_reset_member_actions

Section 20.5.1.5, “Configuring Member Actions”
Section 14.18.1.5, “Functions to Set and Reset Group Replication Member Actions”

group_replication_reset_member_actions()

Section 14.18.1.5, “Functions to Set and Reset Group Replication Member Actions”
Section 29.12.11.12, “The replication_group_configuration_version Table”
Section 29.12.11.14, “The replication_group_member_actions Table”

group_replication_set_as_primary()

Section 20.5.1.1, “Changing the Primary”
Section 14.18.1.1, “Function which Configures Group Replication Primary”
Section 20.8.3.3, “Group Replication Online Upgrade Methods”
Section 20.8.1.1, “Member Versions During Upgrades”
Section 20.1.3.1, “Single-Primary Mode”
Section 20.5.3.1, “Understanding Transaction Consistency Guarantees”
Section 1.4, “What Is New in MySQL 8.4 since MySQL 8.0”

group_replication_set_communication_protocol()

Section 14.18.1.4, “Functions to Inspect and Set the Group Replication Communication Protocol Version”
Section 20.8.2, “Group Replication Offline Upgrade”
Section 20.9.1, “Group Replication System Variables”
Section 20.7.5, “Message Fragmentation”
Section 8.2.2, “Privileges Provided by MySQL”
Section 20.5.1.4, “Setting a Group's Communication Protocol Version”
Section 20.7.3, “Single Consensus Leader”

group_replication_set_write_concurrency()

Section 14.18.1.3, “Functions to Inspect and Configure the Maximum Consensus Instances of a Group”
Section 8.2.2, “Privileges Provided by MySQL”
Section 20.5.1.3, “Using Group Replication Group Write Consensus”

group_replication_switch_to_multi_primary_mode()

Section 20.5.1.2, “Changing the Group Mode”
Section 20.8.1, “Combining Different Member Versions in a Group”
Section 14.18.1.2, “Functions which Configure the Group Replication Mode”
Section 20.9.1, “Group Replication System Variables”
Section 20.1.3, “Multi-Primary and Single-Primary Modes”
Section 20.1.3.2.3, “Version Compatibility”

group_replication_switch_to_single_primary_mode()

Section 20.5.1.2, “Changing the Group Mode”
Section 14.18.1.2, “Functions which Configure the Group Replication Mode”
Section 20.9.1, “Group Replication System Variables”
Section 20.1.3, “Multi-Primary and Single-Primary Modes”
Section 20.1.3.1, “Single-Primary Mode”

GROUPING()

Section 14.19.2, “GROUP BY Modifiers”
Section 14.23, “Miscellaneous Functions”
Section 14.20.2, “Window Function Concepts and Syntax”

GTID_SUBSET()

Section 14.18.2, “Functions Used with Global Transaction Identifiers (GTIDs)”
Section 19.1.3.1, “GTID Format and Storage”
Section 19.1.3.8, “Stored Function Examples to Manipulate GTIDs”
Section 1.4, “What Is New in MySQL 8.4 since MySQL 8.0”

GTID_SUBTRACT()

Section 14.18.2, “Functions Used with Global Transaction Identifiers (GTIDs)”
Section 19.1.6.5, “Global Transaction ID System Variables”
Section 19.1.3.1, “GTID Format and Storage”
Section 19.1.3.8, “Stored Function Examples to Manipulate GTIDs”
Section 1.4, “What Is New in MySQL 8.4 since MySQL 8.0”

H

HEX()

Section 11.1.5, “Bit-Value Literals”
Section 14.8.3, “Character Set and Collation of Function Results”
Section 12.3.6, “Character String Literal Character Set and Collation”
Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”
Section 11.1.4, “Hexadecimal Literals”
Section 14.6.2, “Mathematical Functions”
Section 14.23, “Miscellaneous Functions”
Section 14.8, “String Functions and Operators”

HOUR()

Section 14.7, “Date and Time Functions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

I

ICU_VERSION()

Section 14.15, “Information Functions”

IF

Section 15.5.1, “PREPARE Statement”

IF()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.5, “Flow Control Functions”
Section 15.6.5.2, “IF Statement”
Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section B.3.7, “Known Issues in MySQL”
Section 1.7.1, “MySQL Extensions to Standard SQL”

IFNULL

Section 15.5.1, “PREPARE Statement”

IFNULL()

Section 14.5, “Flow Control Functions”
Section B.3.4.3, “Problems with NULL Values”

INET6_ATON()

Section 7.1.13, “IPv6 Support”
Section 14.23, “Miscellaneous Functions”

INET6_NTOA()

Section 7.1.13, “IPv6 Support”
Section 14.23, “Miscellaneous Functions”

INET_ATON()

Section 7.1.13, “IPv6 Support”
Section 14.23, “Miscellaneous Functions”

INET_NTOA()

Section 7.1.13, “IPv6 Support”
Section 14.23, “Miscellaneous Functions”

INSERT()

Section 14.8, “String Functions and Operators”

INSTR()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

INTERNAL_AUTO_INCREMENT()

Section 14.22, “Internal Functions”

INTERNAL_AVG_ROW_LENGTH()

Section 14.22, “Internal Functions”

INTERNAL_CHECK_TIME()

Section 14.22, “Internal Functions”

INTERNAL_CHECKSUM()

Section 14.22, “Internal Functions”

INTERNAL_DATA_FREE()

Section 14.22, “Internal Functions”

INTERNAL_DATA_LENGTH()

Section 14.22, “Internal Functions”

INTERNAL_DD_CHAR_LENGTH()

Section 14.22, “Internal Functions”

INTERNAL_GET_COMMENT_OR_ERROR()

Section 14.22, “Internal Functions”

INTERNAL_GET_ENABLED_ROLE_JSON()

Section 14.22, “Internal Functions”

INTERNAL_GET_HOSTNAME()

Section 14.22, “Internal Functions”

INTERNAL_GET_USERNAME()

Section 14.22, “Internal Functions”

INTERNAL_GET_VIEW_WARNING_OR_ERROR()

Section 14.22, “Internal Functions”

INTERNAL_INDEX_COLUMN_CARDINALITY()

Section 14.22, “Internal Functions”

INTERNAL_INDEX_LENGTH()

Section 14.22, “Internal Functions”

INTERNAL_IS_ENABLED_ROLE()

Section 14.22, “Internal Functions”

INTERNAL_IS_MANDATORY_ROLE()

Section 14.22, “Internal Functions”

INTERNAL_KEYS_DISABLED()

Section 14.22, “Internal Functions”

INTERNAL_MAX_DATA_LENGTH()

Section 14.22, “Internal Functions”

INTERNAL_TABLE_ROWS()

Section 14.22, “Internal Functions”

INTERNAL_UPDATE_TIME()

Section 14.22, “Internal Functions”

INTERVAL()

Section 14.4.2, “Comparison Functions and Operators”

IS_FREE_LOCK()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 14.14, “Locking Functions”
Section 19.5.1.14, “Replication and System Functions”

IS_IPV4()

Section 14.23, “Miscellaneous Functions”

IS_IPV4_COMPAT()

Section 14.23, “Miscellaneous Functions”

IS_IPV4_MAPPED()

Section 14.23, “Miscellaneous Functions”

IS_IPV6()

Section 14.23, “Miscellaneous Functions”

IS_USED_LOCK()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 14.14, “Locking Functions”
Section 19.5.1.14, “Replication and System Functions”

IS_UUID()

Section 14.23, “Miscellaneous Functions”

IS_VISIBLE_DD_OBJECT()

Section 14.22, “Internal Functions”

ISNULL()

Section 14.4.2, “Comparison Functions and Operators”

J

JSON_ARRAY()

Section 14.17.2, “Functions That Create JSON Values”
Section 14.17.3, “Functions That Search JSON Values”
Section 13.5, “The JSON Data Type”

JSON_ARRAY_APPEND()

Section 14.17.4, “Functions That Modify JSON Values”

JSON_ARRAY_INSERT()

Section 14.17.4, “Functions That Modify JSON Values”

JSON_ARRAYAGG()

Section 14.19.1, “Aggregate Function Descriptions”
Section 14.17.2, “Functions That Create JSON Values”
Section 14.17.1, “JSON Function Reference”

JSON_CONTAINS()

Section 15.1.15, “CREATE INDEX Statement”
Section 14.17.3, “Functions That Search JSON Values”

JSON_CONTAINS_PATH()

Section 14.17.3, “Functions That Search JSON Values”
Section 13.5, “The JSON Data Type”

JSON_DEPTH()

Section 14.17.5, “Functions That Return JSON Value Attributes”

JSON_EXTRACT()

Section 15.8.2, “EXPLAIN Statement”
Section 14.17.3, “Functions That Search JSON Values”
Section 14.17.7, “JSON Schema Validation Functions”
Section 15.1.20.9, “Secondary Indexes and Generated Columns”
Section 13.5, “The JSON Data Type”

JSON_INSERT()

Section 14.17.4, “Functions That Modify JSON Values”
Section 13.5, “The JSON Data Type”

JSON_KEYS()

Section 14.17.3, “Functions That Search JSON Values”
Section 8.2.3, “Grant Tables”

JSON_LENGTH()

Section 14.17.5, “Functions That Return JSON Value Attributes”

JSON_MERGE()

Section 14.17.4, “Functions That Modify JSON Values”

JSON_MERGE_PATCH()

Section 15.7.1.1, “ALTER USER Statement”
Section 14.17.4, “Functions That Modify JSON Values”
Section 13.5, “The JSON Data Type”

JSON_MERGE_PRESERVE()

Section 14.17.4, “Functions That Modify JSON Values”
Section 13.5, “The JSON Data Type”

JSON_OBJECT()

Section 14.17.2, “Functions That Create JSON Values”
Section 14.17.3, “Functions That Search JSON Values”
Section 13.5, “The JSON Data Type”

JSON_OBJECTAGG()

Section 14.19.1, “Aggregate Function Descriptions”
Section 14.17.2, “Functions That Create JSON Values”
Section 14.17.1, “JSON Function Reference”

JSON_OVERLAPS()

Section 15.1.15, “CREATE INDEX Statement”
Section 14.17.3, “Functions That Search JSON Values”

JSON_PRETTY()

Section 14.17.1, “JSON Function Reference”
Section 14.17.7, “JSON Schema Validation Functions”
Section 14.17.8, “JSON Utility Functions”

JSON_QUOTE()

Section 14.17.2, “Functions That Create JSON Values”
Section 14.17.8, “JSON Utility Functions”

JSON_REMOVE()

Section 19.1.6.4, “Binary Logging Options and Variables”
Section 14.17.4, “Functions That Modify JSON Values”
Section 14.17.8, “JSON Utility Functions”
Section 13.5, “The JSON Data Type”

JSON_REPLACE()

Section 19.1.6.4, “Binary Logging Options and Variables”
Section 14.17.4, “Functions That Modify JSON Values”
Section 14.17.8, “JSON Utility Functions”
Section 13.5, “The JSON Data Type”

JSON_SCHEMA_VALID()

Section 14.17.7, “JSON Schema Validation Functions”

JSON_SCHEMA_VALIDATION_REPORT()

Section 14.17.7, “JSON Schema Validation Functions”

JSON_SEARCH()

Section 14.17.3, “Functions That Search JSON Values”
Section 13.5, “The JSON Data Type”

JSON_SET()

Section 19.1.6.4, “Binary Logging Options and Variables”
Section 14.17.4, “Functions That Modify JSON Values”
Section 14.17.8, “JSON Utility Functions”
Section 13.5, “The JSON Data Type”

JSON_STORAGE_FREE()

Section 14.17.1, “JSON Function Reference”
Section 14.17.8, “JSON Utility Functions”
Section 13.5, “The JSON Data Type”

JSON_STORAGE_SIZE()

Section 14.17.1, “JSON Function Reference”
Section 14.17.8, “JSON Utility Functions”
Section 13.5, “The JSON Data Type”

JSON_TABLE()

Section 15.2.15.8, “Derived Tables”
Section 14.17.6, “JSON Table Functions”
Section 15.2.15.9, “Lateral Derived Tables”

JSON_TYPE()

Section 14.17.5, “Functions That Return JSON Value Attributes”
Section 14.17.3, “Functions That Search JSON Values”
Section 13.5, “The JSON Data Type”

JSON_UNQUOTE(

Section 14.17.3, “Functions That Search JSON Values”

JSON_UNQUOTE()

Section 15.1.15, “CREATE INDEX Statement”
Section 14.17.4, “Functions That Modify JSON Values”
Section 10.3.11, “Optimizer Use of Generated Column Indexes”
Section 15.1.20.9, “Secondary Indexes and Generated Columns”
Section 13.5, “The JSON Data Type”

JSON_VALID()

Section 14.17.5, “Functions That Return JSON Value Attributes”

JSON_VALUE()

Section 14.10, “Cast Functions and Operators”
Section 14.17.3, “Functions That Search JSON Values”
Section 15.1.20.9, “Secondary Indexes and Generated Columns”

K

keyring_aws_rotate_cmk()

Section 8.4.4.13, “Plugin-Specific Keyring Key-Management Functions”
Section 8.4.4.7, “Using the keyring_aws Amazon Web Services Keyring Plugin”

keyring_aws_rotate_keys()

Section 8.4.4.13, “Plugin-Specific Keyring Key-Management Functions”
Section 8.4.4.7, “Using the keyring_aws Amazon Web Services Keyring Plugin”

keyring_hashicorp_update_config()

Section 8.4.4.13, “Plugin-Specific Keyring Key-Management Functions”
Section 8.4.4.8, “Using the HashiCorp Vault Keyring Plugin”

keyring_key_fetch()

Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”

keyring_key_generate()

Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”

keyring_key_length_fetch()

Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”

keyring_key_remove()

Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”

keyring_key_store()

Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”

keyring_key_type_fetch()

Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”

L

LAG()

Section 14.20.1, “Window Function Descriptions”

LAST_DAY()

Section 14.7, “Date and Time Functions”

LAST_INSERT_ID()

Section 14.4.2, “Comparison Functions and Operators”
Section 15.1.20, “CREATE TABLE Statement”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 14.15, “Information Functions”
Section 15.2.7.2, “INSERT ... ON DUPLICATE KEY UPDATE Statement”
Section 15.2.7, “INSERT Statement”
Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 25.5.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 19.5.1.1, “Replication and AUTO_INCREMENT”
Section 7.1.8, “Server System Variables”
Section 19.1.7.3.2.1, “Skipping Transactions With SET GLOBAL sql_replica_skip_counter”
Section 27.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()”
Section 19.5.4, “Troubleshooting Replication”
Section 27.5.3, “Updatable and Insertable Views”
Section 5.6.9, “Using AUTO_INCREMENT”

LAST_VALUE()

Section 14.20.1, “Window Function Descriptions”
Section 14.20.3, “Window Function Frame Specification”

LCASE()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

LEAD()

Section 14.20.1, “Window Function Descriptions”

LEAST()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.4.2, “Comparison Functions and Operators”
Section 13.5, “The JSON Data Type”

LEFT()

Section 14.8, “String Functions and Operators”

LENGTH

Section 7.1.8, “Server System Variables”

LENGTH()

Section 13.7, “Data Type Storage Requirements”
Section 14.8, “String Functions and Operators”
Section 13.4.3, “Supported Spatial Data Formats”

LineString()

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

LN()

Section 14.6.2, “Mathematical Functions”

LOAD_FILE()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 15.2.10, “LOAD XML Statement”
Section 7.4.4.3, “Mixed Binary Logging Format”
Section 8.6.3, “MySQL Enterprise Encryption Usage and Examples”
Section 8.2.2, “Privileges Provided by MySQL”
Section 19.5.1.14, “Replication and System Functions”
Section 7.1.8, “Server System Variables”
Section 14.8, “String Functions and Operators”

load_rewrite_rules()

Section 7.6.4.3.2, “Rewriter Query Rewrite Plugin Procedures and Functions”
Section 7.6.4, “The Rewriter Query Rewrite Plugin”

LOCALTIME

Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 14.7, “Date and Time Functions”

LOCALTIME()

Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 14.7, “Date and Time Functions”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”

LOCALTIMESTAMP

Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 14.7, “Date and Time Functions”

LOCALTIMESTAMP()

Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 14.7, “Date and Time Functions”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”

LOCATE()

Section 14.8, “String Functions and Operators”

LOG()

Section 26.2.4.1, “LINEAR HASH Partitioning”
Section 14.6.2, “Mathematical Functions”

LOG10()

Section 14.6.2, “Mathematical Functions”

LOG2()

Section 14.6.2, “Mathematical Functions”

LOWER()

Section 14.10, “Cast Functions and Operators”
Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”
Section 12.10.1, “Unicode Character Sets”
Section 12.8.7, “Using Collation in INFORMATION_SCHEMA Searches”

LPAD()

Section 14.12, “Bit Functions and Operators”
Section 13.1.1, “Numeric Data Type Syntax”
Section 13.1.6, “Numeric Type Attributes”
Section 14.8, “String Functions and Operators”

LTRIM()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

M

MAKE_SET()

Section 14.8, “String Functions and Operators”

MAKEDATE()

Section 14.7, “Date and Time Functions”

MAKETIME()

Section 14.7, “Date and Time Functions”

mask_canada_sin()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”

mask_iban()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”

mask_inner

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”

mask_inner()

Section 8.5.1, “Data-Masking Components Versus the Data-Masking Plugin”
Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

mask_outer

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”

mask_outer()

Section 8.5.1, “Data-Masking Components Versus the Data-Masking Plugin”
Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

mask_pan()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

mask_pan_relaxed()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

mask_ssn()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.3.4, “MySQL Enterprise Data Masking and De-Identification Plugin Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”
Section 8.5.3.2, “Using the MySQL Enterprise Data Masking and De-Identification Plugin”

mask_uk_nin()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”

mask_uuid()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.5.2.2, “Using MySQL Enterprise Data Masking and De-Identification Components”

masking_dictionaries_flush()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 1.4, “What Is New in MySQL 8.4 since MySQL 8.0”

masking_dictionary_remove()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.2.2, “Privileges Provided by MySQL”

masking_dictionary_term_add()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.2.2, “Privileges Provided by MySQL”

masking_dictionary_term_remove()

Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 8.2.2, “Privileges Provided by MySQL”

MASTER_POS_WAIT()

Section A.14, “MySQL 8.4 FAQ: Replication”
Section 14.18.4, “Position-Based Synchronization Functions”

MATCH

Section 11.5, “Expressions”

MATCH ()

Section 14.9, “Full-Text Search Functions”

MATCH()

Section 14.9.2, “Boolean Full-Text Searches”
Section 14.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 14.9.5, “Full-Text Restrictions”
Section 14.9, “Full-Text Search Functions”
Section 14.19.2, “GROUP BY Modifiers”
Section 17.6.2.4, “InnoDB Full-Text Indexes”
MySQL Glossary
Section 14.9.1, “Natural Language Full-Text Searches”

MAX(

Section 14.19.1, “Aggregate Function Descriptions”

MAX()

Section 13.2.9, “2-Digit Years in Dates”
Section 14.19.1, “Aggregate Function Descriptions”
Section 10.3.13, “Descending Indexes”
Section 10.2.1.17, “GROUP BY Optimization”
Section 10.3.1, “How MySQL Uses Indexes”
Section B.3.7, “Known Issues in MySQL”
Section 25.5.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 13.1.1, “Numeric Data Type Syntax”
Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
Section 7.1.11, “Server SQL Modes”
Section 10.9.2, “Switchable Optimizations”
Section 13.5, “The JSON Data Type”
Section 1.2.2, “The Main Features of MySQL”
Section 29.12.16.2, “The tp_thread_group_state Table”
Section 27.5.3, “Updatable and Insertable Views”
Section 10.3.10, “Use of Index Extensions”
Section 5.6.9, “Using AUTO_INCREMENT”
Section 10.2.1.21, “Window Function Optimization”
Section 15.2.20, “WITH (Common Table Expressions)”

MBRContains()

Section 14.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”
Section 13.4.11, “Using Spatial Indexes”

MBRCoveredBy()

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

MBRCovers()

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

MBRDisjoint()

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

MBREquals()

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

MBRIntersects()

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

MBROverlaps()

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

MBRTouches()

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

MBRWithin()

Section 14.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”
Section 13.4.11, “Using Spatial Indexes”

MD5()

Section 14.13, “Encryption and Compression Functions”
Section 26.2.5, “KEY Partitioning”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 11.2, “Schema Object Names”

MICROSECOND()

Section 14.7, “Date and Time Functions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

MID()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

MIN(

Section 14.19.1, “Aggregate Function Descriptions”

MIN()

Section 13.2.9, “2-Digit Years in Dates”
Section 14.19.1, “Aggregate Function Descriptions”
Section 10.3.13, “Descending Indexes”
Section 10.2.1.17, “GROUP BY Optimization”
Section 10.3.1, “How MySQL Uses Indexes”
Section B.3.7, “Known Issues in MySQL”
Section 25.5.23, “ndb_restore — Restore an NDB Cluster Backup”
Section 13.1.1, “Numeric Data Type Syntax”
Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
Section B.3.4.3, “Problems with NULL Values”
Section 10.9.2, “Switchable Optimizations”
Section 13.5, “The JSON Data Type”
Section 1.2.2, “The Main Features of MySQL”
Section 27.5.3, “Updatable and Insertable Views”
Section 10.3.10, “Use of Index Extensions”
Section 10.2.1.1, “WHERE Clause Optimization”
Section 10.2.1.21, “Window Function Optimization”

MINUTE()

Section 14.7, “Date and Time Functions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

MOD()

Section 14.6.1, “Arithmetic Operators”
Section 5.3.4.5, “Date Calculations”
Section 14.6.2, “Mathematical Functions”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 26.6.3, “Partitioning Limitations Relating to Functions”
Section 7.1.11, “Server SQL Modes”

MONTH()

Section 14.7, “Date and Time Functions”
Section 5.3.4.5, “Date Calculations”
Section 26.6.3, “Partitioning Limitations Relating to Functions”
Section 26.2, “Partitioning Types”

MONTHNAME()

Section 14.7, “Date and Time Functions”
Section 12.16, “MySQL Server Locale Support”
Section 7.1.8, “Server System Variables”

MultiLineString()

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

MultiPoint()

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

MultiPolygon()

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

my_open()

Section 7.1.10, “Server Status Variables”

mysql_firewall_flush_status()

Section 8.4.7.4, “MySQL Enterprise Firewall Reference”

mysql_query_attribute_string()

Section 7.5.4, “Query Attribute Components”
Section 11.6, “Query Attributes”

N

NAME_CONST()

Section 14.23, “Miscellaneous Functions”
Section 27.7, “Stored Program Binary Logging”

normalize_statement()

Section 8.4.7.4, “MySQL Enterprise Firewall Reference”

NOW()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 15.1.20.6, “CHECK Constraints”
Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 15.1.20.8, “CREATE TABLE and Generated Columns”
Section 14.7, “Date and Time Functions”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 13.2.6, “Fractional Seconds in Time Values”
Section A.1, “MySQL 8.4 FAQ: General”
Section 7.1.15, “MySQL Server Time Zone Support”
Section 19.5.1.14, “Replication and System Functions”
Section 19.5.1.33, “Replication and Time Zones”
Section 7.1.7, “Server Command Options”
Section 7.1.8, “Server System Variables”
Section 30.4.3.21, “The metrics View”
Section 30.4.4.25, “The statement_performance_analyzer() Procedure”
Section 13.2.4, “The YEAR Type”

NTH_VALUE()

Section 14.20.1, “Window Function Descriptions”
Section 14.20.3, “Window Function Frame Specification”

NTILE()

Section 14.20.1, “Window Function Descriptions”

NULLIF

Section 15.5.1, “PREPARE Statement”

NULLIF()

Section 14.5, “Flow Control Functions”

O

OCT()

Section 14.8, “String Functions and Operators”

OCTET_LENGTH()

Section 14.8, “String Functions and Operators”

ORD()

Section 14.8, “String Functions and Operators”

P

PERCENT_RANK()

Section 14.20.1, “Window Function Descriptions”

PERIOD_ADD()

Section 14.7, “Date and Time Functions”
Section 1.7.1, “MySQL Extensions to Standard SQL”

PERIOD_DIFF()

Section 14.7, “Date and Time Functions”
Section 1.7.1, “MySQL Extensions to Standard SQL”

PI()

Section 11.2.5, “Function Name Parsing and Resolution”
Section 14.6.2, “Mathematical Functions”

Point()

Section 14.16.5, “MySQL-Specific Functions That Create Geometry Values”
Section 13.4.3, “Supported Spatial Data Formats”

Polygon()

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

POSITION()

Section 14.8, “String Functions and Operators”

POW()

Section 10.2.1.20, “Function Call Optimization”
Section 26.2.4, “HASH Partitioning”
Section 14.6.2, “Mathematical Functions”

POWER()

Section 26.2.4.1, “LINEAR HASH Partitioning”
Section 14.6.2, “Mathematical Functions”

PS_CURRENT_THREAD_ID()

Section 14.21, “Performance Schema Functions”
Section 30.4.5.15, “The ps_thread_id() Function”

PS_THREAD_ID()

Section 14.21, “Performance Schema Functions”
Section 30.4.5.15, “The ps_thread_id() Function”

Q

QUARTER()

Section 14.7, “Date and Time Functions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

QUOTE()

Section 14.8, “String Functions and Operators”
Section 11.1.1, “String Literals”

R

RADIANS()

Section 14.6.2, “Mathematical Functions”

RAND()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 10.2.1.20, “Function Call Optimization”
Section 14.6.2, “Mathematical Functions”
Section 8.5.2.4, “MySQL Enterprise Data Masking and De-Identification Component Function Descriptions”
Section 19.5.1.14, “Replication and System Functions”
Section 7.1.8, “Server System Variables”
Section 10.9.2, “Switchable Optimizations”

RANDOM_BYTES()

Section 14.13, “Encryption and Compression Functions”

RANK()

Section 14.20.1, “Window Function Descriptions”

read_firewall_group_allowlist()

Section 8.4.7.4, “MySQL Enterprise Firewall Reference”

read_firewall_groups()

Section 8.4.7.4, “MySQL Enterprise Firewall Reference”

read_firewall_users()

Section 8.4.7.4, “MySQL Enterprise Firewall Reference”

read_firewall_whitelist()

Section 8.4.7.4, “MySQL Enterprise Firewall Reference”

REGEXP_INSTR()

Section 14.8.2, “Regular Expressions”

REGEXP_LIKE()

Section 5.3.4.7, “Pattern Matching”
Section 14.8.2, “Regular Expressions”
Section 7.1.8, “Server System Variables”

REGEXP_REPLACE()

Section 14.8.2, “Regular Expressions”

REGEXP_SUBSTR()

Section 14.8.2, “Regular Expressions”

RELEASE_ALL_LOCKS()

Section 14.14, “Locking Functions”

RELEASE_LOCK()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 15.2.3, “DO Statement”
Section 10.11.1, “Internal Locking Methods”
Section 15.3.6, “LOCK TABLES and UNLOCK TABLES Statements”
Section 14.14, “Locking Functions”
Section 19.5.1.14, “Replication and System Functions”

REPEAT()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

REPLACE()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

REVERSE()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

RIGHT()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

ROLES_GRAPHML()

Section 14.15, “Information Functions”
Section 8.2.2, “Privileges Provided by MySQL”

ROUND()

Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”
Section 14.6.2, “Mathematical Functions”
Section 14.24, “Precision Math”
Section 14.24.5, “Precision Math Examples”
Section 14.24.4, “Rounding Behavior”

ROW_COUNT()

Section 15.2.1, “CALL Statement”
Section 15.2.2, “DELETE Statement”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 14.15, “Information Functions”
Section 15.2.7, “INSERT Statement”
Section 7.4.4.3, “Mixed Binary Logging Format”
Section 19.5.1.14, “Replication and System Functions”
Section 7.1.10, “Server Status Variables”
Section 15.6.7.7, “The MySQL Diagnostics Area”

ROW_NUMBER()

Section 14.20.2, “Window Function Concepts and Syntax”
Section 14.20.1, “Window Function Descriptions”

RPAD()

Section 14.12, “Bit Functions and Operators”
Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

RTRIM()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

S

SCHEMA()

Section 14.15, “Information Functions”

SEC_TO_TIME()

Section 14.7, “Date and Time Functions”

SECOND()

Section 14.7, “Date and Time Functions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

service_get_read_locks()

Section 7.6.9.1.2, “The Locking Service Function Interface”

service_get_write_locks()

Section 7.6.9.1.2, “The Locking Service Function Interface”

service_release_locks()

Section 7.6.9.1.2, “The Locking Service Function Interface”

SESSION_USER()

Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 14.15, “Information Functions”
Section 12.2.2, “UTF-8 for Metadata”

set_firewall_group_mode()

Section 8.4.7.4, “MySQL Enterprise Firewall Reference”

set_firewall_mode()

Section 8.4.7.4, “MySQL Enterprise Firewall Reference”

setrlimit()

Section 7.1.8, “Server System Variables”

SHA()

Section 14.13, “Encryption and Compression Functions”

SHA1()

Section 14.13, “Encryption and Compression Functions”

SHA2()

Section 14.13, “Encryption and Compression Functions”
Section 8.1.1, “Security Guidelines”

SIGN()

Section 14.6.2, “Mathematical Functions”

SIN()

Section 14.6.2, “Mathematical Functions”

SLEEP()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 10.14.3, “General Thread States”
Section 14.23, “Miscellaneous Functions”
Section 29.12.16.3, “The tp_thread_group_stats Table”

SOUNDEX()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

SOURCE_POS_WAIT()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 7.4.4.5.1, “Behaviors When Binary Log Transaction Compression is Enabled”
Section 19.2.2.1, “Commands for Operations on a Single Channel”
Section 19.2.2.2, “Compatibility with Previous Replication Statements”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section A.14, “MySQL 8.4 FAQ: Replication”
Section 14.18.4, “Position-Based Synchronization Functions”
Section 19.1.3.6, “Replication From a Source Without GTIDs to a Replica With GTIDs”

SPACE()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

SQRT()

Section 14.6.2, “Mathematical Functions”

ST_Area()

Section 14.16.7, “Geometry Property Functions”
Section 14.16.7.4, “Polygon and MultiPolygon Property Functions”

ST_AsBinary()

Section 13.4.8, “Fetching Spatial Data”
Section 14.16.6, “Geometry Format Conversion Functions”

ST_AsGeoJSON()

Section 14.16.11, “Spatial GeoJSON Functions”
Section 13.5, “The JSON Data Type”

ST_AsText()

Section 13.4.8, “Fetching Spatial Data”
Section 14.16.6, “Geometry Format Conversion Functions”

ST_AsWKB()

Section 14.16.6, “Geometry Format Conversion Functions”

ST_AsWKT()

Section 14.16.3, “Functions That Create Geometry Values from WKT Values”
Section 14.16.6, “Geometry Format Conversion Functions”

ST_Buffer()

Section 14.16.8, “Spatial Operator Functions”

ST_Buffer_Strategy()

Section 7.1.8, “Server System Variables”
Section 14.16.8, “Spatial Operator Functions”

ST_Centroid()

Section 14.16.7.4, “Polygon and MultiPolygon Property Functions”

ST_Collect(

Section 14.16.12, “Spatial Aggregate Functions”

ST_Collect()

Section 14.16.12, “Spatial Aggregate Functions”

ST_Contains()

Section 14.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”
Section 14.16.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_ConvexHull()

Section 14.16.8, “Spatial Operator Functions”

ST_Crosses()

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

ST_Difference()

Section 14.16.8, “Spatial Operator Functions”

ST_Dimension()

Section 14.16.7.1, “General Geometry Property Functions”

ST_Disjoint()

Section 14.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”
Section 14.16.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_Distance()

Section 14.16.13, “Spatial Convenience Functions”
Section 14.16.9.1, “Spatial Relation Functions That Use Object Shapes”
Section 28.3.37, “The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table”

ST_Distance_Sphere()

Section 14.16.13, “Spatial Convenience Functions”
Section 14.16.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_EndPoint()

Section 14.16.7.3, “LineString and MultiLineString Property Functions”
Section 14.16.8, “Spatial Operator Functions”

ST_Envelope()

Section 14.16.7.1, “General Geometry Property Functions”
Section 14.16.8, “Spatial Operator Functions”

ST_Equals()

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

ST_ExteriorRing()

Section 14.16.7.4, “Polygon and MultiPolygon Property Functions”
Section 14.16.8, “Spatial Operator Functions”

ST_FrechetDistance()

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

ST_GeoHash()

Section 14.16.10, “Spatial Geohash Functions”

ST_GeomCollFromText()

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

ST_GeomCollFromTxt()

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

ST_GeomCollFromWKB()

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

ST_GeometryCollectionFromText()

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

ST_GeometryCollectionFromWKB()

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

ST_GeometryFromText()

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

ST_GeometryFromWKB()

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

ST_GeometryN()

Section 14.16.7.5, “GeometryCollection Property Functions”
Section 14.16.8, “Spatial Operator Functions”

ST_GeometryType()

Section 14.16.7.1, “General Geometry Property Functions”

ST_GeomFromGeoJSON()

Section 14.16.11, “Spatial GeoJSON Functions”
Section 13.5, “The JSON Data Type”

ST_GeomFromText()

Section 14.16.3, “Functions That Create Geometry Values from WKT Values”
Section 14.16.6, “Geometry Format Conversion Functions”
Section 14.16.5, “MySQL-Specific Functions That Create Geometry Values”
Section 13.4.7, “Populating Spatial Columns”
Section 13.4.3, “Supported Spatial Data Formats”

ST_GeomFromWKB()

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

ST_HausdorffDistance()

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

ST_InteriorRingN()

Section 14.16.7.4, “Polygon and MultiPolygon Property Functions”
Section 14.16.8, “Spatial Operator Functions”

ST_Intersection()

Section 14.16.8, “Spatial Operator Functions”

ST_Intersects()

Section 14.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”
Section 14.16.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_IsClosed()

Section 14.16.7.3, “LineString and MultiLineString Property Functions”

ST_IsEmpty()

Section 14.16.7.1, “General Geometry Property Functions”

ST_IsSimple()

Section 14.16.7.1, “General Geometry Property Functions”

ST_IsValid()

Section 13.4.4, “Geometry Well-Formedness and Validity”
Section 14.16.13, “Spatial Convenience Functions”

ST_LatFromGeoHash()

Section 14.16.10, “Spatial Geohash Functions”

ST_Latitude()

Section 14.16.7.2, “Point Property Functions”

ST_Length()

Section 14.16.7.3, “LineString and MultiLineString Property Functions”
Section 14.16.8, “Spatial Operator Functions”
Section 14.8, “String Functions and Operators”

ST_LineFromText()

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

ST_LineFromWKB()

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

ST_LineInterpolatePoint()

Section 14.16.8, “Spatial Operator Functions”

ST_LineInterpolatePoints()

Section 14.16.8, “Spatial Operator Functions”

ST_LineStringFromText()

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

ST_LineStringFromWKB()

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

ST_LongFromGeoHash()

Section 14.16.10, “Spatial Geohash Functions”

ST_Longitude()

Section 14.16.7.2, “Point Property Functions”

ST_MakeEnvelope()

Section 14.16.13, “Spatial Convenience Functions”

ST_MLineFromText()

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

ST_MLineFromWKB()

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

ST_MPointFromText()

Section 14.16.3, “Functions That Create Geometry Values from WKT Values”
Section 13.4.3, “Supported Spatial Data Formats”

ST_MPointFromWKB()

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

ST_MPolyFromText()

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

ST_MPolyFromWKB()

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

ST_MultiLineStringFromText()

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

ST_MultiLineStringFromWKB()

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

ST_MultiPointFromText()

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

ST_MultiPointFromWKB()

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

ST_MultiPolygonFromText()

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

ST_MultiPolygonFromWKB()

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

ST_NumGeometries()

Section 14.16.7.5, “GeometryCollection Property Functions”

ST_NumInteriorRing()

Section 14.16.7.4, “Polygon and MultiPolygon Property Functions”

ST_NumInteriorRings()

Section 14.16.7.4, “Polygon and MultiPolygon Property Functions”

ST_NuminteriorRings()

Section 14.16.7.4, “Polygon and MultiPolygon Property Functions”

ST_NumPoints()

Section 14.16.7.3, “LineString and MultiLineString Property Functions”

ST_Overlaps()

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

ST_PointAtDistance()

Section 14.16.8, “Spatial Operator Functions”

ST_PointFromGeoHash()

Section 14.16.10, “Spatial Geohash Functions”

ST_PointFromText()

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

ST_PointFromWKB()

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

ST_PointN()

Section 14.16.7.3, “LineString and MultiLineString Property Functions”
Section 14.16.8, “Spatial Operator Functions”

ST_PolyFromText()

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

ST_PolyFromWKB()

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

ST_PolygonFromText()

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

ST_PolygonFromWKB()

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

ST_Simplify()

Section 14.16.13, “Spatial Convenience Functions”

ST_SRID()

Section 14.16.7.1, “General Geometry Property Functions”
Section 14.16.8, “Spatial Operator Functions”

ST_StartPoint()

Section 14.16.7.3, “LineString and MultiLineString Property Functions”
Section 14.16.8, “Spatial Operator Functions”

ST_SwapXY()

Section 14.16.6, “Geometry Format Conversion Functions”

ST_SymDifference()

Section 14.16.8, “Spatial Operator Functions”

ST_Touches()

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

ST_Transform()

Section 14.16.7.1, “General Geometry Property Functions”
Section 14.16.8, “Spatial Operator Functions”

ST_Union()

Section 14.16.8, “Spatial Operator Functions”

ST_Validate()

Section 14.16.13, “Spatial Convenience Functions”

ST_Within()

Section 14.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”
Section 14.16.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_X()

Section 14.16.7.2, “Point Property Functions”
Section 13.4.3, “Supported Spatial Data Formats”

ST_Y()

Section 14.16.7.2, “Point Property Functions”

STATEMENT_DIGEST()

Section 14.13, “Encryption and Compression Functions”
Section 29.10, “Performance Schema Statement Digests and Sampling”

STATEMENT_DIGEST_TEXT()

Section 14.13, “Encryption and Compression Functions”
Section 8.4.7.4, “MySQL Enterprise Firewall Reference”
Section 29.10, “Performance Schema Statement Digests and Sampling”
Section 7.1.8, “Server System Variables”

STD()

Section 14.19.1, “Aggregate Function Descriptions”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 1.2.2, “The Main Features of MySQL”

STDDEV()

Section 14.19.1, “Aggregate Function Descriptions”

STDDEV_POP()

Section 14.19.1, “Aggregate Function Descriptions”
Section 10.2.1.21, “Window Function Optimization”

STDDEV_SAMP()

Section 14.19.1, “Aggregate Function Descriptions”
Section 10.2.1.21, “Window Function Optimization”

STR_TO_DATE()

Section 13.2, “Date and Time Data Types”
Section 14.7, “Date and Time Functions”
Section 12.16, “MySQL Server Locale Support”

STRCMP()

Section B.3.4.2, “Problems Using DATE Columns”
Section 14.8.1, “String Comparison Functions and Operators”

SUBDATE()

Section 14.7, “Date and Time Functions”

SUBSTR()

Section 14.12, “Bit Functions and Operators”
Section 14.8, “String Functions and Operators”

SUBSTRING()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 15.1.15, “CREATE INDEX Statement”
Section 14.8, “String Functions and Operators”

SUBSTRING_INDEX()

Section 8.2.23, “SQL-Based Account Activity Auditing”
Section 14.8, “String Functions and Operators”

SUBTIME()

Section 14.7, “Date and Time Functions”

SUM(

Section 14.19.1, “Aggregate Function Descriptions”

SUM()

Section 14.19.1, “Aggregate Function Descriptions”
Section 15.7.4.1, “CREATE FUNCTION Statement for Loadable Functions”
Section 13.2.1, “Date and Time Data Type Syntax”
Section 10.2.1.17, “GROUP BY Optimization”
Section 14.23, “Miscellaneous Functions”
Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”
Section B.3.4.3, “Problems with NULL Values”
Section 13.3.5, “The ENUM Type”
Section 1.2.2, “The Main Features of MySQL”
Section 13.3.6, “The SET Type”
Section 27.5.3, “Updatable and Insertable Views”
Section 14.20.2, “Window Function Concepts and Syntax”
Section 14.20.3, “Window Function Frame Specification”

SYSDATE()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 14.7, “Date and Time Functions”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 19.5.1.14, “Replication and System Functions”
Section 7.1.7, “Server Command Options”
Section 7.1.8, “Server System Variables”

SYSTEM_USER()

Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 14.15, “Information Functions”
Section 12.2.2, “UTF-8 for Metadata”

T

TAN()

Section 14.6.2, “Mathematical Functions”

TIME()

Section 14.7, “Date and Time Functions”

TIME_FORMAT()

Section 14.10, “Cast Functions and Operators”
Section 14.7, “Date and Time Functions”

TIME_TO_SEC()

Section 14.7, “Date and Time Functions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

TIMEDIFF()

Section 14.7, “Date and Time Functions”

TIMESTAMP()

Section 14.7, “Date and Time Functions”

TIMESTAMPADD()

Section 14.7, “Date and Time Functions”

TIMESTAMPDIFF()

Section 14.7, “Date and Time Functions”
Section 5.3.4.5, “Date Calculations”

TO_BASE64()

Section 14.8, “String Functions and Operators”

TO_DAYS()

Section 14.7, “Date and Time Functions”
Section 26.2.4, “HASH Partitioning”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 26.4, “Partition Pruning”
Section 26.6.3, “Partitioning Limitations Relating to Functions”
Section 26.2, “Partitioning Types”

TO_SECONDS()

Section 14.7, “Date and Time Functions”
Section 26.4, “Partition Pruning”
Section 26.6.3, “Partitioning Limitations Relating to Functions”
Section 26.2, “Partitioning Types”

TRIM()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 12.7, “Column Character Set Conversion”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.8, “String Functions and Operators”

TRUNCATE()

Section 14.6.2, “Mathematical Functions”

U

UCASE()

Section 14.8.3, “Character Set and Collation of Function Results”
Section 14.8, “String Functions and Operators”

UNCOMPRESS()

Section 14.13, “Encryption and Compression Functions”
Section 2.8.7, “MySQL Source-Configuration Options”
Section 7.1.8, “Server System Variables”

UNCOMPRESSED_LENGTH()

Section 14.13, “Encryption and Compression Functions”

UNHEX()

Section 14.13, “Encryption and Compression Functions”
Section 6.5.1.1, “mysql Client Options”
Section 14.8, “String Functions and Operators”

UNIX_TIMESTAMP()

Section 14.7, “Date and Time Functions”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 10.3.14, “Indexed Lookups from TIMESTAMP Columns”
Section 26.6.3, “Partitioning Limitations Relating to Functions”
Section 26.2.1, “RANGE Partitioning”
Section 7.1.8, “Server System Variables”
Section 30.4.3.21, “The metrics View”
Section B.3.3.7, “Time Zone Problems”

UpdateXML()

Section 14.11, “XML Functions”

UPPER()

Section 14.10, “Cast Functions and Operators”
Section 14.8.3, “Character Set and Collation of Function Results”
Section 12.2.1, “Character Set Repertoire”
Section 14.8, “String Functions and Operators”
Section 12.10.1, “Unicode Character Sets”
Section 12.8.7, “Using Collation in INFORMATION_SCHEMA Searches”

USER()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 15.7.1.1, “ALTER USER Statement”
Section 12.8.4, “Collation Coercibility in Expressions”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 14.15, “Information Functions”
Section 8.4.1.7, “LDAP Pluggable Authentication”
Section 7.4.4.3, “Mixed Binary Logging Format”
Section 7.1.14, “Network Namespace Support”
Section 8.2.15, “Password Management”
Section 8.4.3.2, “Password Validation Options and Variables”
Section 8.2.19, “Proxy Users”
Section 19.5.1.14, “Replication and System Functions”
Section 8.2.23, “SQL-Based Account Activity Auditing”
Section 12.2.2, “UTF-8 for Metadata”

UTC_DATE

Section 14.7, “Date and Time Functions”

UTC_DATE()

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

UTC_TIME

Section 14.7, “Date and Time Functions”

UTC_TIME()

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

UTC_TIMESTAMP

Section 14.7, “Date and Time Functions”

UTC_TIMESTAMP()

Section 14.7, “Date and Time Functions”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 7.1.15, “MySQL Server Time Zone Support”

UUID()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 19.1.6.4, “Binary Logging Options and Variables”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 10.2.1.20, “Function Call Optimization”
Section 14.23, “Miscellaneous Functions”
Section 7.4.4.3, “Mixed Binary Logging Format”
Section 19.5.1.14, “Replication and System Functions”
Section 27.7, “Stored Program Binary Logging”

UUID_SHORT()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 14.23, “Miscellaneous Functions”

UUID_TO_BIN()

Section 14.12, “Bit Functions and Operators”
Section 14.23, “Miscellaneous Functions”

V

VALIDATE_PASSWORD_STRENGTH()

Section 14.13, “Encryption and Compression Functions”
Section 8.4.3.2, “Password Validation Options and Variables”
Section 8.4.3, “The Password Validation Component”

VALUES()

Section 15.2.7.2, “INSERT ... ON DUPLICATE KEY UPDATE Statement”
Section 14.23, “Miscellaneous Functions”
Section 15.2.19, “VALUES Statement”

VAR_POP()

Section 14.19.1, “Aggregate Function Descriptions”
Section 10.2.1.21, “Window Function Optimization”

VAR_SAMP()

Section 14.19.1, “Aggregate Function Descriptions”
Section 10.2.1.21, “Window Function Optimization”

VARIANCE()

Section 14.19.1, “Aggregate Function Descriptions”

VERSION()

Section 19.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 8.4.5.4, “Audit Log File Formats”
Section B.3.4.1, “Case Sensitivity in String Searches”
Section 12.8.4, “Collation Coercibility in Expressions”
Section 14.15, “Information Functions”
Section 19.5.1.14, “Replication and System Functions”
Section 30.4.3.47, “The version View”
Section 12.2.2, “UTF-8 for Metadata”

version_tokens_delete()

Section 7.6.6.3, “Using Version Tokens”
Section 7.6.6.4, “Version Tokens Reference”

version_tokens_edit()

Section 7.6.6.3, “Using Version Tokens”
Section 7.6.6.4, “Version Tokens Reference”

version_tokens_lock_exclusive()

Section 7.6.6.3, “Using Version Tokens”
Section 7.6.6.4, “Version Tokens Reference”

version_tokens_lock_shared()

Section 7.6.6.3, “Using Version Tokens”
Section 7.6.6.4, “Version Tokens Reference”

version_tokens_set()

Section 7.6.6.3, “Using Version Tokens”
Section 7.6.6.4, “Version Tokens Reference”

version_tokens_show()

Section 7.6.6.3, “Using Version Tokens”
Section 7.6.6.4, “Version Tokens Reference”

version_tokens_unlock()

Section 7.6.6.3, “Using Version Tokens”
Section 7.6.6.4, “Version Tokens Reference”

W

WAIT_FOR_EXECUTED_GTID_SET()

Section 14.18.2, “Functions Used with Global Transaction Identifiers (GTIDs)”
Section 19.1.3.6, “Replication From a Source Without GTIDs to a Replica With GTIDs”
Section 19.1.4.1, “Replication Mode Concepts”
Section 1.4, “What Is New in MySQL 8.4 since MySQL 8.0”

WEEK()

Section 14.7, “Date and Time Functions”
Section 7.1.8, “Server System Variables”

WEEKDAY()

Section 14.7, “Date and Time Functions”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 26.6.3, “Partitioning Limitations Relating to Functions”
Section 26.2, “Partitioning Types”

WEEKOFYEAR()

Section 14.7, “Date and Time Functions”

WEIGHT_STRING()

Section 12.14, “Adding a Collation to a Character Set”
Section B.3.4.1, “Case Sensitivity in String Searches”
Section 14.8, “String Functions and Operators”
Section 12.10.1, “Unicode Character Sets”

Y

YEAR()

Section 14.7, “Date and Time Functions”
Section 5.3.4.5, “Date Calculations”
Section 26.2.4, “HASH Partitioning”
Section 26.2.7, “How MySQL Partitioning Handles NULL”
Section 26.3.1, “Management of RANGE and LIST Partitions”
Section 26.4, “Partition Pruning”
Section 26.6.3, “Partitioning Limitations Relating to Functions”
Section 26.2, “Partitioning Types”
Section 26.2.1, “RANGE Partitioning”

YEARWEEK()

Section 14.7, “Date and Time Functions”
Section 26.6.3, “Partitioning Limitations Relating to Functions”

PREV HOME UP NEXT

PDF (US Ltr) - 40.1Mb
PDF (A4) - 40.2Mb
Man Pages (TGZ) - 259.3Kb
Man Pages (Zip) - 366.5Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb