达梦数据库update关联更新改造

最新推荐文章于 2024-12-24 09:25:53 发布

麻花2013

最新推荐文章于 2024-12-24 09:25:53 发布

阅读量5.4k

点赞数 2

分类专栏：数据库

本文链接：https://blog.youkuaiyun.com/u012269637/article/details/116644189

版权

数据库专栏收录该内容

33 篇文章

订阅专栏

mysql中写法
UPDATE portal_dept_user a INNER JOIN security_org_user b
on a.id=b.id AND a.data_state='1' AND b.data_state='1'
   SET a.data_version=a.data_version + 100
WHERE b.dept_id=#{deptId, jdbcType=DECIMAL}
  AND b.user_id=#{userId, jdbcType=DECIMAL}

 
达梦改造
UPDATE portal_dept_user a SET a.data_version=a.data_version + 100 where   a.id in (
select a.id from  portal_dept_user a
INNER JOIN security_org_user b
on a.id=b.id AND a.data_state='1' AND b.data_state='1'
WHERE b.dept_id=#{deptId, jdbcType=DECIMAL}
  AND b.user_id=#{userId, jdbcType=DECIMAL}
  )