测试mysql中and和or的优先级比较
1.SELECT * FROM t_files
;
2.SELECT * FROM t_files
where parent_id = 0 and (file_type = 0 or file_type = 1);
3.SELECT * FROM t_files
where parent_id = 0 and file_type = 0 or file_type = 1;
4.SELECT * FROM t_files
where file_type = 0 or file_type = 1 and parent_id = 0 ;
5.SELECT * FROM t_files
where file_type = 0;
通过测试:发现and和or的优先级,在没小括号的条件下and会将and前后的条件关联起来进行合并判断结果。可以对比3和4的结果。