
MYSQL AES解密
SET block_encryption_mode = 'aes-256-ecb'; SELECT u.`id` AS `id`, u.`username` AS `username`, u.`unionid` AS `unionid`, u.`openid` AS `openid`, CONVERT(AES_DECRYPT(FROM_BASE64(u.`country_code`), '32位秘钥') USING utf8mb4) AS `country_code`, CONVERT(AES_DECRYPT(u.`tel`, '32位秘钥') USING utf8mb4) AS `tel`, CONVERT(AES_DECRYPT(u.`district`, '32位秘钥') USING utf8mb4) AS `district`, CONVERT(AES_DECRYPT(u.`address`, '32位秘钥') USING utf8mb4) AS `address` FROM `user` u;
============ 欢迎各位老板打赏~ ===========


与本文相关的文章
- · docker定时任务Mysql脚本
- · docker安装mysql8注意事项
- · .NET8 Mysql SSL error
- · 定时备份docker中的mysql
- · docker-compose通过容器名连接mysql
- · unity3d mysql error: The given key was not present in the dictionary.
- · MySQL 批量修改数据表编码及字符集
- · Your database must use ‘READ-COMMITTED’ as the default isolation level.
- · MySQL-InnoDB存储引擎
- · 将数据从mysql迁移到clickhouse
- · mysql关于索引那些事儿
- · mysql大数据表加字段改名