Dev/DB/SQL 基础
Source Edit History
字符串拼接
文章目录
点击这里访问站长的博客

例子1

MySQL/Oracle:

1
2
SELECT CONCAT(region_name,store_name) FROM Geography
WHERE store_name = 'Boston';

结果:

1
'EastBoston'

例子2

Oracle:

1
2
SELECT region_name || ' ' || store_name FROM Geography
WHERE store_name = 'Boston';

结果:

1
'East Boston'

例子3

SQL Server:

1
2
SELECT region_name + ' ' + store_name FROM Geography
WHERE store_name = 'Boston';

结果:

1
'East Boston'