Hide menu

TDDD37 Database Technology

Loading the lab database

Step 1

Prepare to install the Jonson Brothers database tables.

Download the scripts company_schema.sql and company_data.sql to your current directory (home directory). The scripts will create the tables necessary for lab 1 and 2 and fill them with data.

Step 2

To run the scripts simply write the bold text below at the mysql> prompt:

mysql> source company_schema.sql
Query OK, 0 rows affected (0.01 sec)
...
Query OK, 0 rows affected (0.07 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> source company_data.sql
Query OK, 25 rows affected (0.01 sec)
Records: 25  Duplicates: 0  Warnings: 0
...
Query OK, 0 rows affected (0.00 sec)

If you have more questions please consult our FAQ or ask your lab assistant.

Once you have done this the tables will be available in your database and you do not need to redo this process.


Page responsible: Olaf Hartig
Last updated: 2016-10-05