云数据库 GaussDB-MERGE INTO:语法格式

时间：2025-02-12 15:05:44

云数据库 GaussDB

语法格式

MERGE [/*+ plan_hint */] INTO table_name [ partition_clause ] [ [ AS ] alias ]USING { { table_name | view_name } | subquery } [ [ AS ] alias ]ON ( condition )[  WHEN MATCHED THEN  UPDATE SET { column_name = { expression | subquery | DEFAULT } |          ( column_name [, ...] ) = ( { expression | subquery | DEFAULT } [, ...] ) } [, ...]  [ WHERE condition ]][  WHEN NOT MATCHED THEN  INSERT { DEFAULT VALUES |  [ ( column_name [, ...] ) ] VALUES ( { expression | subquery | DEFAULT } [, ...] ) [, ...] [ WHERE condition ] }];

上一篇：云数据库 GaussDB-MERGE INTO:示例

下一篇：云数据库 GaussDB-MERGE INTO:参数说明