Mega Code Archive

 

Categories / MySQL Tutorial / Encryption Compression Functions

 

Encryption and Compression Functions

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()Decrypt a string ENCODE()Encode a string ENCRYPT()Encrypt a string MD5()Calculate MD5 checksum OLD_PASSWORD()Return the value of the old (pre-4.1) implementation of PASSWORD PASSWORD()Calculate and return a password string SHA1(), SHA()Calculate an SHA-1 160-bit checksum UNCOMPRESS()Uncompress a string compressed UNCOMPRESSED_LENGTH()Return the length of a string before compression Quote: dev.mysql.com/doc/refman/5.1/en/index.html