MySQL :: MySQL 8.4 Reference Manual :: 12.8.2 COLLATE Clause Precedence

version 8.4

8.0 current
5.7

8.0 Japanese

MySQL 8.4 Reference Manual / ... / COLLATE Clause Precedence

COLLATE 子句的优先级很高（比||高），因此以下两个表达式是等价的：

Press CTRL+C to copy
 
x || y COLLATE z
x || (y COLLATE z)

PREV HOME UP NEXT