JSON_INSERT()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
A description for this Function has not yet been added to this Documentation.
EXAMPLES
SET @json = '{ "a": 1, "b": 2, "c": 3}';
SELECT JSON_INSERT(@json, '$.a', 2, '$.d', 4);
+----------------------------------------+
| JSON_INSERT(@json, '$.a', 2, '$.d', 4) |
+----------------------------------------+
| {"a": 1, "b": 2, "c": 3, "d": 4} |
+----------------------------------------+
SET @json = '{ "a": 1, "b": 2, "c": 3}';
SELECT JSON_INSERT(@json, '$.a', 5, '$.d', 4);
+----------------------------------------+
| JSON_INSERT(@json, '$.a', 5, '$.d', 4) |
+----------------------------------------+
| {"a": 1, "b": 2, "c": 3, "d": 4} |
+----------------------------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.