云数据库 GAUSSDB-INSERT:语法格式

时间：2025-06-03 09:37:05

云数据库 GAUSSDB I

语法格式

[ WITH [ RECURSIVE ] with_query [, ...] ]
INSERT [/*+ plan_hint */] [ IGNORE ] INTO table_name [ { [alias_name] [ ( column_name [, ...] ) ] } | { [partition_clause] [ AS alias ] [ ( column_name [, ...] ) ] } ]    { DEFAULT VALUES
    | { VALUES | VALUE } {( { expression | DEFAULT } [, ...] ) }[, ...] 
    | query }
    [ { ON DUPLICATE KEY UPDATE { NOTHING | { column_name = { expression | DEFAULT } } [, ...] [ WHERE condition ] } }
| { [ ON CONFLICT [ conflict_target ] conflict_action ] } ]
    [ RETURNING {* | {output_expression [ [ AS ] output_name ] }[, ...]} ];

上一篇：云数据库 GAUSSDB-INSERT:示例

下一篇：云数据库 GAUSSDB-INSERT:示例