select lastname,id,status from hrmresource
where lastname in ('张x','张x')
select * from docprivateseccategory
where userid = xx
select * from imagefileref
where CREATERID = xx;
update docprivateseccategory
set userid = 2469 , PARENTID = (select id from docprivateseccategory where PARENTID = 0 and userid = 2469) --现
where userid = 2095 --原
and PARENTID = 0;
update imagefileref
set CREATERID = 2469
where CREATERID = 2095;
以上两条数据依次执行
E9-OA云盘数据迁移操作
最新推荐文章于 2024-08-09 19:33:38 发布