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 which TRUE 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. 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.

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 which TRUE 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.

Last updated on Apr 15, 2025