Mysql 行转列，列转行 SQL语句和示例表结构SQL

/* SQLyog Ultimate v12.09 (64 bit) MySQL - 5.6.26-log ********************************************************************* */ /*!40101 SET NAMES utf8 */; create table `test` ( `a` varchar (33), `b` varchar (33), `c` varchar (33), `d` varchar (33), `e` varchar (33), `date` varchar (33) ); insert into `test` (`a`, `b`, `c`, `d`, `e`, `date`) values('1','2','3','4','5','2018-04-01'); insert into `test` (`a`, `b`, `c`, `d`, `e`, `date`) values('1','2','3','4','5','2018-03-01'); insert into `test` (`a`, `b`, `c`, `d`, `e`, `date`) values('1','2','3','4','5','2018-02-01'); insert into `test` (`a`, `b`, `c`, `d`, `e`, `date`) values('1','2','3','4','5','2018-01-01'); insert into `test` (`a`, `b`, `c`, `d`, `e`, `date`) values('1','2','3','4','5','2018-05-01'); insert into `test` (`a`, `b`, `c`, `d`, `e`, `date`) values('1','2','3','4','5','2018-06-01'); insert into `test` (`a`, `b`, `c`, `d`, `e`, `date`) values('1','2','3','4','5','2018-07-01'); insert into `test` (`a`, `b`, `c`, `d`, `e`, `date`) values('1','2','3','4','5','2018-08-01'); insert into `test` (`a`, `b`, `c`, `d`, `e`, `date`) values('1','2','3','4','5','2018-09-01'); insert into `test` (`a`, `b`, `c`, `d`, `e`, `date`) values('1','2','3','4','5','2018-10-01'); insert into `test` (`a`, `b`, `c`, `d`, `e`, `date`) values('1','2','3','4','5','2018-11-01'); insert into `test` (`a`, `b`, `c`, `d`, `e`, `date`) values('1','2','3','4','5','2018-12-01');