Inserting, updating, and deleting dynamic column data

Inserting new data and updating existing data in a dynamic column is not the same as with traditional columns. Without some help from a set of special dynamic columns functions, the standard MariaDB INSERT, UPDATE, and DELETE statements do not understand how to work with a dynamic column or the data stored in it. They will only see it as a BLOB column. This recipe introduces and demonstrates the basic functions used when interacting with a dynamic column.

Getting ready

First, you need to complete the Creating tables with dynamic columns recipe.

How to do it...

1. Launch the mysql command-line client and connect to the test database in our MariaDB server.

2. Insert some values into the dyn_example table we created earlier:

   INSERT INTO dyn_example (dyn_cols) VALUES
     (COLUMN_CREATE('name','t-shirt', 'color','blue'
         AS CHAR, 'size','XL' AS CHAR)),
     (COLUMN_CREATE('name','t-shirt', 'color','blue'
         AS CHAR, 'size','L' AS CHAR)),
     (COLUMN_CREATE...