Difference between revisions of "+ (string)"
Line 4: | Line 4: | ||
<tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr> | <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr> | ||
<tr><td align='left'>ingres</td><td>Yes</td><td></td></tr> | <tr><td align='left'>ingres</td><td>Yes</td><td></td></tr> | ||
− | <tr><td align='left'>mysql</td><td>No</td><td>CONCAT(s1,s2)</td></tr> | + | <tr><td align='left'>mysql</td><td>No</td><td>[[CONCAT | CONCAT(s1,s2)]]</td></tr> |
<tr><td align='left'>oracle</td><td>No</td><td>s1 || s2</td></tr> | <tr><td align='left'>oracle</td><td>No</td><td>s1 || s2</td></tr> | ||
<tr><td align='left'>postgres</td><td>No</td><td>s1 || s2</td></tr> | <tr><td align='left'>postgres</td><td>No</td><td>s1 || s2</td></tr> |
Latest revision as of 17:21, 21 October 2012
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 |
---|