| 19. 3. 1. AES_ENCRYPT(str,key_str): encryption and decryption of data using the official AES (Advanced Encryption Standard) algorithm. |
|
|
Encoding with a 128-bit key length is used. |
AES_ENCRYPT() encrypts a string and returns a binary string. |
You can use the AES functions to store data in an encrypted form by modifying your queries: |
|
INSERT INTO t VALUES (1,AES_ENCRYPT('text','password'));
|
|
|
mysql>
mysql>
mysql> select AES_ENCRYPT("text","password") ;
+--------------------------------+
| AES_ENCRYPT("text","password") |
+--------------------------------+
| ö½¨Ü·øÍJ/ª¼Tf€D |
+--------------------------------+
1 row in set (0.00 sec)
|
|