AES_ENCRYPT(str,key_str) : AES_ENCRYPT : Encryption Compression Functions MySQL TUTORIALS

MySQL TUTORIALS » Encryption Compression Functions » AES_ENCRYPT »

AES_ENCRYPT(str,key_str)

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") |
+--------------------------------+
| ???/?f?              |
+--------------------------------+
1 row in set (0.00 sec)