For the complete documentation index, see llms.txt. Markdown versions of documentation pages are available by appending .md to page URLs.
Skip to content

Data Manipulation Language (DML)

Data manipulation language (DML) commands supported by GridGain 9: DELETE, INSERT, MERGE, and UPDATE, with their syntax and parameters.

This section walks you through all data manipulation language (DML) commands supported by GridGain 9.

DELETE

Deletes data from a table.

DELETE FROM qualified_table_name
  [ [ AS ] alias ]
  [ WHERE booleanExpression ]
  [ LIMIT count ]

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.

  • count - the maximum number of rows to delete. Accepts an integer literal or a query parameter.

DELETE FROM Person WHERE city = 'New York' LIMIT 3;

INSERT

Inserts data into a table.

MERGE

Merges data into a table.

At least 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.

This page is: Copyright © 2026 MariaDB. All rights reserved.

Last updated

Was this helpful?