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

时间：2023-11-01 16:22:13

云数据库 GaussDB

语法格式

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