H2 DML Operations

Internal

• H2

Query

SELECT * FROM <table-name> ORDER BY <column-name>;

Insert

INSERT INTO <table-name> VALUES(<val-for-column-1>, <val-for-column-2>);

INSERT INTO TEST VALUES(1, 'Hello');

This insert command uses the table definition created as an example here.

Update

UPDATE <table-name> SET <column-name>= '<some-value>' WERE