H2 DML Operations: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 11: Line 11:
  INSERT INTO ''<table-name>'' VALUES(1, "Hello");
  INSERT INTO ''<table-name>'' VALUES(1, "Hello");


This insert command uses the table definition created as an example here.
This insert command uses the table definition created as an example [[H2_DDL_Operations#Create_Table|here]].

Revision as of 18:00, 25 September 2017

Internal

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.