MySQL is the world's leading open-source Relational Database Management System (RDBMS) or simply, relational database. MySQL is installed by default on many Linux distributions as well as MacOS; it also available for Windows. MySQL is included in your Codenvy.io environment (which is a Linux-based system).
We will be using a sample student information system (SIS) database for the remainder of this unit. Click here to download a backup (or dump) of that database.
Create a new folder in your 376 project on Codenvy.io called
sql. Once your
download is complete, upload that file the
sql folder. The rest of your
work will be done in the terminal window.
sudo service mysql start
mysql -u root
source [insert name of SQL file here]
use [insert database name here];
desc [insert table name here];