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 whichTRUEwas 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.
Parameters
alias- an SQL alias for an expression or value.booleanExpression- an SQL expression that returns a boolean value. IfTRUEis returned, theWHEN MATCHEDclause is executed, otherwise theWHEN NOT MATCHEDis 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 whichTRUEwas 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?

