1、group by后字符串拼接:group_concat( [DISTINCT] 要连接的字段 [Order BY 排序字段 ASC/DESC] [Separator '分隔符'] )
2、查看数据库连接数:show status like 'Threads%';或show processlist;或select * from information_schema.processlist;