TencentDB for TcaplusDB load-TcaplusDB Client-Help & Documentation-Tencent Cloud

Introduction
Import data, supports two formats: csv and xml. If the record exists, update it; if the record does not exist, add a new record.
Syntax
##Import in xml format
load table infile filename using tdr;
﻿
##Import in csv format
load table infile filename;
Parameters
Parameters
Protobuf
TDR
Required
table
Table name
Table name
Yes
using tdr
Not supported.
Export data in XML format. The file structure must strictly adhere to XML syntax. This operation requires providing a TDR file when starting the client
No
infile
Reading data from file
Reading data from file
Yes
Errors
Please refer to the error code list.
Example
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
﻿

Parameters	Protobuf	TDR	Required
table	Table name	Table name	Yes
using tdr	Not supported.	Export data in XML format. The file structure must strictly adhere to XML syntax. This operation requires providing a TDR file when starting the client	No
infile	Reading data from file	Reading data from file	Yes

load

On this page:

Introduction

Syntax

Parameters

Errors

Example