MySQL Tutorial Encryption Compression Functions 22 codes

  1. Home
  2. MySQL Tutorial
  3. Encryption Compression Functions
1 AES_DECRYPT(crypt_str,key_str)
2 AES_ENCRYPT(str,key_str)
3 COMPRESS(string_to_compress) compresses a string and returns the result as a binary string
4 DECODE(crypt_str,pass_str) decrypts the encrypted string crypt_str using pass_str
5 DES_DECRYPT(crypt_str[,key_str]) (Decrypts a string encrypted with DES_ENCRYPT() )
6 ENCODE(str,pass_str) (Encrypt str using pass_str as the password )
7 ENCRYPT(str[,salt]) encrypts str using the Unix crypt() system call
8 Encryption and Compression Functions
9 MD5(str) calculates an MD5 128-bit checksum for the string
10 OLD_PASSWORD(str)
11 SELECT LENGTH(COMPRESS())
12 SELECT LENGTH(COMPRESS(a))
13 SELECT LENGTH(COMPRESS(REPEAT(a,16)))
14 SHA1(str), SHA(str) calculates an SHA-1 160-bit checksum for the string
15 UNCOMPRESS(string_to_uncompress) uncompresses a string compressed by the COMPRESS() function
16 Use CRC32 with column data
17 Use ENCRYPT function to ENCRYPT first name
18 Use password function to ENCRYPT first name
19 Using AES_ENCRYPT to ENCRYPT the first name
20 Using MD5 function to ENCRYPT first name
21 Using old_password to ENCRYPT the first name
22 Using the SHA function with first name