Join Sheeri Cabral for an in-depth discussion in this video Updating dynamic columns, part of Understanding MariaDB for MySQL Users.
…What happens if we realize we want to add another part to…our dynamic column like the year the movie was released?…Let's first refresh our memory by taking a look at the dynamic column for…the DVD with SELECT COLUMN_JSON of extra FROM items WHERE the type is DVD.…And we have a rating in our extra column.…So, let's see what happens we use the COLUMN_CREATE function to try to…add the year.…Let's UPDATE items.…SET the extra equal to COLUMN_CREATE of year.…
And let's say it was created in the year 2000.…WHERE type equals DVD.…Now let's see what our extra column looks like for…this row and I'll hit the up arrow a few times to get back to the original query.…Our rating disappeared.…That's because the COLUMN_CREATE function creates a dynamic column and…overwrites what's already there.…There are special functions to change the parts of a dynamic column.…You can add and delete parts with COLUMN_ADD and COLUMN_DELETE.…COLUMN_ADD requires the name of the dynamic column and…then a comma separated list of the column names and their values.…
- 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.