MySQL :: MySQL 5.7 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 5.7

9.1
9.0
8.4 current
8.0

MySQL 5.7 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 | X | Y

Symbols

%

Section 1.6.1, “MySQL Extensions to Standard SQL”

A

ABS()

Section 13.7.3.1, “CREATE FUNCTION Statement for Loadable Functions”
Section 12.6.2, “Mathematical Functions”
Section 22.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 8.10.3.1, “How the Query Cache Operates”
Section 6.6.4, “MySQL Enterprise Encryption Function Descriptions”
Section 5.1.7, “Server System Variables”
Section 6.3.4, “SSL Library-Dependent Capabilities”
Section 1.3, “What Is New in MySQL 5.7”

AES_ENCRYPT()

Section 12.13, “Encryption and Compression Functions”
Section 8.10.3.1, “How the Query Cache Operates”
Section 6.6.4, “MySQL Enterprise Encryption Function Descriptions”
Section 5.1.7, “Server System Variables”
Section 6.3.4, “SSL Library-Dependent Capabilities”
Section 1.3, “What Is New in MySQL 5.7”

ANY_VALUE()

Section 2.10.3, “Changes in MySQL 5.7”
Section 12.19.2, “GROUP BY Modifiers”
Section 12.20, “Miscellaneous Functions”
Section 12.19.3, “MySQL Handling of GROUP BY”
Section 5.1.10, “Server SQL Modes”

Area()

Section 12.16.7.4, “Polygon and MultiPolygon Property Functions”

AsBinary()

Section 12.16.6, “Geometry Format Conversion Functions”

ASCII()

Section 13.8.3, “HELP Statement”
Section 12.8, “String Functions and Operators”

ASIN()

Section 12.6.2, “Mathematical Functions”

AsText()

Section 12.16.6, “Geometry Format Conversion Functions”

AsWKB()

Section 12.16.6, “Geometry Format Conversion Functions”

AsWKT()

Section 12.16.6, “Geometry Format Conversion Functions”

asymmetric_decrypt()

Section 6.6.4, “MySQL Enterprise Encryption Function Descriptions”

asymmetric_derive()

Section 6.6.4, “MySQL Enterprise Encryption Function Descriptions”

asymmetric_encrypt()

Section 6.6.4, “MySQL Enterprise Encryption Function Descriptions”

asymmetric_sign()

Section 6.6.4, “MySQL Enterprise Encryption Function Descriptions”

asymmetric_verify()

Section 6.6.4, “MySQL Enterprise Encryption Function Descriptions”

ATAN()

Section 12.6.2, “Mathematical Functions”

ATAN2()

Section 12.6.2, “Mathematical Functions”

audit_log_encryption_password_get()

Section 6.4.5.11, “Audit Log Reference”
Section 6.4.5.5, “Configuring Audit Logging Characteristics”

audit_log_encryption_password_set()

Section 6.4.5.11, “Audit Log Reference”
Section 6.4.5.5, “Configuring Audit Logging Characteristics”

audit_log_filter_flush()

Section 6.4.5.7, “Audit Log Filtering”
Section 6.4.5.11, “Audit Log Reference”

audit_log_filter_remove_filter()

Section 6.4.5.7, “Audit Log Filtering”
Section 6.4.5.11, “Audit Log Reference”

audit_log_filter_remove_user()

Section 6.4.5.7, “Audit Log Filtering”
Section 6.4.5.11, “Audit Log Reference”

audit_log_filter_set_filter()

Section 6.4.5.7, “Audit Log Filtering”
Section 6.4.5.11, “Audit Log Reference”

audit_log_filter_set_user()

Section 6.4.5.7, “Audit Log Filtering”
Section 6.4.5.11, “Audit Log Reference”

audit_log_read()

Section 6.4.5.11, “Audit Log Reference”
Section 6.4.5.6, “Reading Audit Log Files”

audit_log_read_bookmark()

Section 6.4.5.11, “Audit Log Reference”
Section 6.4.5.6, “Reading Audit Log Files”

AVG()

Section 12.19.1, “Aggregate Function Descriptions”
Section 11.2.1, “Date and Time Data Type Syntax”
Section 8.2.1.15, “GROUP BY Optimization”
Section 11.3.5, “The ENUM Type”
Section 1.2.2, “The Main Features of MySQL”
Section 11.3.6, “The SET Type”

B

BENCHMARK()

Section 8.10.3.1, “How the Query Cache Operates”
Section 12.15, “Information Functions”
Section 8.13.1, “Measuring the Speed of Expressions and Functions”
Section 13.2.10.10, “Optimizing Subqueries”

BIN()

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

BIT_AND()

Section 12.19.1, “Aggregate Function Descriptions”
Section 12.12, “Bit Functions and Operators”
Section 1.6.1, “MySQL Extensions to Standard SQL”

BIT_COUNT()

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

BIT_LENGTH()

Section 12.8, “String Functions and Operators”

BIT_OR()

Section 12.19.1, “Aggregate Function Descriptions”
Section 12.12, “Bit Functions and Operators”
Section 1.6.1, “MySQL Extensions to Standard SQL”

BIT_XOR()

Section 12.19.1, “Aggregate Function Descriptions”
Section 12.12, “Bit Functions and Operators”
Section 1.6.1, “MySQL Extensions to Standard SQL”

Buffer()

Section 12.16.8, “Spatial Operator Functions”

C

CAST()

Section 12.12, “Bit Functions and Operators”
Section 9.1.5, “Bit-Value Literals”
Section 12.10, “Cast Functions and Operators”
Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.4.2, “Comparison Functions and Operators”
Section 11.2.9, “Conversion Between Date and Time Types”
Section 12.7, “Date and Time Functions”
Section 9.5, “Expressions”
Section 12.17.2, “Functions That Create JSON Values”
Section 9.1.4, “Hexadecimal Literals”
Section 1.6.2, “MySQL Differences from Standard SQL”
Section 11.5, “The JSON Data Type”
Section 12.3, “Type Conversion in Expression Evaluation”
Section 9.4, “User-Defined Variables”

CAST(expr AS type

Section 12.10, “Cast Functions and Operators”

CEIL()

Section 12.6.2, “Mathematical Functions”

CEILING()

Section 22.2.4.1, “LINEAR HASH Partitioning”
Section 12.6.2, “Mathematical Functions”
Section 22.6.3, “Partitioning Limitations Relating to Functions”

Centroid()

Section 12.16.7.4, “Polygon and MultiPolygon Property Functions”

CHAR()

Section 12.13, “Encryption and Compression Functions”
Section 4.5.1.1, “mysql Client Options”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 12.8, “String Functions and Operators”

CHAR_LENGTH()

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

CHARACTER_LENGTH()

Section 12.8, “String Functions and Operators”

CHARSET()

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

COALESCE()

Section 12.4.2, “Comparison Functions and Operators”
Section 13.2.9.2, “JOIN Clause”

COERCIBILITY()

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

COLLATION()

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

COMPRESS()

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

CONCAT()

Section 12.19.1, “Aggregate Function Descriptions”
Section 12.10, “Cast Functions and Operators”
Section 12.8.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.3.1, “CREATE FUNCTION Statement for Loadable Functions”
Section 12.4.3, “Logical Operators”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 5.1.10, “Server SQL Modes”
Section 13.7.5.13, “SHOW CREATE VIEW Statement”
Section 12.8, “String Functions and Operators”
Section 24.3.31, “The INFORMATION_SCHEMA VIEWS Table”
Section 12.3, “Type Conversion in Expression Evaluation”
Section 12.11, “XML Functions”

CONCAT_WS()

Section 12.19.1, “Aggregate Function Descriptions”
Section 12.8, “String Functions and Operators”

CONNECTION_ID()

Section 6.4.5.4, “Audit Log File Formats”
Section 13.1.18.7, “CREATE TABLE and Generated Columns”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.15, “Information Functions”
Section 13.7.6.4, “KILL Statement”
Section 4.5.1.3, “mysql Client Logging”
Section 5.1.7, “Server System Variables”
Section 13.7.5.29, “SHOW PROCESSLIST Statement”
Section 24.3.18, “The INFORMATION_SCHEMA PROCESSLIST Table”
Section 25.12.16.3, “The processlist Table”
Section 25.12.16.4, “The threads Table”

Contains()

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

CONV()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.6.2, “Mathematical Functions”
Section 12.8, “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.4.2, “Comparison Functions and Operators”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 4.5.1.1, “mysql Client Options”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

CONVERT_TZ()

Section 12.7, “Date and Time Functions”
Section 8.10.3.1, “How the Query Cache Operates”
Section 8.3.11, “Indexed Lookups from TIMESTAMP Columns”
Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Statements”
Section 5.1.7, “Server System Variables”
Section 5.4.3, “The General Query Log”
Section 5.4.5, “The Slow Query Log”

ConvexHull()

Section 12.16.8, “Spatial Operator Functions”

COS()

Section 12.6.2, “Mathematical Functions”

COT()

Section 12.6.2, “Mathematical Functions”

COUNT()

Section 12.19.1, “Aggregate Function Descriptions”
Section 3.3.4.8, “Counting Rows”
Section 13.7.3.1, “CREATE FUNCTION Statement for Loadable Functions”
Section 8.2.1.15, “GROUP BY Optimization”
Section 14.24, “InnoDB Restrictions and Limitations”
Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section 21.2.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
Section 12.20, “Miscellaneous Functions”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 21.4.3.9.3, “NDB Cluster Status Variables”
Section 8.2.2.4, “Optimizing Derived Tables and View References with Merging or Materialization”
Section B.3.4.3, “Problems with NULL Values”
Section 5.1.10, “Server SQL Modes”
Section 1.2.2, “The Main Features of MySQL”
Section 23.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 4.9, “Environment Variables”
Section 6.6.4, “MySQL Enterprise Encryption Function Descriptions”
Section 6.6.2, “MySQL Enterprise Encryption Usage and Examples”

create_asymmetric_pub_key()

Section 6.6.4, “MySQL Enterprise Encryption Function Descriptions”

create_dh_parameters()

Section 4.9, “Environment Variables”
Section 6.6.4, “MySQL Enterprise Encryption Function Descriptions”
Section 6.6.2, “MySQL Enterprise Encryption Usage and Examples”

create_digest()

Section 6.6.4, “MySQL Enterprise Encryption Function Descriptions”

Crosses()

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

crypt()

Section 12.13, “Encryption and Compression Functions”
Section 5.1.7, “Server System Variables”

CURDATE()

Section 12.7, “Date and Time Functions”
Section 3.3.4.5, “Date Calculations”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”

CURRENT_DATE

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

CURRENT_DATE()

Section 11.2.9, “Conversion Between Date and Time Types”
Section 12.7, “Date and Time Functions”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”

CURRENT_TIME

Section 12.7, “Date and Time Functions”

CURRENT_TIME()

Section 12.7, “Date and Time Functions”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”

CURRENT_TIMESTAMP

Section 13.1.8, “ALTER TABLE Statement”
Section 11.2.6, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.1.12, “CREATE EVENT Statement”
Section 11.6, “Data Type Default Values”
Section 12.7, “Date and Time Functions”
Section 5.1.7, “Server System Variables”

CURRENT_TIMESTAMP()

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

CURRENT_USER

Section 13.7.1.1, “ALTER USER Statement”
Section 13.1.12, “CREATE EVENT Statement”
Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.20, “CREATE TRIGGER Statement”
Section 13.1.21, “CREATE VIEW Statement”
Section 6.2.3, “Grant Tables”
Section 12.15, “Information Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 16.4.1.15, “Replication and System Functions”
Section 16.4.1.8, “Replication of CURRENT_USER()”
Section 13.7.5.12, “SHOW CREATE USER Statement”
Section 6.2.4, “Specifying Account Names”
Section 23.6, “Stored Object Access Control”

CURRENT_USER()

Section 6.2.5, “Access Control, Stage 1: Connection Verification”
Section 13.7.1.1, “ALTER USER Statement”
Section 6.4.5.4, “Audit Log File Formats”
Section 6.4.2.1, “Connection-Control Plugin Installation”
Section 13.1.12, “CREATE EVENT Statement”
Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.18.7, “CREATE TABLE and Generated Columns”
Section 13.1.20, “CREATE TRIGGER Statement”
Section 13.1.21, “CREATE VIEW Statement”
Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.15, “Information Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 6.4.3.2, “Password Validation Plugin Options and Variables”
Section 6.2.14, “Proxy Users”
Section 16.4.1.15, “Replication and System Functions”
Section 16.4.1.8, “Replication of CURRENT_USER()”
Section 13.7.1.7, “SET PASSWORD Statement”
Section 13.7.5.12, “SHOW CREATE USER Statement”
Section 6.2.4, “Specifying Account Names”
Section 6.2.18, “SQL-Based Account Activity Auditing”
Section 23.6, “Stored Object Access Control”
Section 5.5.6.2, “The Keyring Service”
Section 10.2.2, “UTF-8 for Metadata”

CURTIME()

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

D

DATABASE()

Section 16.1.6.4, “Binary Logging Options and Variables”
Section 3.3.1, “Creating and Selecting a Database”
Section 13.1.22, “DROP DATABASE Statement”
Section 3.4, “Getting Information About Databases and Tables”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.15, “Information Functions”
Section B.3.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 11.2, “Date and Time Data Types”
Section 12.7, “Date and Time Functions”
Section 3.3.4.5, “Date Calculations”
Section 9.5, “Expressions”

DATE_FORMAT()

Section 12.10, “Cast Functions and Operators”
Section 12.7, “Date and Time Functions”
Section 10.16, “MySQL Server Locale Support”
Section 5.1.7, “Server System Variables”

DATE_SUB()

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

DATEDIFF()

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

DAY()

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

DAYNAME()

Section 12.7, “Date and Time Functions”
Section 10.16, “MySQL Server Locale Support”
Section 5.1.7, “Server System Variables”

DAYOFMONTH()

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

DAYOFWEEK()

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

DAYOFYEAR()

Section 12.7, “Date and Time Functions”
Section 22.6.3, “Partitioning Limitations Relating to Functions”
Section 22.2, “Partitioning Types”

DECODE()

Section 12.13, “Encryption and Compression Functions”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 1.3, “What Is New in MySQL 5.7”

DEFAULT()

Section 13.1.8.2, “ALTER TABLE and Generated Columns”
Section 11.6, “Data Type Default Values”
Section 13.2.5, “INSERT Statement”
Section 12.20, “Miscellaneous Functions”
Section 13.2.8, “REPLACE Statement”

DEGREES()

Section 12.6.2, “Mathematical Functions”

DES_DECRYPT()

Section 12.13, “Encryption and Compression Functions”
Section 13.7.6.3, “FLUSH Statement”
Section 5.1.6, “Server Command Options”
Section 1.3, “What Is New in MySQL 5.7”

DES_ENCRYPT()

Section 12.13, “Encryption and Compression Functions”
Section 13.7.6.3, “FLUSH Statement”
Section 6.2.2, “Privileges Provided by MySQL”
Section 5.1.6, “Server Command Options”
Section 1.3, “What Is New in MySQL 5.7”

Dimension()

Section 12.16.7.1, “General Geometry Property Functions”

Disjoint()

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

Distance()

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

E

ELT()

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

ENCODE()

Section 12.13, “Encryption and Compression Functions”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 1.3, “What Is New in MySQL 5.7”

ENCRYPT()

Section 12.13, “Encryption and Compression Functions”
Section 8.10.3.1, “How the Query Cache Operates”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 10.11, “Restrictions on Character Sets”
Section 5.1.7, “Server System Variables”
Section 1.3, “What Is New in MySQL 5.7”

EndPoint()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”

Envelope()

Section 12.16.7.1, “General Geometry Property Functions”

Equals()

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

EXP()

Section 13.1.18, “CREATE TABLE Statement”
Section 12.6.2, “Mathematical Functions”

EXPORT_SET()

Section 12.8, “String Functions and Operators”

ExteriorRing()

Section 12.16.7.4, “Polygon and MultiPolygon Property Functions”

EXTRACT()

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

ExtractValue()

Section 12.11, “XML Functions”

F

FIELD()

Section 12.8, “String Functions and Operators”

FIND_IN_SET()

Section 12.8, “String Functions and Operators”
Section 11.3.6, “The SET Type”

FLOOR()

Section 12.6.2, “Mathematical Functions”
Section 12.19.3, “MySQL Handling of GROUP BY”
Section 22.6.3, “Partitioning Limitations Relating to Functions”
Section 5.1.7, “Server System Variables”

flush_rewrite_rules()

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

FORMAT()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.6.2, “Mathematical Functions”
Section 12.20, “Miscellaneous Functions”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 10.16, “MySQL Server Locale Support”
Section 12.8, “String Functions and Operators”

FOUND_ROWS()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.15, “Information Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 16.4.1.15, “Replication and System Functions”

FROM_BASE64()

Section 12.8, “String Functions and Operators”

FROM_DAYS()

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

FROM_UNIXTIME()

Section 6.4.5.5, “Configuring Audit Logging Characteristics”
Section 12.7, “Date and Time Functions”
Section 8.3.11, “Indexed Lookups from TIMESTAMP Columns”
Section 16.4.1.31, “Replication and Time Zones”

G

gen_blacklist()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

gen_dictionary()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

gen_dictionary_drop()

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

gen_dictionary_load()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

gen_range()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

gen_rnd_email()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

gen_rnd_pan()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

gen_rnd_ssn()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

gen_rnd_us_phone()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

GeomCollFromText()

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

GeomCollFromWKB()

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

GeometryCollection()

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

GeometryCollectionFromText()

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

GeometryCollectionFromWKB()

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

GeometryFromText()

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

GeometryFromWKB()

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

GeometryN()

Section 12.16.7.5, “GeometryCollection Property Functions”

GeometryType()

Section 12.16.7.1, “General Geometry Property Functions”

GeomFromText()

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

GeomFromWKB()

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

GET_FORMAT()

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

GET_LOCK()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 2.10.3, “Changes in MySQL 5.7”
Section 13.1.12, “CREATE EVENT Statement”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 23.4.1, “Event Scheduler Overview”
Section 8.14.3, “General Thread States”
Section 17.3.2, “Group Replication Limitations”
Section 8.10.3.1, “How the Query Cache Operates”
Section 8.11.1, “Internal Locking Methods”
Section 13.7.6.4, “KILL Statement”
Section 21.2.7.10, “Limitations Relating to Multiple NDB Cluster Nodes”
Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Statements”
Section 12.14, “Locking Functions”
Section 8.11.4, “Metadata Locking”
Section 16.4.1.15, “Replication and System Functions”
Section 5.5.6.1, “The Locking Service”
Section 5.5.6.1.2, “The Locking Service Function Interface”
Section 25.12.12.1, “The metadata_locks Table”
Section 26.4.4.14, “The ps_setup_save() Procedure”

getrusage()

Section 21.6.15.43, “The ndbinfo threadstat Table”

gettimeofday()

Section 21.6.15.43, “The ndbinfo threadstat Table”

GLength()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”

GREATEST()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.4.2, “Comparison Functions and Operators”
Section 11.5, “The JSON Data Type”

GROUP_CONCAT()

Section 12.19.1, “Aggregate Function Descriptions”
Section 8.4.4, “Internal Temporary Table Use in MySQL”
Section B.3.7, “Known Issues in MySQL”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 5.1.7, “Server System Variables”
Section 11.5, “The JSON Data Type”
Section 1.2.2, “The Main Features of MySQL”

GROUPING()

Section 12.19.2, “GROUP BY Modifiers”

GTID_SUBSET()

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

GTID_SUBTRACT()

Section 12.18, “Functions Used with Global Transaction Identifiers (GTIDs)”
Section 16.1.6.5, “Global Transaction ID System Variables”
Section 16.1.3.1, “GTID Format and Storage”
Section 16.1.3.7, “Stored Function Examples to Manipulate GTIDs”

H

HEX()

Section 9.1.5, “Bit-Value Literals”
Section 12.8.3, “Character Set and Collation of Function Results”
Section 10.3.6, “Character String Literal Character Set and Collation”
Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”
Section 9.1.4, “Hexadecimal Literals”
Section 12.6.2, “Mathematical Functions”
Section 12.20, “Miscellaneous Functions”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 12.8, “String Functions and Operators”

HOUR()

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

I

IF()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.5, “Flow Control Functions”
Section 13.6.5.2, “IF Statement”
Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section B.3.7, “Known Issues in MySQL”
Section 1.6.1, “MySQL Extensions to Standard SQL”

IFNULL()

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

INET6_ATON()

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

INET6_NTOA()

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

INET_ATON()

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

INET_NTOA()

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

INSERT()

Section 12.8, “String Functions and Operators”

INSTR()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

InteriorRingN()

Section 12.16.7.4, “Polygon and MultiPolygon Property Functions”

Intersects()

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

INTERVAL()

Section 12.4.2, “Comparison Functions and Operators”

IS_FREE_LOCK()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.14, “Locking Functions”
Section 16.4.1.15, “Replication and System Functions”

IS_IPV4()

Section 12.20, “Miscellaneous Functions”

IS_IPV4_COMPAT()

Section 12.20, “Miscellaneous Functions”

IS_IPV4_MAPPED()

Section 12.20, “Miscellaneous Functions”

IS_IPV6()

Section 12.20, “Miscellaneous Functions”

IS_USED_LOCK()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.14, “Locking Functions”
Section 16.4.1.15, “Replication and System Functions”

IsClosed()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”

IsEmpty()

Section 12.16.7.1, “General Geometry Property Functions”

ISNULL()

Section 12.4.2, “Comparison Functions and Operators”

IsSimple()

Section 12.16.7.1, “General Geometry Property Functions”

J

JSON_APPEND()

Section 12.17.4, “Functions That Modify JSON Values”
Section 1.3, “What Is New in MySQL 5.7”

JSON_ARRAY()

Section 12.17.2, “Functions That Create JSON Values”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 5.7”

JSON_ARRAY_APPEND()

Section 12.17.4, “Functions That Modify JSON Values”
Section 1.3, “What Is New in MySQL 5.7”

JSON_ARRAY_INSERT()

Section 12.17.4, “Functions That Modify JSON Values”
Section 1.3, “What Is New in MySQL 5.7”

JSON_ARRAYAGG()

Section 12.19.1, “Aggregate Function Descriptions”
Section 12.17.2, “Functions That Create JSON Values”
Section 12.17.1, “JSON Function Reference”
Section 1.3, “What Is New in MySQL 5.7”

JSON_CONTAINS()

Section 12.17.3, “Functions That Search JSON Values”
Section 1.3, “What Is New in MySQL 5.7”

JSON_CONTAINS_PATH()

Section 12.17.3, “Functions That Search JSON Values”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 5.7”

JSON_DEPTH()

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

JSON_EXTRACT()

Section 12.17.3, “Functions That Search JSON Values”
Section 13.1.18.8, “Secondary Indexes and Generated Columns”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 5.7”

JSON_INSERT()

Section 12.17.4, “Functions That Modify JSON Values”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 5.7”

JSON_KEYS()

Section 12.17.3, “Functions That Search JSON Values”
Section 1.3, “What Is New in MySQL 5.7”

JSON_LENGTH()

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

JSON_MERGE()

Section 12.17.4, “Functions That Modify JSON Values”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 5.7”

JSON_MERGE_PATCH()

Section 12.17.4, “Functions That Modify JSON Values”
Section 1.3, “What Is New in MySQL 5.7”

JSON_MERGE_PRESERVE()

Section 12.17.4, “Functions That Modify JSON Values”
Section 1.3, “What Is New in MySQL 5.7”

JSON_OBJECT()

Section 12.17.2, “Functions That Create JSON Values”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 5.7”

JSON_OBJECTAGG()

Section 12.19.1, “Aggregate Function Descriptions”
Section 12.17.2, “Functions That Create JSON Values”
Section 12.17.1, “JSON Function Reference”
Section 1.3, “What Is New in MySQL 5.7”

JSON_PRETTY()

Section 12.17.1, “JSON Function Reference”
Section 12.17.6, “JSON Utility Functions”
Section 1.3, “What Is New in MySQL 5.7”

JSON_QUOTE()

Section 12.17.2, “Functions That Create JSON Values”
Section 12.17.6, “JSON Utility Functions”
Section 1.3, “What Is New in MySQL 5.7”

JSON_REMOVE()

Section 12.17.4, “Functions That Modify JSON Values”
Section 1.3, “What Is New in MySQL 5.7”

JSON_REPLACE()

Section 12.17.4, “Functions That Modify JSON Values”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 5.7”

JSON_SEARCH()

Section 12.17.3, “Functions That Search JSON Values”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 5.7”

JSON_SET()

Section 12.17.4, “Functions That Modify JSON Values”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 5.7”

JSON_STORAGE_SIZE()

Section 12.17.1, “JSON Function Reference”
Section 12.17.6, “JSON Utility Functions”
Section 1.3, “What Is New in MySQL 5.7”

JSON_TYPE()

Section 12.17.5, “Functions That Return JSON Value Attributes”
Section 12.17.3, “Functions That Search JSON Values”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 5.7”

JSON_UNQUOTE(

Section 12.17.3, “Functions That Search JSON Values”

JSON_UNQUOTE()

Section 12.17.4, “Functions That Modify JSON Values”
Section 8.3.10, “Optimizer Use of Generated Column Indexes”
Section 13.1.18.8, “Secondary Indexes and Generated Columns”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 5.7”

JSON_VALID()

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

K

keyring_aws_rotate_cmk()

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

keyring_aws_rotate_keys()

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

keyring_key_fetch()

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

keyring_key_generate()

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

keyring_key_length_fetch()

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

keyring_key_remove()

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

keyring_key_store()

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

keyring_key_type_fetch()

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

L

LAST_DAY()

Section 12.7, “Date and Time Functions”

LAST_INSERT_ID()

Section 12.4.2, “Comparison Functions and Operators”
Section 13.1.18, “CREATE TABLE Statement”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.15, “Information Functions”
Section 13.2.5.2, “INSERT ... ON DUPLICATE KEY UPDATE Statement”
Section 13.2.5, “INSERT Statement”
Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Statements”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 21.5.24, “ndb_restore — Restore an NDB Cluster Backup”
Section 16.4.1.1, “Replication and AUTO_INCREMENT”
Section 16.4.1.15, “Replication and System Functions”
Section 5.1.7, “Server System Variables”
Section 23.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()”
Section 16.4.4, “Troubleshooting Replication”
Section 23.5.3, “Updatable and Insertable Views”
Section 3.6.9, “Using AUTO_INCREMENT”

LCASE()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

LEAST()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.4.2, “Comparison Functions and Operators”
Section 11.5, “The JSON Data Type”

LEFT()

Section 12.8, “String Functions and Operators”

LENGTH()

Section 11.7, “Data Type Storage Requirements”
Section 12.8, “String Functions and Operators”
Section 11.4.3, “Supported Spatial Data Formats”

Length()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”
Section 11.4, “Spatial Data Types”

LineFromText()

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

LineFromWKB()

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

LineString()

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

LineStringFromText()

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

LineStringFromWKB()

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

LN()

Section 12.6.2, “Mathematical Functions”

LOAD_FILE()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 13.2.7, “LOAD XML Statement”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 6.6.2, “MySQL Enterprise Encryption Usage and Examples”
Section 6.2.2, “Privileges Provided by MySQL”
Section 16.4.1.15, “Replication and System Functions”
Section 5.1.7, “Server System Variables”
Section 12.8, “String Functions and Operators”

load_rewrite_rules()

Section 5.5.4.3.2, “Rewriter Query Rewrite Plugin Procedures and Functions”
Section 5.5.4, “The Rewriter Query Rewrite Plugin”

LOCALTIME

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

LOCALTIME()

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

LOCALTIMESTAMP

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

LOCALTIMESTAMP()

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

LOCATE()

Section 12.8, “String Functions and Operators”

LOG()

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

LPAD()

Section 12.8, “String Functions and Operators”

LTRIM()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

M

MAKE_SET()

Section 12.8, “String Functions and Operators”

MAKEDATE()

Section 12.7, “Date and Time Functions”

MAKETIME()

Section 12.7, “Date and Time Functions”

mask_inner()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

mask_outer()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

mask_pan()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

mask_pan_relaxed()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

mask_ssn()

Section 6.5.5, “MySQL Enterprise Data Masking and De-Identification Function Descriptions”
Section 6.5.3, “Using MySQL Enterprise Data Masking and De-Identification”

MASTER_POS_WAIT()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 16.2.2.1, “Commands for Operations on a Single Channel”
Section 16.2.2.2, “Compatibility with Previous Replication Statements”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.20, “Miscellaneous Functions”
Section A.14, “MySQL 5.7 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 14.6.2.4, “InnoDB Full-Text Indexes”
MySQL Glossary
Section 12.9.1, “Natural Language Full-Text Searches”

MAX()

Section 11.2.10, “2-Digit Years in Dates”
Section 12.19.1, “Aggregate Function Descriptions”
Section 8.2.1.15, “GROUP BY Optimization”
Section 8.3.1, “How MySQL Uses Indexes”
Section B.3.7, “Known Issues in MySQL”
Section 21.5.24, “ndb_restore — Restore an NDB Cluster Backup”
Section 11.1.1, “Numeric Data Type Syntax”
Section 8.2.2.4, “Optimizing Derived Tables and View References with Merging or Materialization”
Section 13.2.10.10, “Optimizing Subqueries”
Section 5.1.10, “Server SQL Modes”
Section 24.5.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
Section 11.5, “The JSON Data Type”
Section 1.2.2, “The Main Features of MySQL”
Section 23.5.3, “Updatable and Insertable Views”
Section 8.3.9, “Use of Index Extensions”
Section 3.6.9, “Using AUTO_INCREMENT”

MBRContains()

Section 12.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”
Section 11.4.10, “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”

MBREqual()

Section 12.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”
Section 1.3, “What Is New in MySQL 5.7”

MBREquals()

Section 12.16.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”
Section 1.3, “What Is New in MySQL 5.7”

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.4.10, “Using Spatial Indexes”

MD5()

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

MICROSECOND()

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

MID()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

MIN()

Section 11.2.10, “2-Digit Years in Dates”
Section 12.19.1, “Aggregate Function Descriptions”
Section 8.2.1.15, “GROUP BY Optimization”
Section 8.3.1, “How MySQL Uses Indexes”
Section B.3.7, “Known Issues in MySQL”
Section 21.5.24, “ndb_restore — Restore an NDB Cluster Backup”
Section 11.1.1, “Numeric Data Type Syntax”
Section 8.2.2.4, “Optimizing Derived Tables and View References with Merging or Materialization”
Section 13.2.10.10, “Optimizing Subqueries”
Section B.3.4.3, “Problems with NULL Values”
Section 11.5, “The JSON Data Type”
Section 1.2.2, “The Main Features of MySQL”
Section 23.5.3, “Updatable and Insertable Views”
Section 8.3.9, “Use of Index Extensions”
Section 8.2.1.1, “WHERE Clause Optimization”

MINUTE()

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

MLineFromText()

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

MLineFromWKB()

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

MOD()

Section 12.6.1, “Arithmetic Operators”
Section 3.3.4.5, “Date Calculations”
Section 12.6.2, “Mathematical Functions”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 22.6.3, “Partitioning Limitations Relating to Functions”
Section 5.1.10, “Server SQL Modes”

MONTH()

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

MONTHNAME()

Section 12.7, “Date and Time Functions”
Section 10.16, “MySQL Server Locale Support”
Section 5.1.7, “Server System Variables”

MPointFromText()

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

MPointFromWKB()

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

MPolyFromText()

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

MPolyFromWKB()

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

MultiLineString()

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

MultiLineStringFromText()

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

MultiLineStringFromWKB()

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

MultiPoint()

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

MultiPointFromText()

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

MultiPointFromWKB()

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

MultiPolygon()

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

MultiPolygonFromText()

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

MultiPolygonFromWKB()

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

my_open()

Section 5.1.9, “Server Status Variables”

mysql_firewall_flush_status()

Section 6.4.6.4, “MySQL Enterprise Firewall Reference”

N

NAME_CONST()

Section 12.20, “Miscellaneous Functions”
Section 23.7, “Stored Program Binary Logging”

normalize_statement()

Section 6.4.6.4, “MySQL Enterprise Firewall Reference”

NOW()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 11.2.6, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 13.1.18.7, “CREATE TABLE and Generated Columns”
Section 11.6, “Data Type Default Values”
Section 12.7, “Date and Time Functions”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 11.2.7, “Fractional Seconds in Time Values”
Section 8.10.3.1, “How the Query Cache Operates”
Section A.1, “MySQL 5.7 FAQ: General”
Section 5.1.13, “MySQL Server Time Zone Support”
Section 16.4.1.15, “Replication and System Functions”
Section 16.4.1.31, “Replication and Time Zones”
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”
Section 26.4.3.21, “The metrics View”
Section 26.4.4.25, “The statement_performance_analyzer() Procedure”
Section 11.2.4, “The YEAR Type”

NULLIF()

Section 12.5, “Flow Control Functions”

NumGeometries()

Section 12.16.7.5, “GeometryCollection Property Functions”

NumInteriorRings()

Section 12.16.7.4, “Polygon and MultiPolygon Property Functions”

NumPoints()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”

O

OCT()

Section 12.8, “String Functions and Operators”

OCTET_LENGTH()

Section 12.8, “String Functions and Operators”

ORD()

Section 12.8, “String Functions and Operators”

Overlaps()

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

P

PASSWORD()

Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 12.13, “Encryption and Compression Functions”
Section 8.10.3.1, “How the Query Cache Operates”
Section B.3.2.13, “Ignoring user”
Section 22.2.5, “KEY Partitioning”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 6.1.2.4, “Password Hashing in MySQL”
Section 6.4.3.2, “Password Validation Plugin Options and Variables”
Section 6.1.2.3, “Passwords and Logging”
Section 5.1.7, “Server System Variables”
Section 13.7.1.7, “SET PASSWORD Statement”
Section 6.4.3, “The Password Validation Plugin”
Section 1.3, “What Is New in MySQL 5.7”

PERIOD_ADD()

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

PERIOD_DIFF()

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

PI()

Section 9.2.5, “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.4.3, “Supported Spatial Data Formats”

PointFromText()

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

PointFromWKB()

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

PointN()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”

PolyFromText()

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

PolyFromWKB()

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

Polygon()

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

PolygonFromText()

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

PolygonFromWKB()

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

POSITION()

Section 12.8, “String Functions and Operators”

POW()

Section 8.2.1.18, “Function Call Optimization”
Section 22.2.4, “HASH Partitioning”
Section 12.6.2, “Mathematical Functions”

POWER()

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

Q

QUARTER()

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

QUOTE()

Section 12.8, “String Functions and Operators”
Section 9.1.1, “String Literals”

R

RADIANS()

Section 12.6.2, “Mathematical Functions”

RAND()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.2.1.18, “Function Call Optimization”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.6.2, “Mathematical Functions”
Section 16.4.1.15, “Replication and System Functions”
Section 5.1.7, “Server System Variables”

RANDOM_BYTES()

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

read_firewall_users()

Section 6.4.6.4, “MySQL Enterprise Firewall Reference”

read_firewall_whitelist()

Section 6.4.6.4, “MySQL Enterprise Firewall Reference”

RELEASE_ALL_LOCKS()

Section 2.10.3, “Changes in MySQL 5.7”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.14, “Locking Functions”

RELEASE_LOCK()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 13.2.3, “DO Statement”
Section 8.10.3.1, “How the Query Cache Operates”
Section 8.11.1, “Internal Locking Methods”
Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Statements”
Section 12.14, “Locking Functions”
Section 16.4.1.15, “Replication and System Functions”

REPEAT()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

REPLACE()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

REVERSE()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

RIGHT()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

ROUND()

Section 14.16.3, “InnoDB INFORMATION_SCHEMA System Tables”
Section 12.6.2, “Mathematical Functions”
Section 12.21, “Precision Math”
Section 12.21.5, “Precision Math Examples”
Section 12.21.4, “Rounding Behavior”

ROW_COUNT()

Section 13.2.1, “CALL Statement”
Section 13.2.2, “DELETE Statement”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 12.15, “Information Functions”
Section 13.2.5, “INSERT Statement”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 16.4.1.15, “Replication and System Functions”
Section 5.1.9, “Server Status Variables”
Section 13.6.7.7, “The MySQL Diagnostics Area”

RPAD()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

RTRIM()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

S

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 22.6.3, “Partitioning Limitations Relating to Functions”

service_get_read_locks()

Section 5.5.6.1.2, “The Locking Service Function Interface”

service_get_write_locks()

Section 5.5.6.1.2, “The Locking Service Function Interface”

service_release_locks()

Section 5.5.6.1.2, “The Locking Service Function Interface”

SESSION_USER()

Section 16.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”

set_firewall_mode()

Section 6.4.6.4, “MySQL Enterprise Firewall Reference”

setrlimit()

Section 5.1.7, “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 5.1.7, “Server System Variables”
Section 1.3, “What Is New in MySQL 5.7”

SIGN()

Section 12.6.2, “Mathematical Functions”

SIN()

Section 12.6.2, “Mathematical Functions”

SLEEP()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.14.3, “General Thread States”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.20, “Miscellaneous Functions”
Section 24.5.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”

SOUNDEX()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

SOURCE_POS_WAIT()

Section A.14, “MySQL 5.7 FAQ: Replication”

SPACE()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

SQRT()

Section 12.6.2, “Mathematical Functions”

SRID()

Section 12.16.7.1, “General Geometry Property Functions”

ST_Area()

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

ST_AsBinary()

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

ST_AsGeoJSON()

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

ST_AsText()

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

ST_Buffer()

Section 12.16.8, “Spatial Operator Functions”

ST_Buffer_Strategy()

Section 5.1.7, “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.9.1, “Spatial Relation Functions That Use Object Shapes”

ST_Distance_Sphere()

Section 12.16.12, “Spatial Convenience Functions”

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.5, “The JSON Data Type”

ST_GeomFromText()

Section 12.16.3, “Functions That Create Geometry Values from WKT Values”
Section 11.4.6, “Populating Spatial Columns”
Section 11.4.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.4.4, “Geometry Well-Formedness and Validity”
Section 12.16.12, “Spatial Convenience Functions”

ST_LatFromGeoHash()

Section 12.16.10, “Spatial Geohash Functions”

ST_Length()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”
Section 11.4, “Spatial Data Types”
Section 12.8, “String Functions and Operators”

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_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.4.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_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”

ST_StartPoint()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”
Section 12.16.8, “Spatial Operator 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_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.4.3, “Supported Spatial Data Formats”

ST_Y()

Section 12.16.7.2, “Point Property Functions”

StartPoint()

Section 12.16.7.3, “LineString and MultiLineString Property Functions”

STD()

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

STDDEV()

Section 12.19.1, “Aggregate Function Descriptions”

STDDEV_POP()

Section 12.19.1, “Aggregate Function Descriptions”

STDDEV_SAMP()

Section 12.19.1, “Aggregate Function Descriptions”

STR_TO_DATE()

Section 11.2, “Date and Time Data Types”
Section 12.7, “Date and Time Functions”
Section 10.16, “MySQL Server Locale Support”

STRCMP()

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

SUBDATE()

Section 12.7, “Date and Time Functions”

SUBSTR()

Section 12.8, “String Functions and Operators”

SUBSTRING()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

SUBSTRING_INDEX()

Section 6.2.18, “SQL-Based Account Activity Auditing”
Section 12.8, “String Functions and Operators”

SUBTIME()

Section 12.7, “Date and Time Functions”

SUM()

Section 12.19.1, “Aggregate Function Descriptions”
Section 13.7.3.1, “CREATE FUNCTION Statement for Loadable Functions”
Section 11.2.1, “Date and Time Data Type Syntax”
Section 8.2.1.15, “GROUP BY Optimization”
Section 12.20, “Miscellaneous Functions”
Section 8.2.2.4, “Optimizing Derived Tables and View References with Merging or Materialization”
Section B.3.4.3, “Problems with NULL Values”
Section 11.3.5, “The ENUM Type”
Section 1.2.2, “The Main Features of MySQL”
Section 11.3.6, “The SET Type”
Section 23.5.3, “Updatable and Insertable Views”

SYSDATE()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 12.7, “Date and Time Functions”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 16.4.1.13, “Replication and Fractional Seconds Support”
Section 16.4.1.15, “Replication and System Functions”
Section 5.1.6, “Server Command Options”
Section 5.1.7, “Server System Variables”

SYSTEM_USER()

Section 16.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

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 22.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.8, “String Functions and Operators”

TO_DAYS()

Section 12.7, “Date and Time Functions”
Section 22.2.4, “HASH Partitioning”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 22.4, “Partition Pruning”
Section 22.6.3, “Partitioning Limitations Relating to Functions”
Section 22.2, “Partitioning Types”

TO_SECONDS()

Section 12.7, “Date and Time Functions”
Section 22.4, “Partition Pruning”
Section 22.6.3, “Partitioning Limitations Relating to Functions”
Section 22.2, “Partitioning Types”

Touches()

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

TRIM()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 10.7, “Column Character Set Conversion”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 12.8, “String Functions and Operators”

TRUNCATE()

Section 12.6.2, “Mathematical Functions”

U

UCASE()

Section 12.8.3, “Character Set and Collation of Function Results”
Section 12.8, “String Functions and Operators”

UNCOMPRESS()

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

UNCOMPRESSED_LENGTH()

Section 12.13, “Encryption and Compression Functions”

UNHEX()

Section 12.13, “Encryption and Compression Functions”
Section 4.5.1.1, “mysql Client Options”
Section 12.8, “String Functions and Operators”

UNIX_TIMESTAMP()

Section 12.7, “Date and Time Functions”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 8.3.11, “Indexed Lookups from TIMESTAMP Columns”
Section 22.6.3, “Partitioning Limitations Relating to Functions”
Section 22.2.1, “RANGE Partitioning”
Section 5.1.7, “Server System Variables”
Section 26.4.3.21, “The metrics View”
Section B.3.3.7, “Time Zone Problems”

UpdateXML()

Section 12.11, “XML Functions”

UPPER()

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

USER()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 13.7.1.1, “ALTER USER Statement”
Section 10.8.4, “Collation Coercibility in Expressions”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.15, “Information Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 6.4.3.2, “Password Validation Plugin Options and Variables”
Section 6.2.14, “Proxy Users”
Section 16.4.1.15, “Replication and System Functions”
Section 6.2.18, “SQL-Based Account Activity Auditing”
Section 10.2.2, “UTF-8 for Metadata”

UTC_DATE

Section 12.7, “Date and Time Functions”

UTC_DATE()

Section 12.7, “Date and Time Functions”
Section 16.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 16.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 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 5.1.13, “MySQL Server Time Zone Support”
Section 16.4.1.13, “Replication and Fractional Seconds Support”

UUID()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 16.1.6.4, “Binary Logging Options and Variables”
Section 16.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”
Section 8.2.1.18, “Function Call Optimization”
Section 8.10.3.1, “How the Query Cache Operates”
Section 12.20, “Miscellaneous Functions”
Section 5.4.4.3, “Mixed Binary Logging Format”
Section 16.4.1.15, “Replication and System Functions”
Section 5.4.4.2, “Setting The Binary Log Format”
Section 23.7, “Stored Program Binary Logging”

UUID_SHORT()

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

V

VALIDATE_PASSWORD_STRENGTH()

Section 12.13, “Encryption and Compression Functions”
Section 6.4.3.2, “Password Validation Plugin Options and Variables”
Section 6.4.3, “The Password Validation Plugin”

VALUES()

Section 13.2.5.2, “INSERT ... ON DUPLICATE KEY UPDATE Statement”
Section 12.20, “Miscellaneous Functions”

VAR_POP()

Section 12.19.1, “Aggregate Function Descriptions”

VAR_SAMP()

Section 12.19.1, “Aggregate Function Descriptions”

VARIANCE()

Section 12.19.1, “Aggregate Function Descriptions”

VERSION()

Section 16.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
Section 6.4.5.4, “Audit Log File Formats”
Section B.3.4.1, “Case Sensitivity in String Searches”
Section 10.8.4, “Collation Coercibility in Expressions”
Section 12.15, “Information Functions”
Section 16.4.1.15, “Replication and System Functions”
Section 26.4.3.47, “The version View”
Section 10.2.2, “UTF-8 for Metadata”
Section 1.3, “What Is New in MySQL 5.7”

version_tokens_delete()

Section 5.5.5.3, “Using Version Tokens”
Section 5.5.5.4, “Version Tokens Reference”

version_tokens_edit()

Section 5.5.5.3, “Using Version Tokens”
Section 5.5.5.4, “Version Tokens Reference”

version_tokens_lock_exclusive()

Section 5.5.5.3, “Using Version Tokens”
Section 5.5.5.4, “Version Tokens Reference”

version_tokens_lock_shared()

Section 5.5.5.3, “Using Version Tokens”
Section 5.5.5.4, “Version Tokens Reference”

version_tokens_set()

Section 5.5.5.3, “Using Version Tokens”
Section 5.5.5.4, “Version Tokens Reference”

version_tokens_show()

Section 5.5.5.3, “Using Version Tokens”
Section 5.5.5.4, “Version Tokens Reference”

version_tokens_unlock()

Section 5.5.5.3, “Using Version Tokens”
Section 5.5.5.4, “Version Tokens Reference”

W

WAIT_FOR_EXECUTED_GTID_SET()

Section 12.18, “Functions Used with Global Transaction Identifiers (GTIDs)”
Section 16.1.4.1, “Replication Mode Concepts”

WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()

Section 16.2.2.1, “Commands for Operations on a Single Channel”
Section 16.2.2.2, “Compatibility with Previous Replication Statements”
Section 12.18, “Functions Used with Global Transaction Identifiers (GTIDs)”
Section 13.4.2.5, “START SLAVE Statement”

WEEK()

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

WEEKDAY()

Section 12.7, “Date and Time Functions”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 22.6.3, “Partitioning Limitations Relating to Functions”
Section 22.2, “Partitioning Types”

WEEKOFYEAR()

Section 12.7, “Date and Time Functions”

WEIGHT_STRING()

Section 10.14, “Adding a Collation to a Character Set”
Section B.3.4.1, “Case Sensitivity in String Searches”
Section 12.8, “String Functions and Operators”
Section 10.10.1, “Unicode Character Sets”

Within()

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

X

X()

Section 12.16.7.2, “Point Property Functions”

Y

Y()

Section 12.16.7.2, “Point Property Functions”

YEAR()

Section 12.7, “Date and Time Functions”
Section 3.3.4.5, “Date Calculations”
Section 22.2.4, “HASH Partitioning”
Section 22.2.7, “How MySQL Partitioning Handles NULL”
Section 22.3.1, “Management of RANGE and LIST Partitions”
Section 22.4, “Partition Pruning”
Section 22.6.3, “Partitioning Limitations Relating to Functions”
Section 22.2, “Partitioning Types”
Section 22.2.1, “RANGE Partitioning”

YEARWEEK()

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

PREV HOME UP NEXT

PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 255.8Kb
Man Pages (Zip) - 360.7Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb