JSON_MERGE_PATCH()

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

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

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

11.4 Enterprise

  • Not present.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Added in MariaDB Community Server 10.4.5.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Added in MariaDB Community Server 10.3.16.

10.2 Enterprise

  • Added in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Added in MariaDB Community Server 10.2.25.

Release Series

History

11.4 Enterprise

  • Not present.

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