JSON_MERGE

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}