mysql基础逻辑运算 and 与

原创云散月明 All China Database Union 2021-04-22

501

OS : Ubuntu 18.04.1 LTS
DBMS : mysql 8.0.12

示例

stu@Ubuntu:~$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 51
Server version: 8.0.12 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use db_chinese_medicine;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from t_fruit;
+----+-----------+-------+--------+----------+------------------------------------+---------------------+---------------------+
| id | name      | count | price  | is_sales | note                               | gmt_create          | gmt_modified        |
+----+-----------+-------+--------+----------+------------------------------------+---------------------+---------------------+
|  1 | 甜瓜      |    10 |  3.210 |        1 | 无                                 | 2018-10-27 19:42:56 | 2018-10-27 19:42:56 |
|  2 | 乌梅      |    20 |  5.430 |        1 | 无                                 | 2018-10-27 19:46:21 | 2018-10-27 19:46:21 |
|  3 | 樱桃      |    30 |  6.540 |        1 | 无                                 | 2018-10-27 19:46:48 | 2018-10-27 19:46:48 |
|  4 | 甘蔗      |    50 |  7.650 |        0 | 无                                 | 2018-10-27 19:51:13 | 2018-10-27 19:51:13 |
|  5 | 菠萝蜜    |    50 |  8.760 |        1 | 菠萝蜜和菠萝是什么关系?            | 2018-10-27 19:55:44 | 2018-10-27 19:55:44 |
|  6 | 无花果    |   100 |  8.760 |        1 | 无                                 | 2018-10-27 19:57:48 | 2018-10-27 19:57:48 |
|  7 | 山葡萄    |   200 |  5.550 |        1 | 无                                 | 2018-10-27 20:11:07 | 2018-10-27 20:11:07 |
|  8 | 无漏子    |     5 |  3.320 |        0 | 无                                 | 2018-10-27 20:11:07 | 2018-10-27 20:11:07 |
|  9 | 五敛子    |    12 |  6.010 |        0 | 无                                 | 2018-10-27 20:11:07 | 2018-10-27 20:11:07 |
| 10 | 藕        |    80 | 10.200 |        0 | 无                                 | 2018-10-27 20:11:07 | 2018-10-27 20:11:07 |
| 11 | 栗        |     5 |  3.320 |        0 | NULL                               | 2018-10-27 20:24:01 | 2018-10-27 20:24:01 |
| 12 | 龙眼      |    49 |  6.540 |        0 | NULL                               | 2018-10-27 20:24:01 | 2018-10-27 20:24:01 |
| 13 | 楂子      |     0 |  8.100 |        0 | NULL                               | 2018-10-27 20:24:01 | 2018-10-27 20:24:01 |
+----+-----------+-------+--------+----------+------------------------------------+---------------------+---------------------+
13 rows in set (0.00 sec)

mysql> select * from t_fruit where (count > 50) and (is_sales = 1);
+----+-----------+-------+-------+----------+------+---------------------+---------------------+
| id | name      | count | price | is_sales | note | gmt_create          | gmt_modified        |
+----+-----------+-------+-------+----------+------+---------------------+---------------------+
|  6 | 无花果    |   100 | 8.760 |        1 | 无   | 2018-10-27 19:57:48 | 2018-10-27 19:57:48 |
|  7 | 山葡萄    |   200 | 5.550 |        1 | 无   | 2018-10-27 20:11:07 | 2018-10-27 20:11:07 |
+----+-----------+-------+-------+----------+------+---------------------+---------------------+
2 rows in set (0.00 sec)

mysql> exit
Bye
stu@Ubuntu:~$ 

复制