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
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.
First, you need to complete the Creating tables with dynamic columns recipe.
mysqlcommand-line client and connect to the
testdatabase in our MariaDB server.