Mysql位运算符实战

墨蓝 2021-07-25 02:31 542阅读 0赞

**一 使用位或运算符进行运算**

mysql> SELECT 10 | 15, 9 | 4 | 2;
    +---------+-----------+
    | 10 | 15 | 9 | 4 | 2 |
    +---------+-----------+
    |      15 |        15 |
    +---------+-----------+
    1 row in set (0.00 sec)

**二 使用位与运算符进行运算**

mysql> SELECT 10 & 15, 9 &4& 2;
    +---------+---------+
    | 10 & 15 | 9 &4& 2 |
    +---------+---------+
    |      10 |       0 |
    +---------+---------+
    1 row in set (0.00 sec)

**三 使用位异或运算符进行运算**

mysql> SELECT 10 ^ 15, 1 ^0, 1 ^ 1;
    +---------+------+-------+
    | 10 ^ 15 | 1 ^0 | 1 ^ 1 |
    +---------+------+-------+
    |       5 |    1 |     0 |
    +---------+------+-------+
    1 row in set (0.00 sec)

**四 使用位左移运算符进行运算**

mysql> SELECT 1<<2, 4<<2;
    +------+------+
    | 1<<2 | 4<<2 |
    +------+------+
    |    4 |   16 |
    +------+------+
    1 row in set (0.00 sec)

**五 使用位右移运算符进行运算**

mysql> SELECT 1>>1, 16>>2;
    +------+-------+
    | 1>>1 | 16>>2 |
    +------+-------+
    |    0 |     4 |
    +------+-------+
    1 row in set (0.00 sec)

**六 使用位取反运算符进行运算**

mysql> SELECT 5 & ~1;
    +--------+
    | 5 & ~1 |
    +--------+
    |      4 |
    +--------+
    1 row in set (0.00 sec)
    
    mysql> select BIN(~1);
    +------------------------------------------------------------------+
    | BIN(~1)                                                          |
    +------------------------------------------------------------------+
    | 1111111111111111111111111111111111111111111111111111111111111110 |
    +------------------------------------------------------------------+
    1 row in set (0.00 sec)