DML (Data Manipulation Language) Commands
This page provides reference information for the DML (Data Manipulation Language) commands in TiDB Cloud Lake.
Data Modification
| Command | Description |
|---|
| INSERT | Add new rows to a table |
| INSERT MULTI | Insert data into multiple tables in one statement |
| UPDATE | Modify existing rows in a table |
| DELETE | Remove rows from a table |
| REPLACE | Insert new rows or update existing ones |
| MERGE | Perform upsert operations based on conditions |
Data Loading & Export