JSON_ARRAY_APPEND()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
A description for this Function has not yet been added to this Documentation.
EXAMPLES
SET @json = '["a", ["b", "c"]]';
SELECT JSON_ARRAY_APPEND(@json, '$[1]', 'd');
+---------------------------------------+
| JSON_ARRAY_APPEND(@json, '$[1]', 'd') |
+---------------------------------------+
| ["a", ["b", "c", "d"]] |
+---------------------------------------+
SET @json = '["a", ["b", "c"]]';
SELECT JSON_ARRAY_APPEND(@json, '$[0]', 'A');
+---------------------------------------+
| JSON_ARRAY_APPEND(@json, '$[0]', 'A') |
+---------------------------------------+
| [["a", "A"], ["b", "c"]] |
+---------------------------------------+
SET @json = '["a", ["b", "c"]]';
SELECT JSON_ARRAY_APPEND(@json, '$[1][1]', 'C');
+------------------------------------------+
| JSON_ARRAY_APPEND(@json, '$[1][1]', 'C') |
+------------------------------------------+
| ["a", ["b", ["c", "C"]]] |
+------------------------------------------+
SET @json = '{"1": "a", "2": "b", "3": "c"}';
SELECT JSON_ARRAY_APPEND(@json, '$.2', 'B');
+---------------------------------------+
| JSON_ARRAY_APPEND(@json, '$.2', 'B') |
+---------------------------------------+
| {"1": "a", "2": ["b", "B"], "3": "c"} |
+---------------------------------------+
SET @json = '{"a": 1,"b": 2}';
SELECT JSON_ARRAY_APPEND(@json, '$', 'c');
+------------------------------------+
| JSON_ARRAY_APPEND(@json, '$', 'c') |
+------------------------------------+
| [{"a": 1, "b": 2}, "c"] |
+------------------------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.