GBase 8a
其他
文章

加密解密函数

发表于2025-01-07 11:16:3544次浏览1个评论

加密解密:
--------------
select AES_ENCRYPT(a,3),b from test3151
--------------

+------------------+-------+
| AES_ENCRYPT(a,3) | b     |
+------------------+-------+
| G呣鋬昆邟 飥            | world |
+------------------+-------+
1 row in set (Elapsed: 00:00:00.01)

--------------
select AES_DECRYPT(AES_ENCRYPT(a,3),3),b from test3151
--------------

+---------------------------------+-------+
| AES_DECRYPT(AES_ENCRYPT(a,3),3) | b     |
+---------------------------------+-------+
| hello                           | world |
+---------------------------------+-------+
1 row in set (Elapsed: 00:00:00.00)

评论

登录后才可以发表评论
菲菲发表于 2个月前
学习了