环境:
mysql 数据库
加密
UPDATE table SET ian = TO_BASE64(AES_ENCRYPT(ian,'uniquezhangqi.top'));
解密
UPDATE table AS a INNER JOIN (SELECT AES_DECRYPT(FROM_BASE64(ian),'uniquezhangqi.top') AS ian, id FROM table) b SET a.ian = b.ian WHERE a.id = b.id;
文档还在整理中…