AES_DECRYPT

声明

AES_DECRYPT(crypt_str,key_str[,init_vector])

说明

根据密钥 key_str 返回密文 crypt_str 进行 AES 解密的明文。

有关 init_vector 参数的详细信息，请参见 AES_ENCRYPT。

示例

SELECT AES_DECRYPT(AES_ENCRYPT('oceanbase',UNHEX('F3229A0B371ED2D9441B830D21A390C3')),UNHEX('F3229A0B371ED2D9441B830D21A390C3'));
+---------------------------------------------------------------------------------------------------------------------------+
| AES_DECRYPT(AES_ENCRYPT('oceanbase',UNHEX('F3229A0B371ED2D9441B830D21A390C3')),UNHEX('F3229A0B371ED2D9441B830D21A390C3')) |
+---------------------------------------------------------------------------------------------------------------------------+
| oceanbase                                                                                                                 |
+---------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec