JSON_ARRAY_APPEND()

USAGE

DETAILS

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

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"]            |
+------------------------------------+

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

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Added in MariaDB Community Server 10.2.3.

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