tencent cloud

## Explicitly Declaring Fields to Update Records
update table set value1 = 1, value2 = "abc", value3 = 0x123456 where key1 = 1 and key2 = "abc" and [-index = 1];

## Importing CSV Files to Replace Records
update table infile file name [where -index = 0];

## Importing XML Files to Replace Records
update table infile file name [where -index = 0] using tdr;

tcaplus> update table_list set level=99 and count= 88 where uin=99 and name = "99" and key1=99 and -index=0;

update success

update time: 117086 us