1

I created a table and wrote some data. Now I want to change the value of ta column using Update statement.

create table test(fa bigint, tags(ta));
insert into table test(ta, fa) values ('ta', 1);
select * from test;
+-------------------------------+----+----+
| time                          | ta | fa |
+-------------------------------+----+----+
| 1970-01-01T00:00:00.000000001 | ta | 1  |
+-------------------------------+----+----+

I try:

update test set ta = 'test_ta'
where time = timestamp '1970-01-01T00:00:00.000000001' and ta = 'ta';

But it didn't succeed

I didn't find CnosDB's description about the Update statement.

I want to know a way to change data.

ZuoTiJia
  • 161
  • 5

0 Answers0