泛微OA批量修改节点名称SQL

1、备份workflow_nodebase表；
2、执行语句

update workflow_nodebase
set nodename = 'AAAA中心负责人'
where nodename = 'BBBB中心负责人'
 and id in (select fn.nodeid
            from workflow_flownode fn,
                 workflow_base wb
            where fn.workflowid = wb.id
              and wb.isvalid = '1')