Dynamic columns is a feature that allows one to store different sets of columns for each row in a table. It works by storing a set of columns in a blob and having a small set of functions to manipulate it.
| Title | Description |
|---|---|
| COLUMN_ADD | Adds or updates dynamic columns |
| COLUMN_CHECK | Checks if a dynamic column blob is valid |
| COLUMN_CREATE | Returns a dynamic columns blob |
| COLUMN_DELETE | Deletes a dynamic column |
| COLUMN_EXISTS | Checks is a column exists |
| COLUMN_GET | Gets a dynamic column value by name |
| COLUMN_JSON | Returns a JSON representation of dynamic column blob data |
| COLUMN_LIST | Returns comma-separated list |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/dynamic-columns-functions/