CREATE TABLE `user1` (

  `id` int(11) NOT NULL,

  `user_name` varchar(3) COLLATE utf8_bin NOT NULL,

  `over` varchar(5) COLLATE utf8_bin NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin

CREATE TABLE `user2` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `user_name` varchar(3) COLLATE utf8_bin NOT NULL,

  `over` varchar(5) COLLATE utf8_bin NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin

CREATE TABLE `user_kills` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `user_id` int(11) NOT NULL,

  `timestr` datetime NOT NULL,

  `kills` int(10) unsigned NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin

需要进行行转列的场景

需要转换的场景

MYSQL 行转列：

1）行行转列

show tables 展示表

行转列的场景

行转列

我们的例子