mysql github: https://github.com/mysqljs/mysql#install
npm install mysql
sqlectron (for testing queries) https://sqlectron.github.io/ Used for checking.
There is also this website to create MySQL tables from Excel spreadsheets: https://sqlizer.io/#/
mysql server setup: https://dev.mysql.com/doc/mysql-getting-started/en/
Please change the username and password in the main.js for the MySQL localhost connection to your username and password.
To run the program run the following command:
npm install && npm start