CIS$276$DA$\_$lesson$10$ Instructions:

Setup:

Make sure you have Node.js and MySQL installed on your system. Create a new folder for your project and navigate to it using the command line.

Database Setup:

Create a new MySQL database named "employee$\_$db$"$ or a name of your choice. Create a table named "employees" with columns $"$id$"($INT$),$ "name" $($VARCHAR$),$ and "job$\_$title" $($VARCHAR$).$

Node.js Application:

Inside your project folder, create a new file named "app.js$".$

Connect to the Database:

Require the mysql npm package and create a connection to the MySQL database using your database credentials.

INSERT Statement:

Write a function to insert a new employee record into the "employees" table. Use the connection.query$()$ method to execute an INSERT query.

SELECT Statement:

Write a function to retrieve the names of all employees from the "employees" table. Use the connection.query$()$ method to execute a SELECT query.

UPDATE Statement:

Write a function to update the job title of an employee. Use the connection.query$()$ method to execute an UPDATE query.

DELETE Statement:

Write a function to delete an employee record from the "employees" table. Use the connection.query$()$ method to execute a DELETE query.

Execution:

Run your Node.js application using the command node app.js$.$ Check the console output for the results of each query.