u014517021的博客

原创 关系运算符：or、and的优先级问题

and的优先级大于or如：①select * from tablename where condition1 or condition2 and condition3其实相当于select * from tablename where condition1 or (condition2 and condition3)②select * from tablename