DML (Data Manipulation Language) Commands

This page provides reference information for the DML (Data Manipulation Language) commands in Databend.

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

Command	Description
COPY INTO Table	Load data from files into tables
COPY INTO Location	Export table data to files