bitmap_remove

description

Syntax

BITMAP BITMAP_REMOVE(BITMAP bitmap, BIGINT input)

从Bitmap列中删除指定的值。

example

1. mysql [(none)]>select bitmap_to_string(bitmap_remove(bitmap_from_string('1, 2, 3'), 3)) res;
2. +------+
3. | res  |
4. +------+
5. | 1,2  |
6. +------+

8. mysql [(none)]>select bitmap_to_string(bitmap_remove(bitmap_from_string('1, 2, 3'), null)) res;
9. +------+
10. | res  |
11. +------+
12. | NULL |
13. +------+

keywords

1. BITMAP_REMOVE,BITMAP