mysql groupby 拼接_mysql groupby 和 group_concat的妙用

具体sql 例子比较简单无意义关键是把问题说清楚。

SQL语句：SELECT GROUP_CONCAT(name) as '详情' from students GROUP BY sexy;

查询结果是：

数据：

/*

Navicat MySQL Data Transfer

Source Server : new Conection

Source Server Version : 50022

Source Host : localhost:3306

Source Database : fenye

Target Server Type : MYSQL

Target Server Version : 50022

File Encoding : 65001

Date: 2016-07-30 20:09:55

*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for `students`

-- ----------------------------

DROP TABLE IF EXISTS `students`;

CREATE TABLE `students` (

`id` int(11) NOT NULL auto_increment,

`name` varchar(255) default NULL,

`sexy` tinyint(1) default '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of students

-- ----------------------------

INSERT INTO `students` VALUES ('1', 'A', '1');

INSERT INTO `students` VALUES ('2', 'B', '1');

INSERT INTO `students` VALUES ('3', 'C', '1');

INSERT INTO `students` VALUES ('4', 'D', '1');

INSERT INTO `students` VALUES ('5', 'E', '1');

INSERT INTO `students` VALUES ('6', 'F', '1');

INSERT INTO `students` VALUES ('7', 'G', '1');

INSERT INTO `students` VALUES ('8', 'H', '1');

INSERT INTO `students` VALUES ('9', 'I', '0');

INSERT INTO `students` VALUES ('10', 'J', '0');

INSERT INTO `students` VALUES ('11', 'K', '0');

INSERT INTO `students` VALUES ('12', 'L', '0');

INSERT INTO `students` VALUES ('13', 'M', '0');

INSERT INTO `students` VALUES ('14', 'M', '0');

如有问题请留言，谢谢大家。