十一、MySQL基础系列笔记之运算符

作者: 温新

分类: 【MySql】

阅读: 1686

时间: 2020-10-15 14:10:16

MySQL支持多种类型的运算符,主要包括算术运算符、比较运算符、逻辑运算符、位运算符。

算术运算符

MySQL算术运算符包括加减乘除和取余。需要注意的是,在除法与模运算中,如果除数为0,将是非法除数,返回结果为NULL。

<span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px"><span style="box-sizing: border-box;color: rgb(98, 151, 85) !important"># 除法运算中,分母为0,将返回NULL</span></span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">mysql> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">select</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">100</span> / <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> ,<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">100</span> % <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span>;</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+---------+---------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">| <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">100</span> / <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> | <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">100</span> % <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+---------+---------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">|    <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">NULL</span> |    <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">NULL</span> |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+---------+---------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px"><span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">row</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">in</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">set</span>, <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">2</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">warnings</span> (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0.00</span> sec)</span>

比较运算符

当使用SELECT语句查询时,MySQL允许用户对表达式的左操作符和右边操作符进行比较,比较结果为真,则返回1,为假则返回0,比较不确定的结果时返回NULL。

MySQL支持的比较运算符有=、<>/!=、<=>、<、<=、>、>=、BETWEEN、IN、IS NULL、IS NOT NULL、LIKE、REGEXP/RLIKE

比较运算符可以用于比较数字、字符串和表达式。数字作为浮点数比较,字符串不区分大小写的方式进行比较。

<span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px"><span style="box-sizing: border-box;color: rgb(98, 151, 85) !important"># 等于运算:相等返回1,反之0。NULL不能用于=比较</span></span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">mysql> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">select</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>=<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span>,<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>=<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>,<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">NULL</span>=<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">NULL</span>;</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+-----+-----+-----------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">| <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>=<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> | <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>=<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> | <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">NULL</span>=<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">NULL</span> |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+-----+-----+-----------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">|   <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> |   <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> |      <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">NULL</span> |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+-----+-----+-----------+</span>

<、<=、>、>=、between、in这些返回结果都一样,相等返回1,不相等返回0。

is null/is not null也是一样,值为null/not null返回1,返回返回0。

<span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">mysql> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">select</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">is</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span>,<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">is</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span>,<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">is</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">not</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span>,<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">is</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">not</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span>;</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+-----------+--------------+---------------+------------------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">| <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">is</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> | <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">is</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> | <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">is</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">not</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> | <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">is</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">not</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+-----------+--------------+---------------+------------------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">|         <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> |            <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> |             <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> |                <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+-----------+--------------+---------------+------------------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px"><span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">row</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">in</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">set</span> (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0.00</span> sec)</span>

like/regexp同理,就不写出来了。

逻辑运算符

逻辑运算符又称布尔运算符,用来确认表达式的真和假。MySQL支持四种逻辑运算符,not/!(逻辑非)、and/&&(逻辑与)、or/||(逻辑或)、xor(逻辑异或)。

逻辑非

当操作符为0(假),则返回1,否则返回0,如果是not null则返回null。

<span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">mysql> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">select</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">not</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> , <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">not</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>,<span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">not</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span>;</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+-------+-------+----------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">| <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">not</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> | <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">not</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> | <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">not</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+-------+-------+----------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">|     <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> |     <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> |     <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">NULL</span> |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+-------+-------+----------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px"><span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">row</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">in</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">set</span> (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0.00</span> sec)</span>

逻辑与

当所有操作数均为非零值并且不为NULL时,结果为1;当一个或多个操作数为0时,结果为0,操作数中有任何一个为NULL,返回NULL。

<span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">mysql> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">select</span> (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">and</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>),(<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">and</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>),(<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">and</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span>);</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+-----------+-----------+--------------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">| (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">and</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>) | (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">and</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>) | (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">and</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span>) |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+-----------+-----------+--------------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">|         <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> |         <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> |         <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">NULL</span> |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+-----------+-----------+--------------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px"><span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">row</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">in</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">set</span> (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0.00</span> sec)</span>

逻辑或

当两个操作数均为非NULL时,若任意一个为非零值,结果为1;当有一个操作数为NULL时,如另一个操作数为非零值,结果为1,否则结果为NULL,两个均为NULL,结果为NULL。

<span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">mysql> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">select</span> (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">or</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span>),(<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">or</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span>),(<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">or</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span>),(<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">or</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span>);</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+----------+----------+-------------+----------------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">| (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">or</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span>) | (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">or</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span>) | (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">or</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span>) | (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">or</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span>) |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+----------+----------+-------------+----------------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">|        <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> |        <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> |           <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> |           <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">NULL</span> |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+----------+----------+-------------+----------------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px"><span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">row</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">in</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">set</span> (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0.00</span> sec)</span>

逻辑异或

当任意一个操作数为NULL时,返回值为NULL;非NULL操作数,若两个逻辑真假值相异,则返回结果1,否则返回0。

<span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">mysql> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">select</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">xor</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>, <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">xor</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span>,<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">xor</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span>, <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">xor</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>,<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">xor</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span>;</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+---------+---------+---------+---------+------------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">| <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">xor</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> | <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">xor</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> | <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">xor</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> | <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">xor</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> | <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">null</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">xor</span> <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+---------+---------+---------+---------+------------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">|       <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> |       <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0</span> |       <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> |       <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> |       <span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">NULL</span> |</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px">+---------+---------+---------+---------+------------+</span><br></br><span style="box-sizing: border-box;color: rgb(171, 178, 191);padding-right: 0.1px"><span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">1</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">row</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">in</span> <span style="box-sizing: border-box;color: rgb(198, 120, 221) !important">set</span> (<span style="box-sizing: border-box;color: rgb(209, 154, 102) !important">0.00</span> sec)</span>

位运算符

位运算符是将给定的操作数转化为二进制后,对操作数每一位进行指定的逻辑运算,得到的二进制结果转换为十进制数后就是位运算的结果。

位运算符有&(位与)、|(位或)、^(位异或)、~(位取反)、>>(位右移)、<<(位左移)

我是小白,期待和优秀的你一起同行!

小白

2020年10月15日

请登录后再评论