HSQLDB – Where Clause
Generally, we use the SELECT command to fetch data from the HSQLDB table. We can use the WHERE conditional clauses to filter the resultant data. Using WHERE we can specify…
HSQLDB – Select Query
The SELECT command is used to fetch the record data from the HSQLDB database. Here, you need to mention the list of the required fields in the Select statement. Syntax…
HSQLDB – Insert Query
You can achieve the Insert query statement in HSQLDB by using the INSERT INTO command. You have to provide the user-defined data following the column field order from the table.…
HSQLDB – Drop Table
It is very easy to drop an existing HSQLDB table. However, you need to be very careful while deleting any existing table as any data lost will not be recovered…
HSQLDB – Create Table
The basic mandatory requirements to create a table are table names, field names, and the data types to those fields. Optionally, you can also provide the key constraints to the…
HSQLDB – Data Types
This chapter explains the different data types of HSQLDB. HSQLDB server offers six categories of data types. Exact Numeric Data Types Data TypeFromTobigint-9,223,372,036,854,775,8089,223,372,036,854,775,807int-2,147,483,6482,147,483,647smallint-32,76832,767tinyint0255bit01decimal-10^38 +110^38 -1numeric-10^38 +110^38 -1money-922,337,203,685,477.5808+922,337,203,685,477.5807smallmoney-214,748.3648+214,748.3647 Approximate Numeric Data…
HSQLDB – Connect
In the installation chapter, we discussed how to connect the database manually. In this chapter, we will discuss how to connect the database programmatically (using Java programming). Take a look…
HSQLDB – Installation
HSQLDB is a relational database management system implemented in pure Java. You can easily embed this database into your application using JDBC. Or you can use the operations separately. Prerequisites…
HSQLDB – Introduction
HyperSQL Database (HSQLDB) is a modern relational database manager that conforms closely to the SQL:2011 standard and JDBC 4 specifications. It supports all core features and RDBMS. HSQLDB is used…
HSQLDB
HyperSQL Database is a modern relational database manager that conforms closely to the SQL:2011 standard and JDBC 4 specifications. It supports all core features and RDBMS. HSQLDB is used for…