今天一个现场新建了两个部分,学生和老师,既有父级又有子级部门,一个字段包含改部门的id(如0-21-49,0-22-142),现如今要把这个id去除(就是0-21-49,0-22-142-改为0-49,0-142),以下是修改的sql
select replace(deptcode,'-21-','-') from sys_department where deptcode like '%-21-%';--查询总共有多少需要替换
select replace(deptcode,'-22-','-') from sys_department where deptcode like '%-22-%';
update sys_department set deptcode=replace(deptcode,'-21-','-') where deptcode like '%-21-%';--替换这个字段的内容
update sys_department set deptcode=replace(deptcode,'-22-','-') where deptcode like '%-22-%';