HEX()函数;二进制转换为16进制,方便存储
加密:加密对象 11 加密密钥:e10adc3949ba59abbe56e057f20f883e 结果:A13015D303BC1548608D6B4B8E900515
SELECT HEX(AES_ENCRYPT(’11’,’e10adc3949ba59abbe56e057f20f883e’));
解密:解密对象:A13015D303BC1548608D6B4B8E900515 解密密钥:e10adc3949ba59abbe56e057f20f883e 结果:11
SELECT AES_DECRYPT(UNHEX(‘A13015D303BC1548608D6B4B8E900515′),’e10adc3949ba59abbe56e057f20f883e’);