a | b |
0 | 1 |
0 | 2 |
0 | 3 |
1 | 4 |
1 | 5 |
1 | 6 |
上面是数据库test里的数据
第一条SQL :select * from kk where a = 0 or a = 1 and c = 2;
结果为:
a | b |
0 | 1 |
0 | 2 |
0 | 3 |
第二条SQL : select * from c = 2 and a = 1 or a = 0
结果与上面相同
由此可见先执行的是AND,即AND优先级大于OR。
优先级:NOT > AND > OR