tencent cloud

Overview

This command is used to update a record in a table by explicitly declaring parameters or importing files.

Syntax

## 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;

Parameters

Errors

Please refer to Error Codes.

Sample

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