Revision as of 17:58, 25 September 2017

Internal

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

INSERT INTO <table-name> VALUES(1, "Hello");

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

@@ Line 2: / Line 2: @@
 * [[H2#H2_DML_Operations|H2]]
+=Query=
+ SELECT * FROM ''<table-name>'' ORDER BY ''<column-name>'';
+=Insert=
+ INSERT INTO ''<table-name>'' VALUES(1, "Hello");
+This insert command uses the table definition created as an example here.