concat()

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)