MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
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
ABS()
ADDDATE()
ADDTIME()
AES_DECRYPT()
AES_ENCRYPT()
ANY_VALUE()
asymmetric_decrypt()
asymmetric_derive()
asymmetric_encrypt()
asymmetric_sign()
asymmetric_verify()
asynchronous_connection_failover_add_managed
asynchronous_connection_failover_add_managed()
asynchronous_connection_failover_add_source
asynchronous_connection_failover_add_source()
asynchronous_connection_failover_delete_managed
asynchronous_connection_failover_delete_managed()
asynchronous_connection_failover_delete_source
asynchronous_connection_failover_delete_source()
asynchronous_connection_failover_reset()
audit_api_message_emit_udf()
audit_log_encryption_password_get()
audit_log_encryption_password_set()
audit_log_filter_flush()
audit_log_filter_remove_filter()
audit_log_filter_remove_user()
audit_log_filter_set_filter()
audit_log_filter_set_user()
audit_log_read()
audit_log_read_bookmark()
audit_log_rotate()
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 1.3, “What Is New in MySQL 8.0”
- Section 14.20.3, “Window Function Frame Specification”
BENCHMARK()
BIN_TO_UUID()
BIT_AND()
BIT_COUNT()
BIT_LENGTH()
BIT_OR()
BIT_XOR()
CAN_ACCESS_COLUMN()
CAN_ACCESS_DATABASE()
CAN_ACCESS_TABLE()
CAN_ACCESS_USER()
CAN_ACCESS_VIEW()
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.6.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 1.3, “What Is New in MySQL 8.0”
- Section 15.2.20, “WITH (Common Table Expressions)”
CAST(expr AS type
CEILING()
CHAR()
CHAR_LENGTH()
CHARACTER_LENGTH()
CHARSET()
COALESCE
COALESCE()
COERCIBILITY()
COLLATION()
COMPRESS()
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.6.1, “MySQL Extensions to Standard SQL”
- Section 7.1.11, “Server SQL Modes”
- Section 15.7.7.13, “SHOW CREATE VIEW Statement”
- Section 14.8, “String Functions and Operators”
- Section 28.3.48, “The INFORMATION_SCHEMA VIEWS Table”
- Section 14.3, “Type Conversion in Expression Evaluation”
- Section 14.11, “XML Functions”
CONCAT_WS()
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.29, “SHOW PROCESSLIST Statement”
- Section 29.12.21.2, “The error_log Table”
- Section 28.3.23, “The INFORMATION_SCHEMA PROCESSLIST Table”
- Section 29.12.21.7, “The processlist Table”
- Section 29.12.21.8, “The threads Table”
CONV()
CONVERT()
- Section 14.10, “Cast Functions and Operators”
- Section 3.5, “Changes in MySQL 8.0”
- 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.0 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”
- Section 1.3, “What Is New in MySQL 8.0”
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”
- Section 1.3, “What Is New in MySQL 8.0”
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.23, “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.6.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”
create_asymmetric_priv_key()
create_asymmetric_pub_key()
create_dh_parameters()
create_digest()
CUME_DIST()
CURDATE()
CURRENT_DATE()
CURRENT_TIME
CURRENT_TIME()
CURRENT_TIMESTAMP
CURRENT_TIMESTAMP()
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.12, “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.15, “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.12, “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()
DATABASE()
DATE_ADD()
DATE_FORMAT()
DATE_SUB()
DATEDIFF()
DAY()
DAYNAME()
DAYOFMONTH()
DAYOFWEEK()
DAYOFYEAR()
DEFAULT()
DEGREES()
DENSE_RANK()
ELT()
EXPORT_SET()
EXTRACT()
ExtractValue()
firewall_group_delist()
firewall_group_enlist()
FIRST_VALUE()
FLOOR()
FORMAT()
FORMAT_BYTES()
FORMAT_PICO_TIME()
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”
- Section 1.3, “What Is New in MySQL 8.0”
FROM_BASE64()
FROM_DAYS()
FROM_UNIXTIME()
gen_blacklist()
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()
gen_dictionary_load()
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()
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()
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()
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()
GeometryCollection()
GET_DD_COLUMN_PRIVILEGES()
GET_DD_CREATE_OPTIONS()
GET_DD_INDEX_SUB_PART_LENGTH()
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”
gettimeofday()
GREATEST()
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.6.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 15.4.2.1, “CHANGE MASTER 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 19.4.9, “Switching Sources and Replicas with Asynchronous Connection Failover”
group_replication_disable_member_action()
group_replication_enable_member_action
group_replication_enable_member_action()
group_replication_get_communication_protocol()
- Section 14.18.1.4, “Functions to Inspect and Set the Group Replication Communication Protocol Version”
- Section 20.8.1.2, “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()
group_replication_reset_member_actions
group_replication_reset_member_actions()
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”
group_replication_set_communication_protocol()
- Section 14.18.1.4, “Functions to Inspect and Set the Group Replication Communication Protocol Version”
- Section 20.8.1.2, “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()
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()
GROUPING()
GTID_SUBSET()
GTID_SUBTRACT()
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.15, “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()
ICU_VERSION()
IF()
IFNULL()
INET6_ATON()
INSTR()
INTERNAL_AUTO_INCREMENT()
INTERNAL_AVG_ROW_LENGTH()
INTERNAL_CHECK_TIME()
INTERNAL_CHECKSUM()
INTERNAL_DATA_FREE()
INTERNAL_DATA_LENGTH()
INTERNAL_DD_CHAR_LENGTH()
INTERNAL_GET_COMMENT_OR_ERROR()
INTERNAL_GET_ENABLED_ROLE_JSON()
INTERNAL_GET_HOSTNAME()
INTERNAL_GET_USERNAME()
INTERNAL_GET_VIEW_WARNING_OR_ERROR()
INTERNAL_INDEX_COLUMN_CARDINALITY()
INTERNAL_INDEX_LENGTH()
INTERNAL_IS_ENABLED_ROLE()
INTERNAL_IS_MANDATORY_ROLE()
INTERNAL_KEYS_DISABLED()
INTERNAL_MAX_DATA_LENGTH()
INTERNAL_TABLE_ROWS()
INTERNAL_UPDATE_TIME()
IS_FREE_LOCK()
IS_IPV4()
IS_IPV4_COMPAT()
IS_IPV4_MAPPED()
IS_IPV6()
IS_USED_LOCK()
IS_UUID()
IS_VISIBLE_DD_OBJECT()
JSON_ARRAY()
JSON_ARRAY_APPEND()
JSON_ARRAY_INSERT()
JSON_ARRAYAGG()
JSON_CONTAINS()
JSON_CONTAINS_PATH()
JSON_EXTRACT()
JSON_INSERT()
JSON_MERGE()
JSON_MERGE_PATCH()
JSON_MERGE_PRESERVE()
JSON_OBJECT()
JSON_OBJECTAGG()
JSON_OVERLAPS()
JSON_PRETTY()
JSON_QUOTE()
JSON_REMOVE()
JSON_REPLACE()
JSON_SCHEMA_VALID()
JSON_SCHEMA_VALIDATION_REPORT()
JSON_SEARCH()
JSON_SET()
JSON_STORAGE_FREE()
JSON_STORAGE_SIZE()
JSON_TABLE()
JSON_TYPE()
JSON_UNQUOTE(
JSON_UNQUOTE()
JSON_VALUE()
keyring_aws_rotate_cmk()
keyring_aws_rotate_keys()
keyring_hashicorp_update_config()
keyring_key_fetch()
keyring_key_generate()
keyring_key_length_fetch()
keyring_key_remove()
keyring_key_store()
keyring_key_type_fetch()
LAST_DAY()
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.6.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 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()
LCASE()
LEAST()
LENGTH()
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()
LOCALTIME
LOCALTIME()
LOCALTIMESTAMP
LOCALTIMESTAMP()
LOWER()
LPAD()
LTRIM()
MAKEDATE()
MAKETIME()
mask_canada_sin()
mask_iban()
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.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()
mask_uuid()
masking_dictionary_remove()
masking_dictionary_term_add()
masking_dictionary_term_remove()
MASTER_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.0 FAQ: Replication”
- Section 14.18.4, “Position-Based Synchronization 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 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.1, “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()
MBRIntersects()
MBRWithin()
MD5()
MICROSECOND()
MID()
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()
MOD()
MONTH()
MONTHNAME()
MultiLineString()
mysql_firewall_flush_status()
mysql_query_attribute_string()
normalize_statement()
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 13.6, “Data Type Default Values”
- 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.0 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()
OCTET_LENGTH()
PERCENT_RANK()
PERIOD_ADD()
PERIOD_DIFF()
Point()
POW()
PS_CURRENT_THREAD_ID()
PS_THREAD_ID()
QUARTER()
RADIANS()
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()
read_firewall_group_allowlist()
read_firewall_groups()
read_firewall_users()
read_firewall_whitelist()
REGEXP_LIKE()
RELEASE_ALL_LOCKS()
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()
REPLACE()
REVERSE()
RIGHT()
ROUND()
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()
RPAD()
RTRIM()
SEC_TO_TIME()
SECOND()
service_get_read_locks()
service_get_write_locks()
service_release_locks()
SESSION_USER()
set_firewall_group_mode()
set_firewall_mode()
setrlimit()
SHA2()
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.2, “The tp_thread_group_stats Table”
SOUNDEX()
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.0 FAQ: Replication”
- Section 14.18.4, “Position-Based Synchronization Functions”
SPACE()
ST_Area()
ST_AsBinary()
ST_AsText()
ST_AsWKT()
ST_Buffer()
ST_Buffer_Strategy()
ST_Collect(
ST_Collect()
ST_ConvexHull()
ST_Difference()
ST_Dimension()
ST_Distance()
ST_Distance_Sphere()
ST_EndPoint()
ST_Envelope()
ST_ExteriorRing()
ST_FrechetDistance()
ST_GeoHash()
ST_GeomCollFromText()
ST_GeomCollFromTxt()
ST_GeomCollFromWKB()
ST_GeometryCollectionFromText()
ST_GeometryCollectionFromWKB()
ST_GeometryFromText()
ST_GeometryFromWKB()
ST_GeometryN()
ST_GeometryType()
ST_GeomFromGeoJSON()
ST_GeomFromText()
ST_HausdorffDistance()
ST_InteriorRingN()
ST_Intersection()
ST_IsSimple()
ST_IsValid()
ST_LatFromGeoHash()
ST_Latitude()
ST_Length()
ST_LineFromText()
ST_LineInterpolatePoint()
ST_LineInterpolatePoints()
ST_LineStringFromText()
ST_LineStringFromWKB()
ST_LongFromGeoHash()
ST_Longitude()
ST_MakeEnvelope()
ST_MLineFromText()
ST_MLineFromWKB()
ST_MPointFromText()
ST_MPointFromWKB()
ST_MPolyFromText()
ST_MPolyFromWKB()
ST_MultiLineStringFromText()
ST_MultiLineStringFromWKB()
ST_MultiPointFromText()
ST_MultiPointFromWKB()
ST_MultiPolygonFromText()
ST_MultiPolygonFromWKB()
ST_NumGeometries()
ST_NumInteriorRing()
ST_NumInteriorRings()
ST_NuminteriorRings()
ST_PointAtDistance()
ST_PointFromGeoHash()
ST_PointFromText()
ST_PointFromWKB()
ST_PointN()
ST_PolyFromText()
ST_PolygonFromText()
ST_PolygonFromWKB()
ST_Simplify()
ST_SRID()
ST_StartPoint()
ST_SymDifference()
ST_TRANSFORM()
ST_Transform()
ST_Validate()
ST_X()
STATEMENT_DIGEST()
STATEMENT_DIGEST_TEXT()
STD()
STDDEV_POP()
STDDEV_SAMP()
STR_TO_DATE()
STRCMP()
SUBDATE()
SUBSTRING()
SUBSTRING_INDEX()
SUBTIME()
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 1.3, “What Is New in MySQL 8.0”
- 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()
TIME_TO_SEC()
TIMEDIFF()
TIMESTAMP()
TIMESTAMPADD()
TO_BASE64()
TO_DAYS()
TO_SECONDS()
TRIM()
TRUNCATE()
UCASE()
UNCOMPRESS()
UNCOMPRESSED_LENGTH()
UNHEX()
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”
- Section 1.3, “What Is New in MySQL 8.0”
UpdateXML()
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()
UTC_TIME()
UTC_TIMESTAMP
UTC_TIMESTAMP()
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()
VALIDATE_PASSWORD_STRENGTH()
VALUES()
VAR_POP()
VAR_SAMP()
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()
version_tokens_edit()
version_tokens_lock_exclusive()
version_tokens_lock_shared()
version_tokens_set()
version_tokens_show()
version_tokens_unlock()
WAIT_FOR_EXECUTED_GTID_SET()
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()
WEEKDAY()
WEEKOFYEAR()
WEIGHT_STRING()
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”