tencent cloud

## 显示声明参数的值插入一条数据
insert into table (key1, key2, value1, vlaue2) values (1, "abc", 2, "def") [after -1] [shift none/head/tail];

## 从 csv 格式文件中读取并插入一条数据
insert into table infile result.csv [after -1] [shift none/head/tail];

## 从 xml 格式文件中读取并插入一条数据，该操作必须在启动 client 时提供 tdr 文件
insert into table infile result.xml [after -1] [shift none/head/tail] using tdr;

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