Skip to main content
Version: 3.1.0 (Latest)

Data Manipulation Language (DML)

This section walks you through all data manipulation language (DML) commands supported by Apache Ignite 3.

DELETE​

Deletes data from a table.

Parameters​

  • alias - an SQL alias for an expression or value.
  • booleanExpression - an SQL expression that returns a boolean value. Only the records for which TRUE was returned will be deleted. If not specified, all records are deleted.

INSERT​

Inserts data into a table.

MERGE​

Merges data into a table.

note

At least one of the WHEN MATCHED and WHEN NOT MATCHED clauses must be present.

Parameters​

  • alias - an SQL alias for an expression or value.
  • booleanExpression - an SQL expression that returns a boolean value. If TRUE is returned, the WHEN MATCHED clause is executed, otherwise the WHEN NOT MATCHED is executed.
  • value - arbitrary value that will be inserted into the table during the operation.

UPDATE​

Updates data in a table.

Parameters​

  • booleanExpression - an SQL expression that returns a boolean value. Only the records for which TRUE was returned will be updated. If not specified, all records will be updated.