mysql中的列转行操作示例和带统计的列转行统计

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 grade ;