1、
逻辑运算符:优先级为NOT、AND、OR
2、所有的运算符的整体排位
单目运算符、算术运算符、逻辑运算符、比较运算符、赋值运算符
3、
优先级 :=
||, OR, XOR
&&, AND
NOT
BETWEEN, CASE, WHEN, THEN, ELSE
=, <=>, >=, >, <=, <, <>, !=, IS, LIKE, REGEXP, IN
|
&
<<, >>
-, +
*, /, DIV, %, MOD
1、
逻辑运算符:优先级为NOT、AND、OR
2、所有的运算符的整体排位
单目运算符、算术运算符、逻辑运算符、比较运算符、赋值运算符
3、
优先级 :=
||, OR, XOR
&&, AND
NOT
BETWEEN, CASE, WHEN, THEN, ELSE
=, <=>, >=, >, <=, <, <>, !=, IS, LIKE, REGEXP, IN
|
&
<<, >>
-, +
*, /, DIV, %, MOD