+ (string)
From SQLZoo
s1 + s2 | ||
---|---|---|
Engine | OK | Alternative |
ingres | Yes | |
mysql | No | CONCAT(s1,s2) |
oracle | No | s1 || s2 |
postgres | No | s1 || s2 |
sqlserver | Yes |
+ (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.
SELECT CONCAT(region,name)
FROM bbc
SELECT region || name
FROM bbc
SELECT region + name
FROM bbc
See also
Language: | English • Deutsch |
---|