DML commands in Lindorm SQL - Lindorm - Alibaba Cloud Documentation Center

The Data Manipulation Language (DML) commands in Lindorm SQL are used to query, insert, update, and delete data in a Lindorm database.

The following table lists the DML commands supported by Lindorm, and their required permissions and supported granularities:

Important

The ALL or ALL PRIVILEGE permission includes the READ, WRITE, ADMIN, and TRASH permissions. Therefore, granting the ALL permission also grants these four permissions.

The following table lists only non-ALL permissions.

Command	Description	Required permission	Supported granularity
SELECT	Queries data from a table. Supports various query methods, such as simple queries, aggregations, conditional queries, and paging. Also supports query clauses such as `GROUP BY` and `ORDER BY`, and keywords such as `HINT` and `LIMIT`.	READ	GLOBAL DATABASE TABLE
UPSERT	`UPSERT` is a syntax that combines `INSERT` and `UPDATE` to insert data into a table. If a row exists, an `UPDATE` is executed. If the row does not exist, an `INSERT` is executed.	WRITE	GLOBAL DATABASE TABLE
DELETE	Deletes data by row from a wide table or deletes timelines that meet specified conditions from a time series table.	WRITE	GLOBAL DATABASE TABLE
UPDATE	Updates data in LindormTable. Data can be updated based on primary or non-primary keys. Supports using an expression in the statement to increase a column value.	WRITE	GLOBAL DATABASE TABLE