Encryption, hashing and compression functions, such as ENCRYPT, DECRYPT, COMPRESS, PASSWORD etc.
| Title | Description |
|---|---|
| AES_DECRYPT | Decryption data encrypted with AES_ENCRYPT |
| AES_ENCRYPT | Encrypts a string with the AES algorithm. |
| COMPRESS | Returns a binary, compressed string. |
| DECODE | Decrypts a string encoded with ENCODE(). |
| DES_DECRYPT | Decrypts a string encrypted with DES_ENCRYPT(). |
| DES_ENCRYPT | Encrypts a string using the Triple-DES algorithm. |
| ENCODE | Encrypts a string. |
| ENCRYPT | Encrypts a string with Unix crypt(). |
| MD5 | MD5 checksum. |
| OLD_PASSWORD | Pre MySQL 4.1 password implementation. |
| PASSWORD | Calculates a password string. |
| SHA1 | Calculates an SHA-1 checksum. |
| SHA2 | Calculates an SHA-2 checksum. |
| UNCOMPRESS | Uncompresses string compressed with COMPRESS(). |
| UNCOMPRESSED_LENGTH | Returns length of a string before being compressed with COMPRESS(). |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/encryption-hashing-and-compression-functions/