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.
Launch the
mysqlcommand-line client and connect to thetestdatabase in our MariaDB server.Insert some values into the
dyn_exampletable 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...