MYSQL调整语法:
update workflow_nodelink set linkname=(
select linkname from (
select id,concat((select nodename from workflow_nodebase where id=nodeid),'->',(select nodename from workflow_nodebase where id=destnodeid)) as linkname
from workflow_nodelink )B where B.id =workflow_nodelink.id)
Oracle调整语法:
update workflow_nodelink set linkname=(
select linkname from (
select id,(select nodename from workflow_nodebase where id=nodeid) || ' —> '||(select nodename from workflow_nodebase where id=destnodeid) as linkname
from workflow_nodelink )B where B.id =workflow_nodelink.id)
SQL语法:
update workflow_nodelink set linkname=(
select linkname from (
select id,
(select nodename from workflow_nodebase where id=nodeid)+' —> '+
(select nodename from workflow_nodebase where id=destnodeid) as linkname
from workflow_nodelink where isreject !='1'
union all
select
id,
(select nodename from workflow_nodebase where id=nodeid)+' —> '+
(select nodename from workflow_nodebase where id=destnodeid) as linkname
from workflow_nodelink where isreject ='1'
)B where B.id =workflow_nodelink.id
)