Edit

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.

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(')'), )))

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.

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 The Apache Software Foundation.
Apache, Apache Ignite, the Apache feather and the Apache Ignite logo are either registered trademarks or trademarks of The Apache Software Foundation.