Merge JSON documents. This function merges two or more JSON documents into a single JSON document, preserving all keys and values.
JSON_MERGE(json_doc, json_doc[, json_doc] ...)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. is an RFC 7396-compliant replacement, and is a synonym.
This page is licensed: CC BY-SA / Gnu FDL
SET @json1 = '[1, 2]';
SET @json2 = '[3, 4]';
SELECT JSON_MERGE(@json1,@json2);
+---------------------------+
| JSON_MERGE(@json1,@json2) |
+---------------------------+
| [1, 2, 3, 4] |
+---------------------------+