H2 DML Operations: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 17: Line 17:
=Update=
=Update=


  UPDATE ''<table-name>'' SET ''<column-name>''=&#039;''<some-value>''' WERE
  UPDATE ''<table-name>'' SET ''<column-name>''=&#039;''<some-value>''' WERE ''<condition>''

Revision as of 18:06, 25 September 2017

Internal

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 <condition>