这个语句,可以实现需要游标才能完成的功能
一次更新很多行,每行的更新值不同
update workT set catalog_id_=ss from workT t1 inner join (select b.guid as tempid,a.id_ as ss from work_typeT
a left join workT b on a.guid=b.work_type_guid) t2
on t1.guid = t2.tempid;
这个语句,可以实现需要游标才能完成的功能
一次更新很多行,每行的更新值不同
update workT set catalog_id_=ss from workT t1 inner join (select b.guid as tempid,a.id_ as ss from work_typeT
a left join workT b on a.guid=b.work_type_guid) t2
on t1.guid = t2.tempid;