加密字段为blob类型
alter table table_name change column column_name blob;
加密
select ENCODE("test","key")
解密
select DECODE(column_name,"key")
alter table table_name change column column_name blob;
select ENCODE("test","key")
select DECODE(column_name,"key")
本文标题：mysql加密解密
本文链接：https://www.haomeiwen.com/subject/wcfwyxtx.html
网友评论