MySQL AES_DECRYPT返回NULL [英] MySQL AES_DECRYPT returns NULL

问题描述

我有一个MySQL问题。

I have a MySQL issue.

我想用AES_DECRYPT解密blob并在phpMyAdmin中使用查询进行尝试

I want to decrypt a blob with AES_DECRYPT and try it in phpMyAdmin with a query

SELECT key_value ,AES_DECRYPT(key_value,'crypt_key')FROM `ps_keymanager` WHERE `id_keymanager`=1497

该查询有效，但返回了NULL
而不是解密值：（

the query works, but it returned me NULL and not the decrypted value :(

推荐答案

尝试投射

   SELECT key_value , CAST (AES_DECRYPT(key_value,'crypt_key')AS CHAR(50))
FROM `ps_keymanager` WHERE `id_keymanager`=1497

这篇关于MySQL AES_DECRYPT返回NULL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！