优先级 运算符 (最高) ! -(负号),~(按位取反) ^(按位异或) *,/(DIV),%(MOD) +,- >>,<< & | =(比较运算),<=>,<,<=,>,>=,!=,<>,IN,IS NULL,LIKE,REGEXP BETWEEN AND,CASE,WHEN,THEN,ELSE NOT &&,AND XOR ||,OR
(最低) =(赋值运算),:=
MySQL运算符的优先级
最新推荐文章于 2023-08-06 20:00:42 发布
优先级 运算符 (最高) ! -(负号),~(按位取反) ^(按位异或) *,/(DIV),%(MOD) +,- >>,<< & | =(比较运算),<=>,<,<=,>,>=,!=,<>,IN,IS NULL,LIKE,REGEXP BETWEEN AND,CASE,WHEN,THEN,ELSE NOT &&,AND XOR ||,OR
(最低) =(赋值运算),:=