本文比较了MYSQL和Oracle数据库中对workflow_nodelink表中linkname字段的更新语句，展示了不同SQL查询策略以合并节点名生成链接名称。
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
)
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
