Lindorm SQL DML commands-Lindorm(Lindorm)-阿里云帮助中心

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

The following table describes the DML commands that Lindorm supports, along with the 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 simple queries, aggregations, conditional queries, and paging, as well as clauses such as `GROUP BY` and `ORDER BY` and keywords such as `HINT` and `LIMIT`.	READ	GLOBAL DATABASE TABLE
UPSERT	`UPSERT` combines `INSERT` and `UPDATE` to write data to a table. If a row with the same primary key exists, an `UPDATE` is performed. Otherwise, an `INSERT` is performed.	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 by primary or non-primary key. Supports expressions to increment column values.	WRITE	GLOBAL DATABASE TABLE