H2 Database – Introduction H2 is an open-source lightweight Java database. It can be embedded in Java applications or run in the client-server mode. Mainly, H2 database can be configured to run as inmemory database, which means that data will not persist on the disk. Because of embedded database it is not used for production […]
Category Archives: h2 Database
H2 Database – Explain EXPLAIN command displays the execution plan for a statement. When we execute a statement using EXPLAIN ANALYZE command, the query plan will include the actual row scan count for each table. Syntax Following is the generic syntax of the EXPLAIN command. EXPLAIN { [ PLAN FOR ] | ANALYZE } { […]
H2 Database – Insert The SQL INSERT statement is used to add new rows of data to a table in the database. Syntax Following is the basic syntax of INSERT INTO statement. INSERT INTO tableName { [ ( columnName [,…] ) ] { VALUES { ( { DEFAULT | expression } [,…] ) } [,…] […]