6. MySQL - MikaelAndriIngason/KEST3LN05EU-Lokaverkefni GitHub Wiki

Installation

$ sudo apt install mysql-server

---

Opening MySQL

$ sudo mysql -u root

---

Employees

CREATE TABLE employees 
(id INT, firstname VARCHAR(20), lastname VARCHAR(20), email VARCHAR(30), phonenumber VARCHAR(10), hiredate DATE, salary INT);

---

Departments

CREATE TABLE departments
(id INT, managerID INT, departmentname VARCHAR(30), locationID INT);

---

Locations

CREATE TABLE locations
(id INT, city VARCHAR(30), address VARCHAR(30), zipcode INT);

---

Jobs

CREATE TABLE jobs
(id INT, title VARCHAR(30), minsalary INT, maxsalary INT);