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

时间:2024-06-03 11:34:16

语法格式

  • 值替换插入。
    REPLACE [ INTO ] table_name
        [ PARTITION ( partition_name [, ... ] ) ]
        [ ( col_name [, ... ] ) ]
        { VALUES | VALUE } ( value [, ... ] ) [, ... ];
  • 查询替换插入。
    REPLACE [ INTO ] table_name
        [ PARTITION ( partition_name [, ... ] ) ]
        [ ( col_name [, ... ] ) ]
        query;
  • 设置指定字段值。
    REPLACE [INTO] table_name
        [ PARTITION ( partition_name [, ... ] ) ]
        SET col_name = value [, ... ];
support.huaweicloud.com/distributed-devg-v8-gaussdb/gaussdb-12-0666.html