Join Sheeri Cabral for an in-depth discussion in this video Querying similar tables as one, part of MariaDB for MySQL Users.
…You may have a few tables that are similar to each other and…want to query them as one.…That's where the connect storage engine's table list functionality comes in.…Let's see how this works by combining two tables from a previous example.…Let's refresh our memory on what the birthdays_ini table and…people_full table look like.…So let's describe birthdays_ini.…And also let's describe the people_full table.…Both tables have a first name, last name and birthday as the first three fields.…
The birthdays ini table has an extra field called ID.…The people full table has a few more fields.…Note that the fields do not have to have the same name nor…be defined exactly the same.…For example, in the birthdays INI table, the first field is called first.…It has a type of varchar 20.…And it has a default of null.…In the people_full table, the field is called first name.…The type is also a varchar 20.…But the field is not allowed to be null.…Let's clear our screen and try to combine them to see what happens.…
So let's create a table and let's call it all_birthdays because it will be…
- Why use dynamic columns?
- Creating, updating, and querying dynamic columns
- Installing the CONNECT storage engine
- Connecting to remote data
- Connecting to CSV, INI, and XML files
- Using PIVOT tables
- Accessing database metadata
- Working with the Cassandra storage engine
Skill Level Intermediate
Ruby on Rails 4 Essential Trainingwith Kevin Skoglund12h 41m Beginner
1. Dynamic Columns
2. The Power of CONNECT
3. Advanced CONNECT Storage Engine
4. The Cassandra Storage Engine
Next steps1m 46s
- 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.