O'Reilly logo

MariaDB Cookbook by Daniel Bartholomew

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Reading data from a dynamic column

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.

Getting ready

Complete the Creating tables with dynamic columns recipe and the Inserting, updating, and deleting dynamic column data recipe in this chapter.

How to do it...

  1. Launch the mysql command-line client. Connect to our MariaDB server and the test database.
  2. Discover the columns in our ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required