json_array
Converts each element of an SQL array to a JSON value and returns a JSON array that consists of the JSON values.
tip
All of the JSON functions and operators are listed in the navigation and on the overview page
Accelerate your queries with generated columns
Syntaxβ
json_array(value, ...)
Parametersβ
value
: an element in the SQL array. Only NULL
values and the following data types are supported: STRING, VARCHAR, CHAR, JSON, TINYINT, SMALLINT, INT, BIGINT, LARGEINT, DOUBLE, FLOAT, and BOOLEAN.
Return valueβ
Returns a JSON array.
Examplesβ
Example 1: Construct a JSON array that consists of values of different data types.
mysql> SELECT json_array(1, true, 'starrocks', 1.1);
-> [1, true, "starrocks", 1.1]
Example 2: Construct an empty JSON array.
mysql> SELECT json_array();
-> []