mysql AES加密查询并导出到文件

最新推荐文章于 2024-08-05 12:18:37 发布

tuna_lxg

最新推荐文章于 2024-08-05 12:18:37 发布

阅读量1k

点赞数

分类专栏： mysql 文章标签： mysql 加密 AES

本文链接：https://blog.csdn.net/tuna_lxg/article/details/24769461

版权

mysql 专栏收录该内容

39 篇文章 0 订阅

订阅专栏

SELECT user_id,AES_DECRYPT(user_phone_num,"WzZaxhDxGyzHxkQYlNUEBA==") as user_phone_num,
user_phone_imei,
resgister_date,
AES_DECRYPT(user_name,"WzZaxhDxGyzHxkQYlNUEBA==") as user_name,
AES_DECRYPT(id_card,"WzZaxhDxGyzHxkQYlNUEBA==") as id_card,
AES_DECRYPT(id_address,"WzZaxhDxGyzHxkQYlNUEBA==") as id_address,
AES_DECRYPT(deposit_bank,"WzZaxhDxGyzHxkQYlNUEBA==") as deposit_bank,
AES_DECRYPT(bank_account,"WzZaxhDxGyzHxkQYlNUEBA==") as bank_account,
effect_status,
AES_DECRYPT(postal_address,"WzZaxhDxGyzHxkQYlNUEBA==") as postal_address,
AES_DECRYPT(contact_way,"WzZaxhDxGyzHxkQYlNUEBA==") as contact_way,hospital_id,
blood_pressure,
blood_sugar,
uric_acid,
BLOOD_OXYGEN,
other_sersor_reserve,
AES_DECRYPT(manager_user_name,"WzZaxhDxGyzHxkQYlNUEBA==") as manager_user_name,

reserve_2,reserve_3 FROM USER_INFO into OUTFILE '/data/user_info.txt;'

插入加密表

INSERT into USER_INFO(
user_name,
id_card,
deposit_bank,
bank_account,
contact_way) values
(
AES_ENCRYPT('',"WzZaxhDxGyzHxkQYlNUEBA=="),
AES_ENCRYPT('',"WzZaxhDxGyzHxkQYlNUEBA=="),
AES_ENCRYPT('',"WzZaxhDxGyzHxkQYlNUEBA=="),
AES_ENCRYPT('',"WzZaxhDxGyzHxkQYlNUEBA=="),
AES_ENCRYPT('',"WzZaxhDxGyzHxkQYlNUEBA=="));