Quick Ref.
Compatibility
s1 || s2
Engine OK Alternative
ingres yes
mysql no CONCAT(s1, s2)
oracle yes
postgres yes
sqlserver no s1+s2

|| (strings)

|| allows you to stick two or more strings together.

This operation is concatenation.

 s1 || s2 

In this example you put the region and the name together for each country.

In MySQL the || is used for logical OR.


Results
See also: