array_popfront

SinceVersion 2.0

array_popfront

description

Syntax

ARRAY<T> array_popfront(ARRAY<T> arr)

Remove the first element from array.

notice

Only supported in vectorized engine

example

1. mysql> set enable_vectorized_engine=true;

3. mysql> select array_popfront(['test', NULL, 'value']);
4. +-----------------------------------------------------+
5. | array_popfront(ARRAY('test', NULL, 'value'))        |
6. +-----------------------------------------------------+
7. | [NULL, value]                                       |
8. +-----------------------------------------------------+

keywords

ARRAY,POPFRONT,ARRAY_POPFRONT