mysql 支持的逻辑匹配_逻辑匹配

逻辑匹配

多个判断条件时使用

or 或

and 与

！或 not 非

( ) 提高优先级

mysql> select name,uid,shell from user

-> where

-> name="root" and uid=1 and shell="/bin/bash";

Empty set (0.00 sec)

mysql> select name,uid,shell from user where name="root" or uid=1 or shell="/bin/bash";

+------+------+---------------+

| name | uid | shell |

+------+------+---------------+

| root | 0 | /bin/bash |

| bin | 1 | /sbin/nologin |

| lisi | 1000 | /bin/bash |

| bob | 3001 | /bin/bash |

+------+------+---------------+

mysql> select name from user where name="root";

+------+

| name |

+------+

| root |

+------+

mysql> select name from user where name is null;

Empty set (0.00 sec)

mysql> select name from user where name is not null;

+---------------------+

| name |

+---------------------+

| root |

... ...