or 条件查询时,后面的条件默认为 or ( );
如 select * from user where name ='张三' or name ='李四' and age >18
执行时变为: select * from user where name ='张三' or (name ='李四' and age >18)
数据库查询 where 中or条件导致结果不准确or 条件查询时,后面的条件默认为 or ( );如 select * from user where name ='张三' or name ='李四' and age >18 执行时变为: select * from user where name ='张三' or (name ='李四' and age >18)...