MySQL Encryption and Compression Functions
From w3cyberlearnings
| # | Function | Description |
|---|---|---|
| 1 | AES_DECRYPT | Decrypt using AES |
| 2 | AES_ENCRYPT | Encrypt using AES |
| 3 | COMPRESS | Return result as a binary string |
| 4 | DECODE | Decodes a string encrypted using ENCODE |
| 5 | DES_DECRYPT | Decrypt a string |
| 6 | DES_ENCRYPT | Encrypt a string |
| 7 | ENCODE | Encode a string |
| 8 | ENCRYPT | Encrypt a string |
| 9 | MD5 | Calculate MD5 checksum |
| 10 | OLD_PASSWORD | Return the value of the pre-4.1 implementation of PASSWORD |
| 11 | PASSWORD | Calculate and return a password string |
| 12 | SHA1 | Calculate an SHA-1 160-bit checksum (Equal to SHA() function) |
| 13 | SHA | Calculate an SHA-1 160-bit checksum |
| 14 | UNCOMPRESS | Uncompress a string compressed |
| 15 | UNCOMPRESSED_LENGTH | Return the length of a string before compression |
| 16 | SHA2 | Calculate an SHA-2 checksum,a family of hasing functions (SHA-223, SHA-256, SHA-384, SHA-512). |
