Important
The SingleStore 10 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 10.
JSON_
On this page
The JSON_ function is a set of three JSON functions, which add the given element to the end of a JSON array.
Arrays are of the form:
["alpha", "beta", "gamma"]
["alpha", 1, 2, 3]-
JSON_is for all numeric data.ARRAY_ PUSH_ DOUBLE Javascript has only one numeric type. -
JSON_is for all text and binary types.ARRAY_ PUSH_ STRING -
JSON_is for all valid Javascript types, includingARRAY_ PUSH_ JSON true,false, JSON maps, and lists.
JSON_ARRAY_PUSH_<type>(json, value)
Arguments
-
json: a valid JSON array, or the name of a JSON column. -
value: the value to add to the array.
Return Value
-
The complete array including the new element.
-
SQL NULL if json is not a valid JSON array.
Examples
SELECT JSON_ARRAY_PUSH_STRING('["alpha", "beta"]', 'gamma') AS add_letters;
+--------------------------+
| add_letters |
+--------------------------+
| ["alpha","beta","gamma"] |
+--------------------------+SELECT JSON_ARRAY_PUSH_STRING("0", "beta") AS add_letters;
+-------------+
| add_letters |
+-------------+
| NULL |
+-------------+SELECT JSON_ARRAY_PUSH_DOUBLE('[1, 2, 3]', 'delta') AS position;
+-----------+
| position |
+-----------+
| [1,2,3,0] |
+-----------+SELECT JSON_ARRAY_PUSH_JSON('["alpha", false]', '{"beta":"gamma"}') AS add_map;
+-------------------+
| add_map |
+-------------------+
| ["alpha",false, |
| {"beta":"gamma"}] |
+-------------------+Last modified: