Mysql中and和or同时出现时,and比or的优先级高,先执行and再执行or。
例:
select * from t where a=0 and b=0 or c=0 and d=0
执行顺序为
select * from t where (a=0 and b=0) or (c=0 and d=0)
Mysql中and和or同时出现时,and比or的优先级高,先执行and再执行or。
例:
select * from t where a=0 and b=0 or c=0 and d=0
执行顺序为
select * from t where (a=0 and b=0) or (c=0 and d=0)