Database

tutorial - documentation - mySQL - access from java

Tutorial & example

Learn the essentials about databases and our approach.

General Information about databases

about Relational Databases

about SQL

SQL tutorial (the best I could find)
Quickbase's Ultimate Web Guide to SQL Database Language (recommended by Sara Long)
A Gentle Introduction to SQL

The mySQL Database

NOTE: we migrated from miniSQL to MySQL, here is the old mSQL documentation, which is in fact a subset of MySQL.

We use the mysql database, The Most Popular Open Source Database.
Our server info9 serves as our database server.

The online mysql-manual (pdf-file + a copy is available at the lab):

The mySQL Query Language

a subset of the standard SQL

C Programming API

access the database from C

Programs (see tutorial):

mysql: the monitor to access the database
mysqlshow: to view the structure of the database
mysqldump: to dump the definitions and/or data of a database
...

Add the following to your projectfile:

INCLUDEPATH = /usr/include/mysql # includes for compilation
LIBS = -L/usr/lib/mysql -lmysqlclient # libraries for linking

JDBC for java database access