Learn how to perform bulk SELECT queries in MySQL to write to the console. You can also see the comparison between the time it takes to read data and the time taken to manipulate it by viewing the now-complete performance table.
- [Instructor] Our final task is to output the text…of the play to a console and measure the time that it takes.…I know we have experience in the other types…of operations.…This will be pretty simple.…In fact, I can do it almost instantly…in the workbench by clicking the select button…next to the AMND table…and replacing the star with the play text column…and rerunning it.…There's our play text,…but as you can see the time in the output window…at the bottom was truncated down to zero seconds,…and at any rate, that data's not being saved anywhere.…We're going to do this in Python again,…and I'm going to modify my update Shakespeare script,…and click file, save as, and save this to my desktop…as read Shakespeare.…
And I'm going to delete everything…between the start time and end time variable assignments.…And then before I forget,…I'm going to make sure that I insert a read row…into our performance table…rather than an update row,…and I'm going to directly execute our select query.…So I want to select play text from AMND,…
- 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.