Ξ0 - XiZero - Linux Software Rasterizer - Open Source Software Renderer | atcrosslevel.de
Ξ0 - XiZero - Linux Software Rasterizer - Open Source Software Renderer | atcrosslevel.de
This blog post is a beginner-level tutorial explaining how to use HSQLDB , an SQL relational database system (RDBMS) written in Java. HSQLDB supports both the client-server model (i.e. the server opens the database files) and the embedded model (i.e. opening the database files directly). In both cases we mean use the term client meaning the process which initiates the SQL statement. Each HSQLDB table can have storage type memory , cached and text . Data in memory table is loaded to memory (from the .script
There is no need to create the files, HSQLDB will create them automatically.
java -jar sqltool.jar --rcFile=sqltool.rc first It displays a long welcome message, and shows you the sql> prompt. Type some SQL statements (without the leading sql> prompt): sql> CREATE TABLE names (first VARCHAR(255), last VARCHAR(255)); sql> INSERT INTO names VALUES ('first1', 'last1'); sql> INSERT INTO names VALUES ('first2', 'last2'); sql> COMMIT; sql> INSERT INTO names VALUES ('first3', 'last3'); sql> COMMIT; sql> SELECT * FROM names; FIRST LAST ------ ----- first1 last1 first2 last2 first3 last3 Fetc
Ξ0 - XiZero - Linux Software Rasterizer - Open Source Software Renderer | atcrosslevel.de
Ξ0 - XiZero - Linux Software Rasterizer - Open Source Software Renderer | atcrosslevel.de