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.

Challenge: Importing refund data

Challenge: Importing refund data - MySQL Tutorial

From the course: Advanced MySQL Database Administration

Start my 1-month free trial Buy for my team

Challenge: Importing refund data

“

- [Instructor] All right, we're ready for your next assignment, which is on importing refund data into the database. Just like your last assignment, your CEO Sally is coming to you with data she has in a CSV file and she's looking for your help getting this into the database after you create a new table. The table you'll need to create is called "Order Item Refunds". The data that you'll be inserting relates to items which customers have been given a refund for. Some quick hints, make sure to have the Maven Bear Builders set as your default schema. Then create a new table with the columns that you see here, and make sure to use the appropriate data types. This should feel really similar to your last assignment. You're basically doing the same thing, creating a table, and then loading the data. If you struggled with that one, this should be another chance to go through it on your own. If you did well the first time around, this should really reinforce that concept and it's a concept…

Contents