JSON_MERGE_PATCH()
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
SELECT JSON_MERGE_PATCH('{"a": "1"}', '{"b": 2}');
+--------------------------------------------+
| JSON_MERGE_PATCH('{"a": "1"}', '{"b": 2}') |
+--------------------------------------------+
| {"a": "1", "b": 2} |
+--------------------------------------------+
SELECT JSON_MERGE_PATCH('{ "a": 1, "b":2 }','{ "a": 5, "c":1 }','{ "b": 3, "d":1 }');
+-------------------------------------------------------------------------------+
| JSON_MERGE_PATCH('{ "a": 1, "b":2 }','{ "a": 5, "c":1 }','{ "b": 3, "d":1 }') |
+-------------------------------------------------------------------------------+
| {"a": 5, "b": 3, "c": 1, "d": 1} |
+-------------------------------------------------------------------------------+
SELECT JSON_MERGE_PATCH('{"a":1, "b":2}', '{"c":null}','{"c": 3}');
+-------------------------------------------------------------+
| JSON_MERGE_PATCH('{"a":1, "b":2}', '{"c":null}','{"c": 3}') |
+-------------------------------------------------------------+
| {"a": 1, "b": 2, "c": 3} |
+-------------------------------------------------------------+
SELECT JSON_MERGE_PATCH('{"a":1, "b":2}', '{"b":null}','{"c": 3}');
+-------------------------------------------------------------+
| JSON_MERGE_PATCH('{"a":1, "b":2}', '{"b":null}','{"c": 3}') |
+-------------------------------------------------------------+
| {"a": 1, "c": 3} |
+-------------------------------------------------------------+
SELECT JSON_MERGE_PATCH('{"a":{"a":1}}', '{"a":{"a":2}}');
+----------------------------------------------------+
| JSON_MERGE_PATCH('{"a":{"a":1}}', '{"a":{"a":2}}') |
+----------------------------------------------------+
| {"a": {"a": 2}} |
+----------------------------------------------------+
SELECT JSON_MERGE_PATCH('{"a":{"b":1}}', '{"a":{"c":2}}');
+----------------------------------------------------+
| JSON_MERGE_PATCH('{"a":{"b":1}}', '{"a":{"c":2}}') |
+----------------------------------------------------+
| {"a": {"b": 1, "c": 2}} |
+----------------------------------------------------+