- 在同时有and和or的查询句中, and 级别优先于 or 进行操作的
- 如果要改变这个优先级,避免出现歧义,在进行判断的条件要加上括号
比如:
SELECT r.* FROM rl_jr r WHERE r.isdelete = '0' and r.node = '0'
and r.appUser in ('402','403','404') or r.shUser = '400'
SELECT r.* FROM rl_jr r WHERE r.isdelete = '0' and r.node = '0'
and (r.appUser in ('402','403','404') or r.shUser = '400')
这两者的区别就是,()的使用