Comprehensive MySQL Data Manipulation

# Introduction

In this project, you will learn how to perform comprehensive DML (Data Manipulation Language) operations on the Employees table (`emp`) in the Employees database. You will learn how to insert new records, update existing records, and delete records from the table.

## 👀 Preview


## 🎯 Tasks

In this project, you will learn:

- How to access MySQL using the `sudo` command without a password
- How to import data from a SQL file into the MySQL database
- How to insert new records into the `emp` table using a single SQL statement
- How to update the supervisor of an employee in the `emp` table
- How to update all records in the `emp` table with a NULL `comm` value to set the `comm` to 0
- How to delete the record with the highest employee number from the `emp` table
- How to delete all employees who directly report to a specific manager in the `emp` table

## 🏆 Achievements

After completing this project, you will be able to:

- Perform comprehensive DML operations on a MySQL database table
- Understand how to use SQL statements to insert, update, and delete data
- Gain experience in managing and manipulating data in a relational database
- Develop problem-solving skills by completing the various tasks in the project