跳到主要内容
跳到主要内容

array_pushfront

array_pushfront

SinceVersion 1.2.3

array_pushfront

description

Syntax

Array<T> array_pushfront(Array<T> arr, T value) 将value添加到数组的开头.

Returned value

返回添加value后的数组

类型: Array.

notice

只支持在向量化引擎中使用

example

mysql> select array_pushfront([1, 2], 3);
+---------------------------------+
| array_pushfront(ARRAY(1, 2), 3) |
+---------------------------------+
| [3, 1, 2] |
+---------------------------------+

mysql> select col3, array_pushfront(col3, 6) from array_test;
+-----------+----------------------------+
| col3 | array_pushfront(`col3`, 6) |
+-----------+----------------------------+
| [3, 4, 5] | [6, 3, 4, 5] |
| [NULL] | [6, NULL] |
| NULL | NULL |
| [] | [6] |
+-----------+----------------------------+

mysql> select col1, col3, array_pushfront(col3, col1) from array_test;
+------+-----------+---------------------------------+
| col1 | col3 | array_pushfront(`col3`, `col1`) |
+------+-----------+---------------------------------+
| 0 | [3, 4, 5] | [0, 3, 4, 5] |
| 1 | [NULL] | [1, NULL] |
| 2 | NULL | NULL |
| 3 | [] | [3] |
+------+-----------+---------------------------------+

keywords

ARRAY,PUSHFRONT,ARRAY_PUSHFRONT