mysql 怎么行列互换_MySQL开发技巧之如何进行行列转换

现在以 学生表student、科目表course 、成绩表 score 来说明如何进行列转行以及行转列

CREATE TABLE student(

stu_uid INT UNSIGNED auto_increment NOT NULL PRIMARY KEY,

stu_name varchar(10) NOT NULL

);

CREATE TABLE course(

course_uid INT UNSIGNED auto_increment NOT NULL PRIMARY KEY,

course_name varchar(10) NOT NULL

);

CREATE TABLE score(

score_uid INT UNSIGNED auto_increment NOT NULL PRIMARY KEY,

stu_uid INT UNSIGNED NOT NULL,

course_uid INT UNSIGNED NOT NULL,

score INT UNSIGNED NOT NULL

);

往这三张表插入数据

INSERT INTO student(stu_name)VALUES('张三'),('王五'),('李四');

INSERT INTO course (course_name)VALUES('语文'),('数学'),('英语');

INSERT INTO score(stu_uid,course_uid,score)VALUES(1,1,70),(1,2,80),(1,3,88),(2,1,78),(2,2,90),(2,3,70),(3,1,88),(3,2,99),(3,3,85);