What are the mysql encryption functions?

Mysql encryption functions are: 1. [DECODE(str,key)] uses key as the key to decrypt the encrypted string str; 2. [AES_DECRYPT(str,key)] returns the key pair string str is the result of decryption using the Advanced Encryption Standard algorithm.

mysql encryption functions are:

1, AES_ENCRYPT(str,key): Returns the result of encrypting the string str using the Advanced Encryption Standard algorithm using the key key. The result of calling AES_ENCRYPT is a binary string stored in the BLOB type.

2, AES_DECRYPT(str,key): Returns the result of decrypting the string str using the Advanced Encryption Standard algorithm using the key key.

3, DECODE(str,key): Use key as the key to decrypt the encrypted string str.

4, ENCRYPT(str,salt): Use the UNIXcrypt() function to encrypt the string str using the keyword salt (a string that can uniquely determine the password, just like a key) .

5, ENCODE(str,key): Use key as the key to encrypt the string str. The result of calling ENCODE() is a binary string, which is stored in the BLOB type.

6, MD5(): Calculate the MD5 checksum of the string str.

7, PASSWORD(str): Returns the encrypted version of the string str. This encryption process is irreversible and uses a different algorithm from the UNIX password encryption process.

8, SHA(): Calculate the Secure Hash Algorithm (SHA) checksum of the string str.

Example:

SELECT ENCRYPT('root','salt');
SELECT ENCODE('xufeng','key');
SELECT DECODE(ENCODE('xufeng','key'),'key');#加解密放在一起
SELECT AES_ENCRYPT('root','key');
SELECT AES_DECRYPT(AES_ENCRYPT('root','key'),'key');
SELECT MD5('123456');
SELECT SHA('123456');

Related learning recommendations: mysql video tutorial

The above is the detailed content of What are the mysql encryption functions?. For more information, please follow other related articles on the PHP Chinese website!