Encryption, Hashing and Compression Functions
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(), or, in Oracle mode, matches expressions. |
| 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(). |
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
© 2021 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/