数据库敏感信息加密

-- MYSQL
-- 加密
select CAST(HEX(AES_ENCRYPT('604115781', 'Spgtest_1')) AS CHAR) encryptStr;
-- 解密
SELECT CAST(AES_DECRYPT(UNHEX('D281445E31FBDD7C261F7B09F7E1D3A7'), 'Spgtest_1') AS CHAR) decryptStr;

  

posted @ 2025-02-12 16:43  蓝色土耳其  阅读(8)  评论(0)    收藏  举报