array_pushfront

SinceVersion 2.0

array_pushfront

description

Syntax

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

Returned value

返回添加value后的数组

类型: Array.

notice

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

example

  1. mysql> select array_pushfront([1, 2], 3);
  2. +---------------------------------+
  3. | array_pushfront(ARRAY(1, 2), 3) |
  4. +---------------------------------+
  5. | [3, 1, 2]                       |
  6. +---------------------------------+
  8. mysql> select col3, array_pushfront(col3, 6) from array_test;
  9. +-----------+----------------------------+
  10. | col3      | array_pushfront(`col3`, 6) |
  11. +-----------+----------------------------+
  12. | [3, 4, 5] | [6, 3, 4, 5]               |
  13. | [NULL]    | [6, NULL]                  |
  14. | NULL      | NULL                       |
  15. | []        | [6]                        |
  16. +-----------+----------------------------+
  18. mysql> select col1, col3, array_pushfront(col3, col1) from array_test;
  19. +------+-----------+---------------------------------+
  20. | col1 | col3      | array_pushfront(`col3`, `col1`) |
  21. +------+-----------+---------------------------------+
  22. |    0 | [3, 4, 5] | [0, 3, 4, 5]                    |
  23. |    1 | [NULL]    | [1, NULL]                       |
  24. |    2 | NULL      | NULL                            |
  25. |    3 | []        | [3]                             |
  26. +------+-----------+---------------------------------+

keywords

ARRAY,PUSHFRONT,ARRAY_PUSHFRONT