| title | summary | aliases | ||
|---|---|---|---|---|
Encryption and Compression Functions |
Learn about the encryption and compression functions. |
|
TiDB supports most of the encryption and compression functions available in MySQL 5.7.
| Name | Description |
|---|---|
MD5() |
Calculate MD5 checksum |
PASSWORD() |
Calculate and return a password string |
RANDOM_BYTES() |
Return a random byte vector |
SHA1(), SHA() |
Calculate an SHA-1 160-bit checksum |
SHA2() |
Calculate an SHA-2 checksum |
SM3() |
Calculate an SM3 checksum (currently MySQL does not support this function) |
AES_DECRYPT() |
Decrypt using AES |
AES_ENCRYPT() |
Encrypt using AES |
COMPRESS() |
Return result as a binary string |
UNCOMPRESS() |
Uncompress a string compressed |
UNCOMPRESSED_LENGTH() |
Return the length of a string before compression |
VALIDATE_PASSWORD_STRENGTH() |
Validate the password strength |
The block_encryption_mode variable sets the encryption mode that is used for AES_ENCRYPT() and AES_DECRYPT().
DES_DECRYPT(),DES_ENCRYPT(),OLD_PASSWORD(),ENCRYPT(): these functions were deprecated in MySQL 5.7 and removed in 8.0.- Functions only available in MySQL Enterprise Issue #2632.