array_popback

SinceVersion 1.2.0

array_popback

description

Syntax

  1. ARRAY<T> array_popback(ARRAY<T> arr)

Remove the last element from array.

notice

Only supported in vectorized engine

example

  1. mysql> set enable_vectorized_engine=true;
  2. mysql> select array_popback(['test', NULL, 'value']);
  3. +-----------------------------------------------------+
  4. | array_popback(ARRAY('test', NULL, 'value')) |
  5. +-----------------------------------------------------+
  6. | [test, NULL] |
  7. +-----------------------------------------------------+

keywords

ARRAY,POPBACK,ARRAY_POPBACK