TencentDB for TcaplusDB
- Product Introduction
- Purchase Guide
- Getting Started
- Basic Concepts
- Operation Guide
- Managing Cluster and Table Group
- Monitoring and Alarming
- Access Management
- TcaplusDB Client
- TcaplusDB SDK
- SDK Installation
- Directions for Protobuf Table SDK for C++
- Directions for TDR Table SDK for C++
- TcaplusDB RESTful APIs
- API Documentation
- Making API Requests
- Table Group APIs
- Table APIs
- Cluster APIs
- Service Agreement
insert
Last updated: 2024-12-04 10:12:05
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 Datainsert into table (key1, key2, value1, vlaue2) values (1, "abc", 2, "def") [after -1] [shift none/head/tail];## Importing a CSV File to Insert Datainsert 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 Startupinsert into table infile result.xml [after -1] [shift none/head/tail] using tdr;
Parameters
Parameter | Protobuf and TDR | Required |
table | Table name | Yes |
key | Primary key field name | Yes |
value | Non-primary key field name | Yes, at least one |
after | LIST table: n>0 indicates that the data will be inserted after the first n data n=-2 indicates that the data will be inserted at the head of the queue n=-1 indicates that the data will be inserted at the tail of the queue n<-2: unsupported GENERIC table: this field is unsupported. | No |
shift | If the table size exceeds the maximum value, you can specify how to clear data automatically. Valid values: none: no data will be clearedhead: data at the head of the queue will be clearedtail: data at the tail of the queue will be cleared. | No |
using tdr | The Protobuf table does not support this parameter. To insert data into the TDR table, import an XML file whose structure must strictly comply with the XML syntax. In addition, a TDR file must be provided when the client is started. | No |
infile | Read data from the file | No |
Errors
Sample
tcaplus>insert into game_players (player_id,player_name,player_email,game_server_id) values (2,name,email,2);insert successinsert time: 45322 ustcaplus> Insert into table_list (uin, name, key1) values (99,99,99) after -1 shift tail;insert successinsert time: 22464 ustcaplus> Insert into table_list infile result.xml using tdr;insert successinsert time: 9493 ustcaplus> Insert into table_list infile result.csv;insert successinsert time: 22368 us
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No