Decrytpion in mysql

by Mohan 2012-09-18 14:12:36



AES_DECRYPT() decrypts the encrypted string and returns the original string.

Encoding with a 128-bit key length is used.



mysql>
mysql> select AES_DECRYPT(AES_ENCRYPT("text","password"),"password") ;
+--------------------------------------------------------+
| AES_DECRYPT(AES_ENCRYPT("text","password"),"password") |
+--------------------------------------------------------+
| text |
+--------------------------------------------------------+
1 row in set (0.00 sec)

mysql>

Tagged in:

758
like
0
dislike
0
mail
flag

You must LOGIN to add comments