MySQL中AES 增删改sql加解密用法

新增：
INSERT INTO cts_admin (username, PASSWORD) VALUES (‘aaa’, HEX(AES_ENCRYPT((‘aaaa’), ‘秘钥’)));

修改：
UPDATE cts_admin aa SET aa.email = HEX(AES_ENCRYPT((aa.email), ‘秘钥’)),aa.nick_name = HEX(AES_ENCRYPT((aa.nick_name), ‘秘钥’));

查询：
SELECT AES_DECRYPT(UNHEX(aa.password), “zyhlcts39b2dd0a68903c57b635942ca”) FROM cts_admin aa;