JSON_MERGE_PATCH()

Overview

A description for this Function has not yet been added to this Documentation.

See also: Functions in 10.6 ES, in 10.5 ES, and in 10.4 ES

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}}                            |
+----------------------------------------------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES