// 加密存储
INSERT INTO log(title) VALUES(HEX(AES_ENCRYPT('这是要加密的内容','aeskey')));
// 解密读取
SELECT AES_DECRYPT(UNHEX(title),'aeskey') as title FROM log;
mysql AES加密存储,解密读取
最新推荐文章于 2024-09-05 17:07:59 发布
// 加密存储
INSERT INTO log(title) VALUES(HEX(AES_ENCRYPT('这是要加密的内容','aeskey')));
// 解密读取
SELECT AES_DECRYPT(UNHEX(title),'aeskey') as title FROM log;