Join Sheeri Cabral for an in-depth discussion in this video Connecting to an INI file, part of MariaDB for MySQL Users.
…CSV is not the only type of text file you can connect to.…An INI file is a configuration file,…also known as a CNF file that has pairs of variables and their values.…One example of this is MySQL's own my.cnf file.…We have provided an example in the exercises.…So let's take a look at it.…It should be in var/temp/my.cnf.…You can see that there are three groups, mysqld, mysql.server, and mysqld_safe.…
In each group, there are variables set to specific values.…Each group sets the log error and pin file options, which we will look at in a bit.…We can make this configuration file into a table quite easily with the CONNECT…storage engine.…In fact, there are two different ways to do that.…With a column layout or with a row layout.…I will start with an example of the row layout because it works better with…configuration files that have sections with a lot of different items.…In a row layout, each row is a key value pair.…So, let's connect to our database giving the PASSWORD.…
And database is the connect database.…So let's CREATE a TABLE, we can give it any name we want.…
- 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?
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.