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: Adding and removing columns

Challenge: Adding and removing columns - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Challenge: Adding and removing columns

“

- [Narrator] All right, we're ready for your assignment on altering tables. For this assignment, Amy Baker is the owner of the candy store and she needs your help making a couple of updates to one of her tables. She's about to start sharing her database with her employees, but she needs a couple of things updated before she can do that. So the first thing, she needs you to remove the hourly wage column from the employees table. She doesn't want all of her employees being able to see what everyone else is earning. And then second, on that same employees table, she'd like to add another column called avg_customer_rating. And she'd like that to be a decimal that has one digit past the decimal point. So here is what everything should look like if you've done it correctly. You should go from this table, the employees table, with an hourly wage column to an updated table, and you can see the difference. One of them has hourly wage, one of them has average customer rating, which at some…

Contents