Tables with dynamic columns are similar to regular tables, but not quite the same. Similar to standard tables, they have columns and rows. The difference is that each row can have a different number of columns holding the data and the data types that are appropriate for that row.
Launch the
mysqlcommand-line client and connect to our MariaDB server.Create a test database and use it with the following command:
CREATE DATABASE IF NOT EXISTS test; USE test;
Create a table with a standard
PRIMARY KEYcolumn and aBLOBcolumn using the following commands:CREATE TABLE dyn_example ( id SERIAL PRIMARY KEY, dyn_cols BLOB );
The dynamic columns feature in MariaDB is a set of special functions that allow us to define and redefine the number of columns and their data types as needed on a row-by-row basis without altering our table configuration. These special columns exist and are defined as a standard BLOB column in our CREATE...