H2 Database – Backup BACKUP is the command used to take database backup into a separate .zip file. Objects are not locked, and when it takes backup the transaction log is also copied. Admin rights are required to execute this command. Syntax Following is the generic syntax of the Backup command. BACKUP TO fileNameString; Example […]
Author Archives: user
H2 Database – Call CALL is a SQL command which belongs to H2 database server. This command is used to calculate a simple expression. It returns the result of the given expression in a single column field. When it returns an array of results, then each element in the array is displayed as a column […]
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 } [,…] ) } [,…] […]