1.concat
select concat("http://",host,":",port) from hostInfo
2.concat_ws concat with seperator
select concat("|", f1,f2 ) from table
3.group_concat group by 的加强版
select age, group_concat(name) from student_info group by age;
参见
1.concat
select concat("http://",host,":",port) from hostInfo
2.concat_ws concat with seperator
select concat("|", f1,f2 ) from table
3.group_concat group by 的加强版
select age, group_concat(name) from student_info group by age;
参见