Join Sheeri Cabral for an in-depth discussion in this video Creating dynamic columns, part of Understanding MariaDB for MySQL Users.
…A dynamic column in MariaDB is stored in a blob field.…Let's use our store as an example and make an items table.…Let's login to the database and first make a database for…this table called dynamic columns.…So let's create database.…Dynamic_cols.…And let's set the default character set to UTF8.…Speaking of good defaults.…Let's make sure we have some good defaults set before creating a table for…the character set and storage engine.…We want our character set to be utf8 and it is.…
And then let's make sure that our default storage engine is InnoDB.…And it is.…Now we can create the table.…Let's call it items, and give it an item id as an auto increment primary key.…Let's add in a type field.…So that we can, discriminate between, whether our item is a CD or DVD.…So lets give it a type of varchar 64 not null, and…then lets add the fields we said were common attributes to all of our items.…
The title we'll set as a varchar 255 not null.…The price as a decimal 5, 2 not null.…And the manufacturer, as a varchar 64 not null.…
- 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.