From the course: Advanced MySQL Database Administration

Unlock this course with a free trial

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

Solution: Importing refund data

Solution: Importing refund data - MySQL Tutorial

From the course: Advanced MySQL Database Administration

Start my 1-month free trial Buy for my team

Solution: Importing refund data

“

- [Instructor] All right, this is the solution video for your assignment on importing refund data. As a reminder, Sally is looking for help getting her order_item_refunds data into the database. So we'll be creating a new table called order_item_refunds, and then we'll be using the import wizard to load the data. Let's jump into Workbench and I'll walk you through it. All right, so I'm going to just make sure that we have the default schema set. It's actually set already, but just putting this on here in case it's going to trip anybody up. So when you run that USE and it's already set as the default, nothing happens. I can run it again. You'll see it was the default, it remains the default, and it doesn't harm anything. So in that mavenbearbuilders schema, you can see the table list, and the only table right now is order_items. We want to create a new table called order_item_refunds. So let's do that. And per usual, I'll start by just opening and closing the table and we'll have…

Contents