Tencent Cloud

Recent Pages

load

Last updated: 2024-12-04 10:12:05

Overview
This command is used to import data in CSV or XML format to update or add records.
Syntax
## Importing an XML File
load table infile filename using tdr;
﻿
## Importing a CSV File
load table infile filename;
Parameters
Parameter
Protobuf
TDR
Required
table
Table name
Table name
Yes
using tdr
Not supported
When data in XML format is imported, the file structure must strictly comply with the XML syntax. A TDR file must be provided when the client is started.
No
infile
Read data from the file.
Read data from the file.
Yes
Errors
For more information, see Error Codes.
Sample
tcaplus> load table_list infile table_list_dump.xml using tdr;
loaded 49 records successful
﻿
tcaplus> load table_list infile table_list-dump.txt;
loaded 98 records successful

Contact Us

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

Technical Support

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

7x24 Phone Support

tencent cloud

Recent Pages

load

Overview

Syntax

Parameters

Errors

Sample

Was this page helpful?

Was this page helpful?

Parameter	Protobuf	TDR	Required
table	Table name	Table name	Yes
using tdr	Not supported	When data in XML format is imported, the file structure must strictly comply with the XML syntax. A TDR file must be provided when the client is started.	No
infile	Read data from the file.	Read data from the file.	Yes

tencent cloud

Sign Up

Log in

Recent Pages

load

Overview

Syntax

Parameters

Errors

Sample

Was this page helpful?

Was this page helpful?