The following table lists all concatenation operators.
Concatenates two strings.
Based on the preceding description, the
|| operator can also be used as a logical OR operator. The semantic meaning of the operator is controlled by the SQL mode.
- If the SQL mode is
||is an operator that concatenates strings.
- If the SQL mode is not
||is a logical OR operator.