Mysql 行转列,列转行
1,创建表初始化数据CREATE TABLE StudentScores (UserName varchar(20) DEFAULT NULL,Subject varchar(30) DEFAULT NULL,Score float DEFAULT NULL
) ENGINEInnoDB DEFAULT CHARSETutf8;
INSERT INTO StudentScores SELECT Nick, 语文, 80;
INSERT INTO StudentScores SELECT …