JSON_INSERT

Learn about the JSON_INSERT function in MariaDB. This function inserts new data into a JSON document without replacing existing values, returning the updated document or NULL.

Syntax

JSON_INSERT(json_doc, path, val[, path, val] ...)

Description

Inserts data into a JSON document, returning the resulting document or NULL if either of the json_doc or path arguments are null.

An error occurs if the JSON document is invalid, or if any of the paths are invalid or contain a * or ** wildcard.

JSON_INSERT can only insert data, while JSON_REPLACE can only update. JSON_SET can update or insert data.

Examples

SET @json = '{ "A": 0, "B": [1, 2]}';

SELECT JSON_INSERT(@json, '$.C', '[3, 4]');
+--------------------------------------+
| JSON_INSERT(@json, '$.C', '[3, 4]')  |
+--------------------------------------+
| { "A": 0, "B": [1, 2], "C":"[3, 4]"} |
+--------------------------------------+

See Also

• JSON video tutorial covering JSON_INSERT.

_{This page is licensed: CC BY-SA / Gnu FDL}