Environment for doing sql labs. Includes:
- script to initialize a container with mysql;
- script to run a command promt in this container;
- scripts for filling database with data (creating tables and records).
NB: you need docker for using this environment
NB: don't forget to chmod +x for scripts
. createThis command will create a docker container named sqlab with latest mysql server inside.
. runThis will run a SQL command promt in your terminal. It assumes that sqlab container was already created before.
This container is stopped and started automatically inside the script.
./files directory containes needed scripts and is mounted into container as /files.
To test that all is mounted correctly, type:
source /files/test.sqlIt should print that 2*2 == 4.
To create database, then tables and then records type:
create database lab;
use lab;
source /files/tables.sql
source /files/dump.sql
# test that everything is ok:
select * from P;Type exit to exit sql command promt, stop sqlab container and than exit the run script.