mysql学习笔记之bit_and和bit_or（2）

最新推荐文章于 2024-06-16 21:46:59 发布

CsongSY

最新推荐文章于 2024-06-16 21:46:59 发布

阅读量2.1k

点赞数 2

分类专栏： Mysql

本文链接：https://blog.csdn.net/cscscscsc/article/details/50437995

版权

Mysql 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

刚刚看了bit_or和bit_and的函数，这两个函数我觉得挺有用的。

mysql> use csong;
Database changed
mysql> create table csong_tab_1230(id int,customer_id int,kind int);
Query OK, 0 rows affected (0.16 sec)

mysql> insert into csong_tab_1230 values(1,1,5),(2,1,4),(3,2,3),(4,2,4);
Query OK, 4 rows affected (0.14 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from csong_tab_1230;
+------+-------------+------+
| id   | customer_id | kind |
+------+-------------+------+
|    1 |           1 |    5 |
|    2 |           1 |    4 |
|    3 |           2 |    3 |
|    4 |           2 |    4 |
+------+-------------+------+
4 rows in set (0.00 sec)

mysql> select customer_id,bit_or(kind) from csong_tab_1230 group by customer_id;
+-------------+--------------+
| customer_id | bit_or(kind) |
+-------------+--------------+
|        1 |        5 |
|        2 |        7 |
+-------------+--------------+
2 rows in set (0.00 sec)


mysql> select customer_id,bit_and(kind) from csong_tab_1230 group by customer_id;
+-------------+---------------+
| customer_id | bit_and(kind) |
+-------------+---------------+
|        1 |         4 |
|        2 |           0 |
+-------------+---------------+
2 rows in set (0.00 sec)