Linux Derby DB Getting Started Guide
Hi! The Tutorial shows you Step-by-Step How to Getting-Started with the Apache Derby Java Database Hello-World on GNU/Linux.
And Apache Derby for Linux, an Apache DB subproject, is an Open Source Relational Database implemented entirely in Java.
![Linux Apache Derby Getting Started Guide - Featured](https://tutorialforlinux.com/wp-content/media/dg139/intro/gnomePenguinBallApache.jpg)
How to Install Derby Database on Linux
Creating a Derby DB and Running SQL Statements.
Run Derby ij Tool.
java -jar $DERBY_HOME/lib/derbyrun.jar ij
Create and Open Connection to Derby DB.
CONNECT 'jdbc:derby:mydb;create=true';
Create the Hello World Table.
CREATE TABLE HELLOWORLD (ID INT PRIMARY KEY, CITY VARCHAR(20), NAME VARCHAR(12));
Insert Values into Hello World Table.
INSERT INTO HELLOWORLD VALUES (1,'ROMA','MARIO'),(2,'LOSANGELES','BOB'),(4,'PARIS','JACQUES');
Query Hello World Database.
SELECT * FROM HELLOWORLD;
Apache Derby Database Online Documentation