设置ASE加密模式:
SET block_encryption_mode = 'AES-128-CBC';
设置加密偏移量(16位)
SET @iv = '1234567890123412';
设置密码
SET @key = 'ccccccc';
使用AES_ENCRYPT加密
SELECT to_base64(AES_ENCRYPT('22222',@key,@iv)) as ENCRYPT;
使用AES_DECRYPT解密
SELECT AES_DECRYPT(FROM_base64('uroLJan2lqQ53UmzGj2sTA=='),@key,@iv) as DECRYPT;
block_encryption_mode
,@key
,@iv
,需要改成自己设置的值