mysql> UPDATE assets SET
dynamic_cols=COLUMN_ADD(dynamic_cols,
'color'
,
'white'
) WHERE
COLUMN_GET(dynamic_cols,
'color'
as char)=
'black'
;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> 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"
:
"white"
,
"warranty"
:
"3 years"
} |
+-----------------+----------------------------------------+
2 rows
in
set
(0.00 sec)