具体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');
如有问题请留言,谢谢大家。