Join Bill Weinman for an in-depth discussion in this video Creating a joined view, part of MySQL Essential Training (2014).
…A view can be a simple straight query or it can be a more complex joined query.…The technique is the same.…For this lesson, we will be using the album database.…And I want to start with a query that shows all the…tracks for each album with the duration as minutes and seconds.…I'm just going to go ahead and copy and paste this out of the exercise files here.…And grab it here starting at line 75.…And I'll copy that and paste it into SID and press go.…
And so you see we have a simple joined query…with artist, album, track, track number, minutes and seconds, like that.…And, there's the query where we can look at it in the editor.…And you can see it's a pretty straight forward…joint query, we've covered all of this stuff already.…Now if I find this query very, very useful, I can save this as a view.…So I can just say CREATE VIEW, call it joinedAlbum.…As, and there's my query.…
And then I can come down here and I can say SELECT * FROM joinedAlbum like that.…Press Go.…And there is my exact same result, but this time the query is saved.…
- Writing queries
- Creating and updating databases and tables
- Using MySQL built-in functions
- Sorting and filtering data
- Updating tables with triggers
- Working with subselects and views
- Creating and using a stored function
Skill Level Beginner
1. Installing and Configuring the Test Environment
2. Basic Syntax
3. Creating a Database
4. MySQL Data Types
5. MySQL Functions
8. Subselects and Views
9. Stored Routines
10. PHP's PDO Interface with MySQL
- 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.