H2 DML Operations: Difference between revisions
Jump to navigation
Jump to search
(Created page with "=Internal= * H2") |
(→Query) |
||
| (10 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
* [[H2#H2_DML_Operations|H2]] | * [[H2#H2_DML_Operations|H2]] | ||
=Query= | |||
SELECT * FROM ''<table-name>'' ORDER BY ''<column-name>''; | |||
SELECT ''<column-name>'', ... 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 [[H2_DDL_Operations#Create_Table|here]]. | |||
=Update= | |||
UPDATE ''<table-name>'' SET ''<column-name>''='''<some-value>''' WERE ''<condition>'' | |||
=Delete= | |||
DELETE FROM ''<table-name>'' WERE ''<condition>'' | |||
Latest revision as of 19:18, 25 September 2017
Internal
Query
SELECT * FROM <table-name> ORDER BY <column-name>; SELECT <column-name>, ... 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>
Delete
DELETE FROM <table-name> WERE <condition>