HSQLDB

A database index is a data structure that improves the speed of operations in a table. Indexes can be created using one or more columns, providing the basis for both rapid random…

Whenever there is a need to change the name of a table or a field, change the order of fields, change the data type of fields, or any table structure,…

A Transaction is a sequential group of database manipulation operations, which is performed and considered as one single work unit. In other words, when all the operations are successfully executed, only then…

HSQLDB supports some special symbols for pattern-matching operations based on regular expressions and the REGEXP operator. Following is the table of patterns, which can be used along with the REGEXP…

SQL NULL is a term used to represent a missing value. A NULL value in a table is a value in a field that appears to be blank. Whenever we…

Whenever there is a requirement to retrieve data from multiple tables using a single query, you can use JOINS from RDBMS. You can use multiple tables in your single SQL…

The SQL SELECT command fetches data from the HSQLDB table whenever there is a requirement that follows a particular order while retrieving and displaying records. In that case, we can…

There is a WHERE clause in the RDBMS structure. You can use the WHERE clause with an equal to sign (=) where we want to do an exact match. But…

Whenever you want to delete a record from any HSQLDB table, you can use the DELETE FROM command. Syntax Here is the generic syntax for the DELETE command to delete…

Whenever you want to modify the values of a table, you can use the UPDATE command. This will modify any field value from any HSQLDB table. Syntax Here is the…