bitmap_from_array

description

Syntax

BITMAP BITMAP_FROM_ARRAY(ARRAY input)

Convert a TINYINT/SMALLINT/INT/BIGINT array to a BITMAP When the input field is illegal, the result returns NULL

example

  1. mysql> select *, bitmap_to_string(bitmap_from_array(c_array)) from array_test;
  2. +------+-----------------------+------------------------------------------------+
  3. | id | c_array | bitmap_to_string(bitmap_from_array(`c_array`)) |
  4. +------+-----------------------+------------------------------------------------+
  5. | 1 | [NULL] | NULL |
  6. | 2 | [1, 2, 3, NULL] | NULL |
  7. | 2 | [1, 2, 3, -10] | NULL |
  8. | 3 | [1, 2, 3, 4, 5, 6, 7] | 1,2,3,4,5,6,7 |
  9. | 4 | [100, 200, 300, 300] | 100,200,300 |
  10. +------+-----------------------+------------------------------------------------+
  11. 5 rows in set (0.02 sec)

keywords

  1. BITMAP_FROM_ARRAY,BITMAP