mysql拼接字段的函数_mysql拼接字符串

CREATE TABLE `user_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `age` int(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

select CONCAT(name,age) as result from user_info

result
Ana27
Ame24
Clid24
Dave24
Eva24

select CONCAT_WS(':',name,age) as result from user_info

result
Ana:27
Ame:24
Clid:24
Dave:24
Eva:24

select GROUP_CONCAT(name) as result from user_info

result
Ana,Ame,Clid,Dave,Eva

select GROUP_CONCAT(name) as result,age from user_info GROUP BY age

result 							age
Ame,Clid,Dave,Eva				24
Ana								27