update user set idno=replace(idno,substring(idno,7,14), concat('19880514',substring(idno,15,18)) );
MySQL 替换身份证号中的年月日
最新推荐文章于 2023-02-16 10:25:52 发布
update user set idno=replace(idno,substring(idno,7,14), concat('19880514',substring(idno,15,18)) );