Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 29.0Mb
PDF (A4) - 29.0Mb
PDF (RPM) - 28.0Mb
HTML Download (TGZ) - 7.1Mb
HTML Download (Zip) - 7.1Mb
HTML Download (RPM) - 6.1Mb
Man Pages (TGZ) - 181.9Kb
Man Pages (Zip) - 291.7Kb
Info (Gzip) - 2.8Mb
Info (Zip) - 2.8Mb
Excerpts from this Manual

MySQL 5.6 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() (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