MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
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() (introduced 5.6.21) |
Decrypt ciphertext using private or public key |
asymmetric_derive() (introduced 5.6.21) |
Derive symmetric key from asymmetric keys |
asymmetric_encrypt() (introduced 5.6.21) |
Encrypt cleartext using private or public key |
asymmetric_sign() (introduced 5.6.21) |
Generate signature from digest |
asymmetric_verify() (introduced 5.6.21) |
Verify that signature matches digest |
create_asymmetric_priv_key() (introduced 5.6.21) |
Create private key |
create_asymmetric_pub_key() (introduced 5.6.21) |
Create public key |
create_dh_parameters() (introduced 5.6.21) |
Generate shared DH secret |
create_digest() (introduced 5.6.21) |
Generate digest from string |
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 |
set_firewall_mode() |
Establish firewall account profile operational mode |