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: Importing order item data

Challenge: Importing order item data - MySQL Tutorial

From the course: Advanced MySQL Database Administration

Start my 1-month free trial Buy for my team

Challenge: Importing order item data

“

- [Instructor] All right, we are ready for your first assignment on importing data into the database. For this assignment, Sally has two files, which each represent items that customers have ordered. She has one file for March and one file for April. She's looking for your help, importing these files into an order items table in the database. To start off, you'll want to create a new schema, which you can call mavenbearbuilders. Then make sure to set that as your default schema. You'll be using this schema throughout the entire course. You'll need to create a new table called order items. The columns that you need are listed here. You can also see them in the file. Make sure to give them appropriate data types. If you get stuck on the syntax, check out the review video on the create statement. And if you're having trouble importing, you might want to go back and watch the video on importing data from a file. Give this one a shot on your own. Really try to get it before watching the…

Contents