concat(field1,field2):字符串拼接
SELECT id,concat(number,‘ - ‘,case statu when 1 then ‘测试‘ when 1 then ‘正式‘ else ‘未启用‘ end,‘ -#‘,name,‘#‘) FROM `t_version` where vid=5;
concat_ws(‘,‘,field1,field2):字符串拼接
SELECT id,concat_ws(‘#‘,id,name) FROM `t_version` where vid=5;
group_concat(field1):字段值拼接成字符串
SELECT id,group_concat(id) FROM `t_version` where vid=5;