Database

tutorial - documentation - mSQL

Tutorial & example

Learn the essentials about databases and our approach.

General Information about databases

about Relational Databases

about SQL

SQL tutorial (the best I found)
A Gentle Introduction to SQL

The mSQL Database

We use the msql database, from Hughes technology. We have installed a msql database on our server (infopc23).

The msql-manual (ps-file + a copy is available at the lab):

The mSQL Query Language (a subset of the standard SQL) (pp. 19-15)
C Programming API (pp. 16-23)

access the database from C

Standard programs (pp. 26-30)

the monitor to access the database
relshow to view the structure of the database
...

Advanced: Lite Scripting language (pp. 31-35)

Add the following variable to your linux configuration (page 16):

add setenv MSQLDIR /usr/shared/Hughes to the file .cshrc.local, the path to mqsl

add the line /usr/shared/Hughes/bin to your .path.local file

Add the following to your makefile (page 16):

-I$(MSQLDIR)/include includes for compilation
-L$(MSQLDIR)/lib -lmsql libraries for linking