tencent cloud

Overview

This command is used to insert a data entry into a table by explicitly declaring parameters or importing files.

Syntax

## Explicitly Declaring Parameters to Insert Data
insert into table (key1, key2, value1, vlaue2) values (1, "abc", 2, "def") [after -1] [shift none/head/tail];

## Importing a CSV File to Insert Data
insert into table infile result.csv [after -1] [shift none/head/tail];

## Importing an XML File to Insert Data Provided that the TDR File Is Provided at the Client’s Startup
insert into table infile result.xml [after -1] [shift none/head/tail] using tdr;

Parameters

Errors

For more information, see Error Codes.

Sample

Download the sample file result.xml and result.csv.

tcaplus>insert into game_players (player_id,player_name,player_email,game_server_id) values (2,name,email,2);
insert success

insert time: 45322 us

tcaplus> Insert into table_list (uin, name, key1) values (99,99,99) after -1 shift tail;

insert success

insert time: 22464 us

tcaplus> Insert into table_list infile result.xml  using tdr;


insert success

insert time: 9493 us

tcaplus> Insert into table_list infile result.csv;


insert success

insert time: 22368 us