达梦数据库根据唯一索引批量新增或更新数据

最新推荐文章于 2025-02-27 16:50:01 发布

齐穗穗

最新推荐文章于 2025-02-27 16:50:01 发布

阅读量1.3k

点赞数 10

分类专栏： Java 文章标签：数据库 java

本文链接：https://blog.csdn.net/weixin_49990593/article/details/136293323

版权

代码示例

merge into 表名 as dst 
using
(
        select
                value1 as column1,
                value2 as column2,
                value3 as column3,
                ...
        from
                dual
        
        union all
        
        select
                value1 as column1,
                value2 as column2,
                value3 as column3,
                ...
        from
                dual
) as src 
on
--	此处为唯一索引字段,可为单个或多个
	(dst.unique_index_column1 = src.unique_index_column1 and dst.unique_index_column2 = src.unique_index_column2 ...)
when matched then
--		更新时不能更新唯一索引字段
        update
        set
                column1 = src.column1,
                column2 = src.column2,
                ... 
when not matched then
        insert
                (
                        unique_index_column,
                        column1            ,
                        column2            ,
                        ...
                )
		values
                (
                        src.uniqueValue,
                        src.column1    ,
                        src.column2    ,
                        ...
                )