MySQL实现pivot行转列

1.创建表： 

Create Table

CREATE TABLE `pivot` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `salary` double NOT NULL,   `year` varchar(4) NOT NULL,   `name` varchar(10) NOT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8

 2.插入数据：

insert into `pivot` (`id`, `salary`, `year`, `name`) values('1','100','2016','tom');
insert into `pivot` (`id`, `salary`, `year`, `name`) values('2','200','2017','tom');
insert into `pivot` (`id`, `salary`, `year`, `name`) values('3','300','2018','tom');
insert into `pivot` (`id`, `sala