INSERT

功能描述

向表中添加一行或多行数据。

注意事项

  • 本章节只包含shark新增的语法,原openGauss的语法未做删除和修改。

语法格式

[ WITH [ RECURSIVE ] with_query [, ...] ]
INSERT [/*+ plan_hint */] [INTO] table_name [partition_clause] [ 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 ] }[, ...]} ];

相关链接

INSERT

意见反馈
编组 3备份
    openGauss 2025-06-08 07:42:13
    取消