ARRAY_FLATTEN

array_flatten

array_flatten

描述

语法

ARRAY<T> array_flatten(ARRAY<ARRAY<T>> array1)

将多维数组展平成一维。

举例

mysql> select array_flatten([[1,2,3],[4,5]]);
+--------------------------------+
| array_flatten([[1,2,3],[4,5]]) |
+--------------------------------+
| [1, 2, 3, 4, 5]                |
+--------------------------------+
1 row in set (0.01 sec)

mysql> select array_flatten([[[[[[1,2,3,4,5],[6,7],[8,9],[10,11],[12]],[[13]]],[[[14]]]]]]);
+-------------------------------------------------------------------------------+
| array_flatten([[[[[[1,2,3,4,5],[6,7],[8,9],[10,11],[12]],[[13]]],[[[14]]]]]]) |
+-------------------------------------------------------------------------------+
| [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14]                               |
+-------------------------------------------------------------------------------+
1 row in set (0.02 sec)

keywords

ARRAY,ARRAY_FLATTEN