update

## 显示声明字段的值，更新对应的记录
update table set value1 = 1, value2 = "abc", value3 = 0x123456 where key1 = 1 and key2 = "abc" and [-index = 1];

## 导入 csv 文件替换对应的记录
update table infile 文件名 [where -index = 0];

## 导入 xml 文件替换对应的记录
update table infile 文件名 [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