mysql中的列转行操作示例和带统计的列转行统计
首先建表并导入数据:
CREATE TABLE grade
(
studyCode
varchar(20) NOT NULL DEFAULT ‘’ COMMENT ‘学号’,
subjectS
varchar(20) NOT NULL,
score
int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO grade
VALUES (‘001’, ‘数学’, ‘120’);
INSERT INTO grade
VALUES (‘002’, ‘数学’, ‘130’);
INSERT INTO grade
VALUES (‘003’, ‘数学’, ‘125’);
INSERT INTO grade
VALUES (‘001’, ‘英语’, ‘130’);
INSERT INTO grade
VALUES (‘002’, ‘英语’, ‘140’);
INSERT INTO grade
VALUES (‘003’, ‘英语’, ‘135’);
INSERT INTO grade
VALUES (‘001’, ‘国学’, ‘110’);
INSERT INTO grade
VALUES (‘002’, ‘国学’, ‘136’);
INSERT INTO grade
VALUES (‘003’, ‘国学’, ‘145’);
数据如下:
SELECT * FROM