Employee tracker is a web application that allows users to create, update, and delete employees from a company database. This project demonstrates how to query and add to an employee database using SQL. Queries and entries are initilized through npm inquirer, any updates to the database can be shown through the console.table command.
- $git clone git@github.com:jermeewinn/employee-tracker.git
- $npm init
- $npm install inquirer
- $npm install mysql2
- $npm install console.table
- $mysql -u root -p
- Enter password provided in db/connection.js
- mysql source db/db.sql;
- mysql source db/schema.sql;
- mysql source db/seeds.sql;
- mysql exit;
- $npm start
https://watch.screencastify.com/v/2hH8QYd6KNNnNeUAsuX0
- Javascript
- MySQL
- Inquirer
- Node Package Manager
- Console Table
Made by Jeremy Huynh