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.

Solution: Importing order item data

Solution: Importing order item data - MySQL Tutorial

From the course: Advanced MySQL Database Administration

Start my 1-month free trial Buy for my team

Solution: Importing order item data

“

- [Presenter] Alright, this is the solution video for your assignment on importing order item data. Hopefully, you were able to get this on your own. As a reminder, Sally has provided you with these two files and she wants you to create an order items table and get these files loaded into the database. Before we actually do anything in workbench. Again, I just want to stress the files that are available in the download course resources section. I've got those all in this one file folder. And for this assignment, we're going to be using these two, the order items, March, 2012 and order items April, 2012 files. So I'm going to open one of those up and just so I can show you what this looks like before we do anything. Alright, so we have these six columns. We have order item ID, which looks like in auto-incrementing integer. It's just values that go up by one, we have when that order was created. We have the order ID, the price USD, cogs USD, which is how much someone paid and how much…

Contents