tencent cloud

All product documents
TencentDB for TcaplusDB
DocumentationTencentDB for TcaplusDBTcaplusDB ClientClient Tool Commandsupdate
update
Download PDF
Last updated: 2024-12-04 10:12:05
update
Last updated: 2024-12-04 10:12:05
Download PDF

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

Parameter
ProtoBuf
TDR
Required
table
Table name
Table name
Yes
key
Primary key field name. All key values are required.
Primary key field name. All key values are required.
Yes
value
Non-primary key field name
Non-primary key field name
At least one or *
-index
LIST table: you must specify \\-index. Only the specified record will be replaced.
GENERIC table: not supported
LIST table: if \\-index is specified, the index-th record with the same key will be returned; if \\-index is not specified, all records will be returned.
GENERIC table: not supported
No
using tdr
Not supported
When data is output in XML format, the file structure must strictly comply with the XML syntax. A TDR file must be provided when client is launched.
No
infile
Read data from the file.
Read data from the file.
No

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

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 available.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon