From the course: Advanced MySQL Database Administration

Unlock this course with a free trial

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

Challenge: Adding a product to order items

Challenge: Adding a product to order items - MySQL Tutorial

From the course: Advanced MySQL Database Administration

Start my 1-month free trial Buy for my team

Challenge: Adding a product to order items

“

- [Instructor] All right. We're ready for your assignment on adding the product to the order_items table. So in your last assignment, you updated the database to include a products table. Now, Sally needs your help updating the order_items table to add a new column that will track which product was sold. She'd like you to add a column and call it product_id. For this assignment, don't worry about back-populating the data, just add the column here. Once you complete this, you should see this additional column, product_id, and all of the values are just going to be null. Like I said, don't worry about back-populating it, just add the column, and we'll worry about the back population later. If this one gives you trouble, go for the review lecture on alter table, try to get the answer on your own here, and then come back and watch the solution video and we'll show you how it's done. Good luck.

Contents