Reading data from 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
SELECT statements will not understand how to properly read the data stored in a dynamic columns
BLOB. They will see it as a
BLOB column and treat it like any other
BLOB. This recipe introduces and demonstrates the basic functions used when reading a dynamic column.
Complete the Creating tables with dynamic columns recipe and the Inserting, updating, and deleting dynamic column data recipe in this chapter.
mysqlcommand-line client. Connect to our MariaDB server and the