Install Beekeeper Studio (Community Edition)
Documentation can be found hear
docker login
docker run -p 13306:3306 --name mysql_uni_project -e MYSQL_ROOT_HOST=% -e MYSQL_ROOT_PASSWORD=root -d mysql:latest
Access a terminal to the docker container docker exec -it mysql_uni_project /bin/sh
mysql --host=127.0.0.1 --port=13306 -u root -p
if you need to install the database after you have the connection you can just write
source mysqlsampledatabase.sql
if this database is in your directory
The logic schema can be found in this link
- Complete the project
- Restructure the README.md following previous repo you created
Difference between where and grup by (having va doop grup by) Be carefull on the constraints