字符串运算符
运算符 ||
运算符 || 用于字符串连接,|| 左右都是字符串类型。
示例
SELECT customer_name,
customer_name || 'name',
'str1' || 'str2',
'str' || Cast(100 AS VARCHAR)
FROM t_fact_customers
WHERE customer_id < 4;
+---------------+---------------+----------+--------+
| customer_name | _col1 | _col2 | _col3 |
+---------------+---------------+----------+--------+
| 王小二 | 王小二name | str1str2 | str100 |
| 李春梅 | 李春梅name | str1str2 | str100 |
| 张大山 | 张大山name | str1str2 | str100 |
+---------------+---------------+----------+--------+