update test set id_no=replace(id_no,substring(id_no,9,14), concat(‘000000’,substring(id_no,15,18)) );
Mysql加密身份证号
最新推荐文章于 2023-11-13 10:41:29 发布
update test set id_no=replace(id_no,substring(id_no,9,14), concat(‘000000’,substring(id_no,15,18)) );