JSON_MERGE

Merge JSON documents. This function merges two or more JSON documents into a single JSON document, preserving all keys and values.

Syntax

JSON_MERGE(json_doc, json_doc[, json_doc] ...)

Description

Merges the given JSON documents.

Returns the merged result, or NULL if any argument is NULL.

An error occurs if any of the arguments are not valid JSON documents.

JSON_MERGE is deprecated. JSON_MERGE_PATCH is an RFC 7396-compliant replacement, and JSON_MERGE_PRESERVE is a synonym.

Example

SET @json1 = '[1, 2]';
SET @json2 = '[3, 4]';

SELECT JSON_MERGE(@json1,@json2);
+---------------------------+
| JSON_MERGE(@json1,@json2) |
+---------------------------+
| [1, 2, 3, 4]              |
+---------------------------+

See Also

• JSON_MERGE_PATCH

• JSON_MERGE_PRESERVE

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