- 1摄像头的3A算法概述_摄像头算法
- 2CentOS7安装最新版rabbitMQ(3.8.19)遇到的各种问题汇总_rabbitmq3.8.19源码安装
- 3Win10下安装大数据开发环境 spark+hadoop+hive（实测可用）_window hive hdfs spark 安装
- 4Java JVM分析利器JProfiler 结合IDEA使用详细教程_idea jprofiler教程
- 5线程共享内存及可能存在的问题
- 6开源模型应用落地-解锁大语言模型的无限潜能_chatglm3 批处理
- 7与 Apollo 共创生态：百度智能驾驶的展望与未来
- 8小米盒子4刷机armbian 系统
- 9头歌实验平台——树和二叉树试验_头歌educoder数据结构基于二叉链表的二叉树左右孩子的交换
- 10IntelliJ IDEA好用的几款插件_idea javadoc插件
mysql中括号的作用_括号()的作用
赞
踩
括号()的作用，先执行括号里面的命令，提高优先级
括号里面有"与"和"或"时，"与"优先。
and 与 (2者都要满足)
or 或 (满足其一即可)
mysql> select name,uid,gid from user
-> where name="bin";
+------+------+------+
| name | uid | gid |
+------+------+------+
| bin | 2 | 0 |
+------+------+------+
mysql> select name,(uid+gid)/2 as pjz from user where name="bin";
+------+--------+
| name | pjz |
+------+--------+
| bin | 1.0000 |
+------+--------+
mysql> select name,uid,gid,(uid+gid)/2 as pjz from user where name="bin";
+------+------+------+--------+
| name | uid | gid | pjz |
+------+------+------+--------+
| bin | 2 | 0 | 1.0000 |
+------+------+------+--------+
mysql> select name,uid from user
-> where
-> name="root" and id=1 or uid=2; 先找到name=root并且id=1的记录，然后再找到或者uid=2的记录
+------+------+
| name | uid |
+------+------+
| root | 1 |
| bin | 2 |
+------+------+
mysql> select name,uid from user where name="root" and (id=1 or uid=2); 先找到id=1或者uid=2的记录，然后再从找到的结果里，找到同时满足name=root的记录
+------+------+
| name | uid |
+------+------+
| root | 1 |
+------+------+
