加密,将结果用16进制显示
原数据(“123456”),加密密钥(“password”)
select hex(aes_encrypt('123456','password'));
解密
select aes_decrypt(unhex("21EEC1D1D074555D1190649EB2B803E5"),"password");
加密,将结果用16进制显示
原数据(“123456”),加密密钥(“password”)
select hex(aes_encrypt('123456','password'));
解密
select aes_decrypt(unhex("21EEC1D1D074555D1190649EB2B803E5"),"password");