From the course: MySQL Database Administration

Unlock this course with a free trial

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

Solution: Inserting and updating records

Solution: Inserting and updating records - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Solution: Inserting and updating records

“

- [Instructor] All right, this is your assignment on inserting and updating records. As a reminder, this is the result that you're going to be shooting for. You're going to want to add employee ID seven and eight with Charles and William and all of their data, and then you're going to want to populate the average customer rating column so that it looks like what you see here. Hopefully, you were able to get this on your own. If you haven't tried it yet, I would really encourage you to try and go through this exercise. It's a really valuable one. If you already have, let's jump into Workbench and walk through the solution now. All right, so first thing we do every time, we're going to run this USE candystore to make sure that we've selected the correct schema, and then I'm going to do a SELECT * from employees, the table that Amy wants our help operating on, and what we see here is we've got six employees and their names, their hire dates, their position, and their customer ratings…

Contents