shall I update a value to null in TDengine database？

Question

as below： I want to insert a row with null to achieve above .but seems not work.

create table t1 (ts timestamp,num1 int,num2 int);

insert into t1 (ts,num1,num2) values (“xxxx”,1,2) ;

insert into t1 values (“xxxxx”,1,2,NULL) ;

no matter I use update 1 or 2

Answer 1

sorry. TDengine database 2.0 doesn't support this but 3.0 is okay and no need any configuration.

it would be "upsert" automatically .