CONCAT:
CONCAT(string1,string2,…)
SELECT CONCAT(id,name) from users;
//返回数据
[
01zhang
02li
]
CONCAT_WS:
CONCAT_WS(separator,str1,str2,...)
select concat_ws('-',id,name) from users;
//返回数据
[
01-zhang
02-li
]
GROUP_CONCAT:
group_concat([DISTINCT] 要连接的字段 [Order BY ASC/DESC 排序字段] [Separator '分隔符'])
select group_concat(id,'-',name separator ";") from users;//默认逗号分隔
//返回数据
[
1-zhang;2-yang;3-li
]