现在有一张表
id jdid kfjg msj 门市价 psj 平时价 zmj 周末价 qssj 起始时间
31 26 0 1234 150 150 1262275200
32 26 0 1234 148 148 1262275200
33 26 0 1234 188 188 1262275200
34 26 0 1234 168 168 1262275200
113 26 0 400 100 100 1272729600
114 26 0 99 99 99 1274630400
115 26 0 88 88 88 1274716800
116 26 0 100 1001 1001 1274544000
数据如下
CREATE TABLE IF NOT EXISTS `gm_homtel_price` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`jdid` int(8) DEFAULT '0',
`kfjg` int(8) DEFAULT '0',
`msj` int(8) DEFAULT '0' COMMENT '门市价',
`psj` int(8) DEFAULT '0' COMMENT '平时价',
`zmj` int(8) DEFAULT '0' COMMENT '周末价',
`qssj` int(10) DEFAULT '0' COMMENT '起始时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='酒店价格' AUTO_INCREMENT=117 ;
--
-- 转存表中的数据 `gm_homtel_price`
--
INSERT INTO `gm_homtel_price` (`id`, `jdid`, `kfjg`, `msj`, `psj`, `zmj`, `qssj`) VALUES
(31, 26, 0, 1234, 150, 150, 1262275200),
(32, 26, 0, 1234, 148, 148, 1262275200),
(33, 26, 0, 1234, 188, 188, 1262275200),
(34, 26, 0, 1234, 168, 168, 1262275200),
(113, 26, 0, 400, 100, 100, 1272729600),
(114, 26, 0, 99, 99, 99, 127463
