java oracle 批量merge,oracle和mysql批量Merge对比

orm框架采用mybatis，本博客介绍一下批量合并merge用oracle和mysql来做的区别，

oracle merge合并更新函数的详细介绍可以参考我以前的博客：https://blog.csdn.net/u014427391/article/details/87898729

oracle方法：

MERGE INTO t_tips_config_related A1 USING(select #{itm.seq} seq , #{itm.tipsSeq} tipsSeq , #{itm.relaSeq} relaSeq, #{itm.tipsContent} tipsContent from dual ) A2

ON(A1.tips_seq = A2.tipsSeq and A1.rela_seq = A2.relaSeq)

WHEN MATCHED THEN

UPDATE SET A1.tips_content = A2.tipsContent

WHEN NOT MATCHED THEN

INSERT(seq , tips_seq , rela_seq, tips_content)

VALUES(A2.seq , A2.tipsSeq ,A2.relaSeq, A2.tipsContent)

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

mysql方法：

REPLACE INTO t_tips_config_related(seq,tips_seq,rela_seq,tips_content) VALUES(#{itm.seq}, #{itm.tipsSeq}, #{itm.relaSeq}, #{itm.tipsContent})

1

2

3

4

5

6

7

8

9

文章来源: smilenicky.blog.csdn.net，作者：smileNicky，版权归原作者所有，如需转载，请联系作者。

原文链接：smilenicky.blog.csdn.net/article/details/89330496