From the course: MySQL Database Administration

Unlock this course with a free trial

Join today to access over 24,500 courses taught by industry experts.

Solution: Deleting records

Solution: Deleting records - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Solution: Deleting records

“

- [Instructor] Alright, this is the solution video for your assignment on deleting data. As a reminder, Amy needs your help deleting an employee's record from her employee table and she'd also like you to remove all records from the customer reviews table so that she can start fresh. Let's jump into Workbench and walk through the solution. Alright, so first thing I'm going to do is select the candy store schema with a use statement. So now our candy store schema is set as the default and we can just look at what we have in here. We've got two tables, customer reviews and employees. So, let's take a look. She wants us to help her out with both of these. First, let's take a look at employees. (keyboard keys clicking) Just running our select star and we've got all the records in here. So, the employee in question, Maggie Simpson, was caught for having fake customer ratings and she's been fired and Amy wants us to help her by deleting this record from the database. So, we'll get to that…

Contents