外观
运算符优先级
运算符优先级如下表。
| 优先级 | 符号 |
|---|---|
| 1 | ! |
| 2 | ~ |
| 3 | ^ |
| 4 | *,/,DIV,%,MOD |
| 5 | +,- |
| 6 | >>,<< |
| 7 | & |
| 8 | | |
| 9 | =,<=>,>,>=,<,<=,!=,<>,IN,IS,NULL.LIKE,REGEXP |
| 10 | BETWEEN,AND,CASE,WHEN,THEN,ELSE |
| 11 | NOT |
| 12 | &&,AND |
| 13 | ||,OR,XOR |
| 14 | := |
外观
运算符优先级如下表。
| 优先级 | 符号 |
|---|---|
| 1 | ! |
| 2 | ~ |
| 3 | ^ |
| 4 | *,/,DIV,%,MOD |
| 5 | +,- |
| 6 | >>,<< |
| 7 | & |
| 8 | | |
| 9 | =,<=>,>,>=,<,<=,!=,<>,IN,IS,NULL.LIKE,REGEXP |
| 10 | BETWEEN,AND,CASE,WHEN,THEN,ELSE |
| 11 | NOT |
| 12 | &&,AND |
| 13 | ||,OR,XOR |
| 14 | := |