MySQL databases are only as useful as the data they contain. Learn how to process poorly formatted data using Notepad++ before importing into MySQL. Then, create a table to store data and import it using the LOAD DATA function.
- [Instructor] My first step is to import…the California educational attainment data…into MySQL so we can start to manipulate it.…Looking at the data here in Notepad++,…I can see that it's mostly text.…The only numeric field appears to be the population.…I also notice a problem right away in the first data row.…The last value of the first row,…the population count, is empty.…That's going to break our import right away,…but fortunately, because it appears at the end of the file,…it's very easy to fix in Notepad++.…I'm going to make sure that I don't have any text selected,…and then click the replace button in the menu bar.…
Having a text selection would only replace values…within that selection,…and I want to replace the whole document.…In the Replace window,…I'll check the radio button for Extended Search Mode.…That'll allow us to search for newline characters.…And since the missing values are at the end of the line,…we want to replace those newlines with a zero,…and then a newline.…So in the Find what field, I'll type ,\n…
- 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.