Join Sheeri Cabral for an in-depth discussion in this video Getting remote database metadata, part of Understanding MariaDB for MySQL Users.
…Let's look at an example of a catalog table to see what…we can find connecting to a remote MySQL database.…Let's create a table that will get column-level information, and…let's call it remote column catalog.…We definitely want the column name, which is flag number 1.…So that's going to be a VARCHAR(64) NOT NULL, and the flag is 1.…Let's get the data type of the column.…Which we're going to call data_type VARCHAR(16) NOT NULL, and…we're going to want flag equals 3.…
Let's see if the column allows null values.…So let's have a column called nullable TINYINT, unsigned, and…the flag for that is 8.…And let's also put in what the default value for the column is.…This is going to be a VARCHAR(64), and the flag is 12.…I'm also interested to see a magic field.…So let's put in the magic field, date format.…And let's have that be a VARCHAR(25).…The real work comes now, after we finish the column definitions and…start giving the table options.…First, let's specify a storage engine of CONNECT.…The option that tells MariaDB that this is a catalog table is called CATFUNC.…
- 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
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.