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.

Challenge: Inserting and updating records

Challenge: Inserting and updating records - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Challenge: Inserting and updating records

“

- [Instructor] Alright, we're ready for your assignment on inserting and updating records. For this assignment, we're going to be working with Amy Baker from the candy store again. She's really excited because she hired two new clerks, Charles Munger and William Gates. They have both started on March 15th of 2020. She would like you to add both of these employees to the employee's table for her. And she's also got data on average customer ratings now so she'd like you to update that column. The average ratings for employees one through six are 4.8, 4.6, 4.75, 4.9, 4.75, and 4.2 respectively. And the two new clerks are both at a solid 5.0. So when you successfully update the table, you'll see there are going to be two new employees, employee seven and eight, Charles and William. Their hire dates will be as shown here. Their positions will be clerk. And then the entirety of the average customer rating column will be populated. This one might be a little tricky for you, but I think…

Contents