mysql 行转列统计_myql 行转列统计查询

1 原始数据

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

-- Table structure for `t_bm_repeat_purchase`

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

DROP TABLE IF EXISTS `t_bm_repeat_purchase`;

CREATE TABLE `t_bm_repeat_purchase` (

`months` int(2) DEFAULT NULL COMMENT '月份',

`total` bigint(21) NOT NULL DEFAULT '0' COMMENT '查询月份对应的下一个月后或几个月后的购买用户数',

`seq` bigint(20) DEFAULT NULL COMMENT '序列号',

`next_months` bigint(4) DEFAULT NULL COMMENT 'months 字段对应的第几个月后，1月后，2月后，3月后。。。'

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- Records of t_bm_repeat_purchase

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

INSERT INTO `t_bm_repeat_purchase` VALUES ('1', '1170', '2', '2');

INSERT INTO `t_bm_repeat_purchase` VALUES ('1', '2144', '2', '3');

INSERT INTO `t_bm_repeat_purchase` VALUES ('1', '1012', '2', '4');

INSERT INTO `t_bm_repeat_purchase` VALUES ('1', '873', '2', '5');

INSERT INTO `t_bm_repeat_purchase` VALUES ('1', '785', '2', '6');

INSERT INTO `t_bm_repeat_purchase` VALUES ('1', '1008', '2', '7');

INSERT INTO `t_bm_repeat_purchase` VALUES ('1', '773', '2', '8');

INSERT INTO `t_bm_repeat_purchase` VALUES ('2', '1446', '2', '3');

INSERT INTO `t_bm_repeat_purchase` VALUES ('2', '700', '2', '