优先级顺序 | 运算符 |
---|---|
1 | interval |
2 | binary , collate |
3 | ! |
4 | -(一元减号), ~ |
5 | ^ |
6 | *, / , DIV , % , MOD |
7 | -,+ |
8 | << , >> |
9 | & |
10 | | |
11 | = , <=> , >= , > , <= , < , <> , != , IS , LIKE , REGEXP , IN |
12 | BETWEEN , CASE , WHEN , THEN , ELSE |
13 | NOT |
14 | && , AND |
15 | || , OR , XOR |
16 | := |
mysql基本操作(三)-多表记录操作和运算符优先级
最新推荐文章于 2024-07-16 11:43:45 发布