表结构如图:怎么样才能变成这种结构: comp_name prod_id prod_name 2015-12-12 2015-12-13 .............................
jkw_price 10566 ........ 228 228
表SQL与数据如下:
DROP TABLE IF EXISTS `tab_kr_prod_price_day`;
CREATE TABLE `tab_kr_prod_price_day` (
`prod_id` varchar(20) DEFAULT NULL,
`prod_name` varchar(255) DEFAULT NULL,
`jkw_price` decimal(10,2) DEFAULT NULL,
`yyw_price` decimal(10,2) DEFAULT NULL,
`kad_price` decimal(10,2) DEFAULT NULL,
`kdl_price` decimal(10,2) DEFAULT NULL,
`jyw_price` decimal(10,2) DEFAULT NULL,
`lbx_price` decimal(10,2) DEFAULT NULL,
`ysk_price` decimal(10,2) DEFAULT NULL,
`yk_price` decimal(10,2) DEFAULT NULL,
`kzj_price` decimal(10,2) DEFAULT NULL,
`dateforprice` datetime DEFAULT NULL,
`tag` int(2) DEFAULT '0',
`updatetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '228.00', '2015-12-12 00:00:00', '2', '2015-12-22 11:00:00');
INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '228.00', '2015-12-13 00:00:00', '2', '2015-12-22 11:00:00');
INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '230.00', '2015-12-14 00:00:00', '2', '2015-12-22 11:00:00');
INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '230.00', '2015-12-15 00:00:00', '2', '2015-12-22 11:00:00');
INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '230.00', '2015-12-16 00:00:00', '2', '2015-12-22 11:00:00');
INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '230.00', '2015-12-17 00:00:00', '2', '2015-12-22 11:00:00');
INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '230.00', '2015-12-18 00:00:00', '1', '2015-12-22 11:00:00');
jkw_price 10566 ........ 228 228
表SQL与数据如下:
DROP TABLE IF EXISTS `tab_kr_prod_price_day`;
CREATE TABLE `tab_kr_prod_price_day` (
`prod_id` varchar(20) DEFAULT NULL,
`prod_name` varchar(255) DEFAULT NULL,
`jkw_price` decimal(10,2) DEFAULT NULL,
`yyw_price` decimal(10,2) DEFAULT NULL,
`kad_price` decimal(10,2) DEFAULT NULL,
`kdl_price` decimal(10,2) DEFAULT NULL,
`jyw_price` decimal(10,2) DEFAULT NULL,
`lbx_price` decimal(10,2) DEFAULT NULL,
`ysk_price` decimal(10,2) DEFAULT NULL,
`yk_price` decimal(10,2) DEFAULT NULL,
`kzj_price` decimal(10,2) DEFAULT NULL,
`dateforprice` datetime DEFAULT NULL,
`tag` int(2) DEFAULT '0',
`updatetime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '228.00', '2015-12-12 00:00:00', '2', '2015-12-22 11:00:00');
INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '228.00', '2015-12-13 00:00:00', '2', '2015-12-22 11:00:00');
INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '230.00', '2015-12-14 00:00:00', '2', '2015-12-22 11:00:00');
INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '230.00', '2015-12-15 00:00:00', '2', '2015-12-22 11:00:00');
INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '230.00', '2015-12-16 00:00:00', '2', '2015-12-22 11:00:00');
INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '230.00', '2015-12-17 00:00:00', '2', '2015-12-22 11:00:00');
INSERT INTO `tab_kr_prod_price_day` VALUES ('10566', '盐酸氟西汀胶囊(百优解)', '228.00', '228.00', '228.00', '248.00', '0.00', '0.00', '283.50', '0.00', '230.00', '2015-12-18 00:00:00', '1', '2015-12-22 11:00:00');
MySQL交叉表
在某些数据库中有交叉表,但在MySQL中却没有这个功能,但网上看到有不少朋友想找出一个解决方法,特发贴集思广义。http://topic.csdn.net/u/20090530/23/0b782674-4b0b-4cf5-bc1a-e8914aaee5ab.html?96198现整理解法如下:数据样本: create table tx( id int primary key, c1 c...