MySQL :: MySQL 8.4 参考手册 :: 14.2 可加载函数参考

MySQL 8.4 参考手册 · 中文镜像

正文为中文，英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

译文由机器翻译生成，仅供理解参考；有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 14 函数和运算符 / 14.2 可加载函数参考

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 52%

14.2 可加载函数参考14.2 Loadable Function Reference

下表列出了运行时可加载的每个函数，并提供了每个函数的简要描述。有关内置函数和操作符的列表，请参见第 14.1 节，“内置函数和操作符参考”The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference”

有关可加载函数的一般信息，请参见第 7.7 节，“MySQL 服务器可加载函数”。For general information about loadable functions, see Section 7.7, “MySQL Server Loadable Functions”.

表 14.2 可加载函数Table 14.2 Loadable Functions

名称Name	说明Description	已弃用Deprecated
`asymmetric_decrypt()`	使用私钥或公钥解密密文Decrypt ciphertext using private or public key
`asymmetric_derive()`	从非对称密钥派生对称密钥Derive symmetric key from asymmetric keys
`asymmetric_encrypt()`	使用私钥或公钥加密明文Encrypt cleartext using private or public key
`asymmetric_sign()`	从摘要生成签名Generate signature from digest
`asymmetric_verify()`	验证签名是否与摘要匹配Verify that signature matches digest
`asynchronous_connection_failover_add_managed()`	在托管组中将复制源服务器添加到源列表Add a replication source server in a managed group to the source list
`asynchronous_connection_failover_add_source()`	将复制源服务器添加到源列表Add a replication source server to the source list
`asynchronous_connection_failover_delete_managed()`	从源列表中移除托管的复制源服务器组Remove managed group of replication source servers from the source list
`asynchronous_connection_failover_delete_source()`	从源列表中移除复制源服务器Remove a replication source server from the source list
`audit_api_message_emit_udf()`	将消息事件添加到审计日志Add message event to audit log
`audit_log_encryption_password_get()`	获取审计日志加密密码Fetch audit log encryption password
`audit_log_encryption_password_set()`	设置审计日志加密密码Set audit log encryption password
`audit_log_filter_flush()`	刷新审计日志过滤表Flush audit log filter tables
`audit_log_filter_remove_filter()`	移除审计日志过滤器Remove audit log filter
`audit_log_filter_remove_user()`	取消分配用户的审计日志过滤器Unassign audit log filter from user
`audit_log_filter_set_filter()`	定义审计日志过滤器Define audit log filter
`audit_log_filter_set_user()`	将审计日志过滤器分配给用户Assign audit log filter to user
`audit_log_read()`	返回审计日志记录Return audit log records
`audit_log_read_bookmark()`	为最新的审计日志事件添加书签Bookmark for most recent audit log event
`audit_log_rotate()`	轮换审计日志文件Rotate audit log file
`create_asymmetric_priv_key()`	创建私钥Create private key
`create_asymmetric_pub_key()`	创建公钥Create public key
`create_dh_parameters()`	生成共享 DH 密钥Generate shared DH secret
`create_digest()`	从字符串生成摘要Generate digest from string
`firewall_group_delist()`	从防火墙组配置文件中移除账户Remove account from firewall group profile
`firewall_group_enlist()`	将账户添加到防火墙组配置文件Add account to firewall group profile
`flush_rewrite_rules()`	将 rewrite_rules 表加载到 Rewriter 缓存中Load rewrite_rules table into Rewriter cache
`gen_blacklist()`	执行词典术语替换Perform dictionary term replacement	是Yes
`gen_blocklist()`	执行词典术语替换Perform dictionary term replacement
`gen_blocklist()`	执行词典术语替换Perform dictionary term replacement
`gen_dictionary()`	从字典中返回随机词条Return random term from dictionary
`gen_dictionary_drop()`	从注册表中移除字典Remove dictionary from registry
`gen_dictionary_load()`	将词典加载到注册表Load dictionary into registry
`gen_dictionary()`	从字典中返回随机词条Return random term from dictionary
`gen_range()`	在范围内生成随机数Generate random number within range
`gen_range()`	在范围内生成随机数Generate random number within range
`gen_rnd_canada_sin()`	生成随机加拿大社会保险号Generate random Canada Social Insurance Number
`gen_rnd_email()`	生成随机电子邮件地址Generate random email address
`gen_rnd_email()`	生成随机电子邮件地址Generate random email address
`gen_rnd_iban()`	生成随机国际银行账户号码Generate random International Bank Account Number
`gen_rnd_pan()`	生成随机支付卡主账户号码Generate random payment card Primary Account Number
`gen_rnd_pan()`	生成随机支付卡主账户号码Generate random payment card Primary Account Number
`gen_rnd_ssn()`	生成随机美国社会保障号码Generate random US Social Security Number
`gen_rnd_ssn()`	生成随机美国社会保障号码Generate random US Social Security Number
`gen_rnd_uk_nin()`	生成随机的英国国家保险号码Generate random United Kingdom National Insurance Number
`gen_rnd_us_phone()`	生成随机的美国电话号码Generate random US phone number
`gen_rnd_us_phone()`	生成随机的美国电话号码Generate random US phone number
`gen_rnd_uuid()`	生成随机的通用唯一标识符Generate random Universally Unique Identifier
`group_replication_disable_member_action()`	启用成员操作，以便成员在指定情况下不执行该操作Enable a member action so that the member does not take it in the specified situation
`group_replication_enable_member_action()`	为成员在指定情况下采取操作启用成员操作Enable a member action for the member to take in the specified situation
`group_replication_get_communication_protocol()`	返回组复制协议版本Return Group Replication protocol version
`group_replication_get_write_concurrency()`	返回可并行执行的最大共识实例数Return maximum number of consensus instances executable in parallel
`group_replication_reset_member_actions()`	将成员操作配置重置为默认设置Reset the member actions configuration to the default settings
`group_replication_set_as_primary()`	将组成员分配为新的主要成员Assign group member as new primary
`group_replication_set_communication_protocol()`	设置组复制协议版本Set Group Replication protocol version
`group_replication_set_write_concurrency()`	设置可并行执行的共识实例最大数量Set maximum number of consensus instances executable in parallel
`group_replication_switch_to_multi_primary_mode()`	将组从单主模式更改为多主模式Change group from single-primary to multi-primary mode
`group_replication_switch_to_single_primary_mode()`	将群组从多主模式更改为单主模式Change group from multi-primary to single-primary mode
`keyring_aws_rotate_cmk()`	轮换 AWS 客户主密钥Rotate AWS customer master key
`keyring_aws_rotate_keys()`	在 keyring_aws 存储文件中轮换密钥Rotate keys in keyring_aws storage file
`keyring_hashicorp_update_config()`	导致运行时 keyring_hashicorp 重新配置Cause runtime keyring_hashicorp reconfiguration
`keyring_key_fetch()`	获取钥匙串密钥值Fetch keyring key value
`keyring_key_generate()`	生成随机钥匙串密钥Generate random keyring key
`keyring_key_length_fetch()`	返回钥匙链密钥长度Return keyring key length
`keyring_key_remove()`	移除钥匙链密钥Remove keyring key
`keyring_key_store()`	将密钥存储在钥匙圈中Store key in keyring
`keyring_key_type_fetch()`	返回钥匙链密钥类型Return keyring key type
`load_rewrite_rules()`	重写器插件辅助程序Rewriter plugin helper routine
`mask_canada_sin()`	屏蔽加拿大社会保险号Mask Canada Social Insurance Number
`mask_iban()`	掩码国际银行帐号Mask International Bank Account Number
`mask_inner()`	掩盖字符串的内部部分Mask interior part of string
`mask_inner()`	掩盖字符串的内部部分Mask interior part of string
`mask_outer()`	遮蔽字符串的左右部分Mask left and right parts of string
`mask_outer()`	遮蔽字符串的左右部分Mask left and right parts of string
`mask_pan()`	屏蔽支付卡主账户号码的部分字符串Mask payment card Primary Account Number part of string
`mask_pan()`	屏蔽支付卡主账户号码的部分字符串Mask payment card Primary Account Number part of string
`mask_pan_relaxed()`	屏蔽支付卡主账户号码的部分字符串Mask payment card Primary Account Number part of string
`mask_pan_relaxed()`	屏蔽支付卡主账户号码的部分字符串Mask payment card Primary Account Number part of string
`mask_ssn()`	屏蔽美国社会保障号码Mask US Social Security Number
`mask_ssn()`	屏蔽美国社会保障号码Mask US Social Security Number
`mask_uk_nin()`	屏蔽英国国家保险号码Mask United Kingdom National Insurance Number
`mask_uuid()`	掩盖字符串中的通用唯一标识符部分Mask Universally Unique Identifier part of string
`masking_dictionaries_flush()`	导致 masking_dictionaries 缓存从表格重新加载Cause masking_dictionaries cache to be reloaded from table
`masking_dictionary_remove()`	从表中删除字典Remove dictionary from the database table
`masking_dictionary_term_add()`	向词典添加新词条Add new term to the dictionary
`masking_dictionary_term_remove()`	从字典中删除现有条目Remove existing term from the dictionary
`mysql_firewall_flush_status()`	重置防火墙状态变量Reset firewall status variables
`mysql_query_attribute_string()`	获取查询属性值Fetch query attribute value
`normalize_statement()`	将 SQL 语句规范化为摘要形式Normalize SQL statement to digest form
`read_firewall_group_allowlist()`	更新防火墙组配置文件已记录的声明缓存Update firewall group profile recorded-statement cache
`read_firewall_groups()`	更新防火墙组配置文件缓存Update firewall group profile cache
`read_firewall_users()`	更新防火墙账户配置缓存Update firewall account profile cache	是Yes
`read_firewall_whitelist()`	更新防火墙账户档案记录-声明缓存Update firewall account profile recorded-statement cache	是Yes
`service_get_read_locks()`	获取锁定服务共享锁Acquire locking service shared locks
`service_get_write_locks()`	获取锁定服务独占锁Acquire locking service exclusive locks
`service_release_locks()`	释放锁定的服务锁Release locking service locks
`set_firewall_group_mode()`	建立防火墙组配置文件操作模式Establish firewall group profile operational mode
`set_firewall_mode()`	建立防火墙账户配置操作模式Establish firewall account profile operational mode	是Yes
`version_tokens_delete()`	从版本令牌列表中删除令牌Delete tokens from version tokens list
`version_tokens_edit()`	修改版本标记列表Modify version tokens list
`version_tokens_lock_exclusive()`	获取版本令牌的独占锁Acquire exclusive locks on version tokens
`version_tokens_lock_shared()`	获取版本令牌的共享锁Acquire shared locks on version tokens
`version_tokens_set()`	设置版本标记列表Set version tokens list
`version_tokens_show()`	返回版本令牌列表Return version tokens list
`version_tokens_unlock()`	释放版本代币锁定Release version tokens locks

首页上一级下一节