1、concat(str1,str2…)
将多个字符串连接成一个字符串
mysql> select concat("my "," sql") data;
+---------+
| data |
+---------+
| my sql |
+---------+
1 row in set (0.00 sec)
2、concat_ws(sep,str1,str2…)
它是特殊格式,第一个参数为字符串的连接符
mysql> select concat_ws(">>","my","home") data;
+----------+
| data |
+----------+
| my>>home |
+----------+
1 row in set (0.00 sec)