- 当and 和 or 在一条句中,没有任何符号,例如:( ) ,那么语句先执行and 条件,再执行or 语句
例如: select * from product where pid=3 or pid = 2 AND market_price > 1399;
- 有括号的话,执行括号中的内容并且market_price>1390
例如:select * from product where (pid=3 or pid = 2) AND market_price > 1399;
例如: select * from product where pid=3 or pid = 2 AND market_price > 1399;
例如:select * from product where (pid=3 or pid = 2) AND market_price > 1399;
转载于:https://my.oschina.net/u/3351691/blog/858764