-- UPSERT关键字必须要有主键字段,会根据主键字段进行判断,如果字段存在就自动更新不存在则新增
UPSERT WIPUSER.Z_DEVICE_TEST2 VALUES (1, 2,4,18) WITH PRIMARY KEY;
或者
UPSERT WIPUSER.Z_DEVICE_TEST2(T1,T2,T3,T4) VALUES (2,5,21,12) WITH PRIMARY KEY;
-- 测试数据
CREATE COLUMN TABLE WIPUSER.Z_DEVICE_TEST2(
T1 NVARCHAR(32) PRIMARY KEY NOT NULL,
T2 NVARCHAR(32) COMMENT 'Test1',
T3 NVARCHAR(32) COMMENT 'Test2',
T4 NVARCHAR(32) COMMENT 'Test3'
);
SELECT * FROM Z_DEVICE_TEST2;
REPLACE | UPSERT
语法:
UPSERT [ <schema_name>. ]<table_name> [ <column_list_clause> ] { <value_list_clause> [ WHERE <condition> | WITH PRIMARY KEY ] | <subquery> }
REPLACE [ <schema_name>. ]<table_name> [ <column_list_clause> ] { <value_list_clause> [ WHERE <condition> | WITH PRIMARY KEY ] | <subquery> }
语法元素:
<column_list_claus