GridGain Developers Hub

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.