Data Manipulation Language (DML)
This section walks you through all data manipulation language (DML) commands supported by GridGain 9.
DELETE
Deletes data from a table.
Diagram( Terminal('DELETE FROM'), NonTerminal('qualified_table_name', {href:'./grammar-reference/#qualified_table_name'}), Optional( Sequence( Optional('AS'), NonTerminal('alias'), ) ), Optional( Sequence( NonTerminal('WHERE'), Terminal('booleanExpression') ) ) )
Parameters
-
alias
- an SQL alias for an expression or value. -
booleanExpression
- an SQL expression that returns a boolean value. Only the records for whichTRUE
was returned will be deleted. If not specified, all records are deleted.
INSERT
Inserts data into a table.
Diagram( Terminal('INSERT INTO'), NonTerminal('qualified_table_name', {href:'./grammar-reference/#qualified_table_name'}), Optional( NonTerminal('column_list', {href:'./grammar-reference/#column_list'}), ), NonTerminal('query', {href:'./grammar-reference/#query'}) )
MERGE
Merges data into a table.
Diagram( Terminal('MERGE INTO'), NonTerminal('qualified_table_name', {href:'./grammar-reference/#qualified_table_name'}), Optional( Sequence( Optional('AS'), NonTerminal('alias'), ) ), Terminal('USING'), NonTerminal('qualified_table_name', {href:'./grammar-reference/#qualified_table_name'}), Terminal('ON'), NonTerminal('booleanExpression'), End({type:'complex'}) )
Diagram( Start({type:'complex'}), Optional( Sequence( NonTerminal('WHEN MATCHED THEN UPDATE SET'), OneOrMore(Sequence(Terminal('assign', {href:'./grammar-reference/#assign'}) ), Terminal(',') ))), Optional( Sequence( NonTerminal('WHEN NOT MATCHED THEN INSERT VALUES'), NonTerminal('('), OneOrMore(Sequence(Terminal('value') ), Terminal(',') ), NonTerminal(')'), )))
Parameters
-
alias
- an SQL alias for an expression or value. -
booleanExpression
- an SQL expression that returns a boolean value. IfTRUE
is returned, theWHEN MATCHED
clause is executed, otherwise theWHEN NOT MATCHED
is executed. -
value
- arbitrary value that will be inserted into the table during the operation.
UPDATE
Updates data in a table.
Diagram( Terminal('UPDATE'), NonTerminal('qualified_table_name', {href:'./grammar-reference/#qualified_table_name'}), Terminal('SET'), OneOrMore(Sequence(Terminal('assign', {href:'./grammar-reference/#assign'}) ), Terminal(',') ), Optional( Sequence( Terminal('WHERE'), NonTerminal('booleanExpression') ) ) )
Parameters
-
booleanExpression
- an SQL expression that returns a boolean value. Only the records for whichTRUE
was returned will be updated. If not specified, all records will be updated.
© 2025 GridGain Systems, Inc. All Rights Reserved. Privacy Policy | Legal Notices. GridGain® is a registered trademark of GridGain Systems, Inc.
Apache, Apache Ignite, the Apache feather and the Apache Ignite logo are either registered trademarks or trademarks of The Apache Software Foundation.