Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 36.6Mb
PDF (A4) - 36.6Mb
PDF (RPM) - 36.7Mb
HTML Download (TGZ) - 10.7Mb
HTML Download (Zip) - 10.7Mb
HTML Download (RPM) - 9.4Mb
Man Pages (TGZ) - 224.8Kb
Man Pages (Zip) - 332.7Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  Functions and Operators  /  User-Defined Function Reference

12.2 User-Defined Function Reference

The following table lists each user-defined function and provides a short description of each one. For a table listing SQL functions and operators, see Section 12.1, “SQL Function and Operator Reference”

For general information about user-defined functions, see Section 5.6, “MySQL Server User-Defined Functions”.

Table 12.2 User-Defined Functions

Name Description
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
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
create_asymmetric_priv_key() Create private key
create_asymmetric_pub_key() Create public key
create_dh_parameters() Generate shared DH secret
create_digest() Generate digest from string
gen_blacklist() 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_range() Generate random number within range
gen_rnd_email() Generate random email address
gen_rnd_pan() Generate random payment card Primary Account Number
gen_rnd_ssn() Generate random US Social Security number
gen_rnd_us_phone() Generate random US phone number
keyring_aws_rotate_cmk() Rotate AWS customer master key
keyring_aws_rotate_keys() Rotate keys in keyring_aws storage file
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_inner() Mask interior part of string
mask_outer() Mask left and right parts 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_ssn() Mask US Social Security number
mysql_firewall_flush_status() Reset firewall status variables
normalize_statement() Normalize SQL statement to digest form
read_firewall_users() Update firewall account profile cache
read_firewall_whitelist() Update firewall account profile recorded-statement cache
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_mode() Establish firewall account profile operational mode
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