Join Sheeri Cabral for an in-depth discussion in this video Connecting to an XML file, part of MariaDB for MySQL Users.
…Many developers work with XML based information.…You can easily take this type of structured data and…put it into a table using the CONNECT storage engine.…Let's take a look at our example XML file, which is in var/tmp and called people.xml.…In it, you can see we have people in computer science defined by the area and…person tags.…Each person has a first name, a last name, a date of birth, and…an optional date of death.…Each person also has a career attribute.…
Underneath each person is a shortlist of their achievements in…the area of computer science.…Grace Hopper invented the compiler and the first compiler languages.…And one of my achievements was writing a book about MySQL a few years ago.…Each achievement has its own year and description.…Let's log into MariaDB and…the connect database, and create a table to look at this XML file.…So let's call it, CREATE TABLE.…Let's call it people_xml.…We don't have to put that xml description at the end but…I like to, so I know what I'm looking at later.…
The first thing to note is that the CONNECT storage engine will…
- 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.