MariaDB starting with 10.0.1

COLUMN_JSON was introduced in MariaDB 10.0.1




Returns a JSON representation of data in dyncol_blob. Can also be used to display nested columns. See dynamic columns for more information.


select item_name, COLUMN_JSON(dynamic_cols) from assets;
| item_name       | COLUMN_JSON(dynamic_cols)              |
| MariaDB T-shirt | {"size":"XL","color":"blue"}           |
| Thinkpad Laptop | {"color":"black","warranty":"3 years"} |

Limitation: COLUMN_JSON will decode nested dynamic columns at a nesting level of not more than 10 levels deep. Dynamic columns that are nested deeper than 10 levels will be shown as BINARY string, without encoding.


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.