H2 DML Operations: Difference between revisions
Jump to navigation
Jump to search
(→Insert) |
(→Insert) |
||
| Line 9: | Line 9: | ||
=Insert= | =Insert= | ||
INSERT INTO ''<table-name>'' VALUES(1, | 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 [[H2_DDL_Operations#Create_Table|here]]. | This insert command uses the table definition created as an example [[H2_DDL_Operations#Create_Table|here]]. | ||
=Update= | |||
UPDATE ''<table-name>'' SET ''<column-name>''=' ''<some-value''' WERE | |||
Revision as of 18:02, 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