From the course: Advanced MySQL Database Administration

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Solution: Import remaining 2012 data

Solution: Import remaining 2012 data - MySQL Tutorial

From the course: Advanced MySQL Database Administration

Start my 1-month free trial Buy for my team

Solution: Import remaining 2012 data

“

- [Instructor] All right. This is the solution video for your assignment on importing the remaining 2012 data. For this assignment, Sally has given you two files, files four and five, and she wants you to import them into the order items, and order item refunds tables. Let's jump into workbench, and we'll walk through it. So by this point, I think the data import process should be pretty old hat to you. This assignment is a good way to reinforce it. And one thing I just want to show is how we can do some quick QA to make sure stuff is working as expected. So if we have selecting from the order items table, and separately, I'll also have something selecting from the order item refunds table. And so I'm going to say, MAC(created_at). And I'll do a COUNT(*) AS records. And we'll put the same thing down here. Great. So before we do anything, we'll take a look and in the order items table, we see April 30th there was the last record, and we see 159 records. And then similarly, in the order…

Contents