mysql Encryption and Compression Functions

3016 ワード

Name
Description
AES_DECRYPT()
Decrypt using AES
AES_ENCRYPT()
Encrypt using AES
COMPRESS()
Return result as a binary string
DECODE()
Decodes a string encrypted using ENCODE()
DES_DECRYPT()
Decrypt a string
DES_ENCRYPT()
Encrypt a string
ENCODE()
Encode a string
ENCRYPT()
Encrypt a string
MD5()
Calculate MD5 checksum
OLD_PASSWORD()
Return the value of the  pre-4.1 implementation of PASSWORD
PASSWORD()
Calculate and return a password string
SHA1() , SHA()
Calculate an SHA-1 160-bit checksum
SHA2()
Calculate an SHA-2 checksum
UNCOMPRESS()
Uncompress a string compressed
UNCOMPRESSED_LENGTH()
Return the length of a string before compression