数据仓库服务 GaussDB(DWS)-MERGE INTO:语法格式
时间：2025-02-12 15:01:49
下载数据仓库服务 GaussDB(DWS)用户手册完整版
复制链接到剪贴板
分享文章到微博
分享文章到朋友圈
语法格式
1 2 3 4 5 6 7 8 91011121314 |
MERGE INTO table_name [ [ AS ] alias ]USING { { table_name | view_name } | subquery } [ [ AS ] alias ]ON ( condition )[ WHEN MATCHED THEN UPDATE SET { column_name = { expression | DEFAULT } | ( column_name [, ...] ) = ( { expression | DEFAULT } [, ...] ) } [, ...] [ WHERE condition ]][ WHEN NOT MATCHED THEN INSERT { DEFAULT VALUES | [ ( column_name [, ...] ) ] VALUES ( { expression | DEFAULT } [, ...] ) [, ...] [ WHERE condition ] }]; |
support.huaweicloud.com/HyDevg-dws/dws_15_00010.html
推荐文章
