Loading data into MySQL can be a slow and laborious process. In this video, learn how to use the built-in LOAD DATA function to quickly and easily import data from a comma separated values text file.
- [Narrator] There are many ways to get data…into a MySQL table.…You can use a series of insert statements,…load directly from files containing raw SQL,…or even import CSV files directly in the Workbench.…However, for the size of the data we're dealing with,…these are way too slow.…In fact, if you have an older machine,…the direct CSV import of a California population data…might take literally hours.…Fortunately, there's a built-in function that's much faster.…Load Data.…A Load Data statement is run in a normal SQL tab,…just like the Select statement we ran earlier.…
First, we need to select our database as Default…to make sure that the SQL tab knows which database…it's supposed to be running commands against.…Then I'll click this button to open up a new SQL tab…and start typing my command.…Start with load data local infile.…Just means we're going to be loading data…that's local to our machine,…and we'll be loading it from a file, rather than to a file.…And then, I need the full absolute path of the data source…
- Strengths and weaknesses of MySQL
- Creating a database
- Joining data sets
- Integrating Python with MySQL
- Searching a database
- CRUD operations
- Performing calculations
Skill Level Appropriate for all
1. Data and MySQL in under Five Minutes
2. Create a Database
3. Join Two Datasets
4. Search a Database
Searching a database1m 51s
5. Create, Read, Update, and Delete Operations
6. Averages and Calculations
Next steps1m 1s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.