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.

Bonus: Load data

Bonus: Load data - MySQL Tutorial

From the course: Advanced MySQL Database Administration

Start my 1-month free trial Buy for my team

Bonus: Load data

“

- [Instructor] All right, in this next lecture we're going to be talking about LOAD DATA. LOAD DATA is going to be a self-study concept, so it's not officially part of this course. We're not going to have any assignments. We won't actually be supporting questions in the Q&A forums regarding LOAD DATA, but I wanted you to understand that it exists, because this can be a really important thing when you're actually out there in the real world. I'll explain more about this in a moment. This is another method for importing large datasets into a MySQL database. We already covered how to do that with the data import wizard. This is a way that you can do that with code. So one major benefit is that LOAD DATA can be faster, and when your datasets get very large, this is actually going to be material for you. Then the second major advantage is that you can employ the help of an engineer to automate a script using LOAD DATA, which will bring the data into the database on a recurring basis…

Contents