56,938
社区成员




CREATE TABLE `test` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(10) default NULL,
`num` varchar(5) default NULL,
`year` varchar(5) default NULL,
`money` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
INSERT INTO `test` VALUES ('1', '张三', 'A0001', '2012', '1000');
INSERT INTO `test` VALUES ('2', '李四', 'A0002', '2012', '200');
INSERT INTO `test` VALUES ('3', '张三', 'A0001', '2013', '300');
INSERT INTO `test` VALUES ('4', '王五', 'A0003', '2013', '600');
INSERT INTO `test` VALUES ('5', '张三', 'A0001', '2014', '1500');
INSERT INTO `test` VALUES ('6', '王五', 'A0003', '2014', '2000');
INSERT INTO `test` VALUES ('7', '李四', 'A0002', '2014', '700');
name num year1 money1 year2 money2
张三 A0001 2012 1000 2013 300
李四 A0002 2012 200
王五 A0003 2013 600