@
liangliang CREATE TABLE `weather` (
`cityid` varchar(255) NOT NULL,
`city` varchar(255) NOT NULL,
`temp1` varchar(255) NOT NULL,
`temp2` varchar(255) NOT NULL,
`temp3` varchar(255) NOT NULL,
`temp4` varchar(255) NOT NULL,
`temp5` varchar(255) NOT NULL,
`temp6` varchar(255) NOT NULL,
`img1` varchar(255) NOT NULL,
`img2` varchar(255) NOT NULL,
`img3` varchar(255) NOT NULL,
`img6` varchar(255) NOT NULL,
`img5` varchar(255) NOT NULL,
`img4` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `weather` (`cityid`, `city`, `temp1`, `temp2`, `temp3`, `temp4`, `temp5`, `temp6`, `img1`, `img2`, `img3`, `img6`, `img5`, `img4`) VALUES
('101330101', 'macao', '27℃~33℃', '28℃~33℃', '29℃~34℃', '27℃~33℃', '27℃~32℃', '26℃~30℃', '3', '0', '0', '8', '3', '1'),
('101010100', 'beijing', '23℃~34℃', '24℃~35℃', '24℃~34℃', '24℃~30℃', '23℃~32℃', '23℃~33℃', '3', '0', '0', '4', '1', '4'),
('101020100', 'shanghai', '31℃~40℃', '30℃~39℃', '30℃~38℃', '29℃~37℃', '29℃~37℃', '29℃~37℃', '0', '0', '0', '0', '0', '0'),
('101280101', 'guangzhou', '25℃~34℃', '25℃~34℃', '25℃~35℃', '25℃~33℃', '25℃~33℃', '25℃~33℃', '0', '0', '0', '4', '4', '0'),
('101230201', 'xiamen', '26℃~35℃', '26℃~35℃', '26℃~33℃', '26℃~32℃', '26℃~32℃', '25℃~31℃', '1', '1', '1', '1', '1', '1'),
('101210101', 'hangzhou', '30℃~40℃', '27℃~40℃', '29℃~39℃', '29℃~38℃', '29℃~39℃', '29℃~38℃', '0', '0', '0', '1', '0', '0'),
('101270101', 'chengdu', '21℃~28℃', '22℃~33℃', '23℃~33℃', '24℃~33℃', '24℃~33℃', '23℃~32℃', '8', '1', '1', '3', '3', '3'),
('101280601', 'shenzhen', '27℃~32℃', '27℃~32℃', '27℃~33℃', '27℃~33℃', '27℃~33℃', '26℃~32℃', '1', '3', '1', '3', '3', '3'),
('101250101', 'changsha', '30℃~39℃', '30℃~39℃', '30℃~39℃', '30℃~38℃', '30℃~38℃', '29℃~38℃', '0', '0', '0', '1', '1', '0'),
('101110101', 'xian', '22℃~28℃', '22℃~32℃', '23℃~34℃', '24℃~34℃', '23℃~35℃', '24℃~35℃', '8', '2', '1', '1', '1', '1'),
('101050101', 'haerbin', '22℃~30℃', '21℃~30℃', '20℃~30℃', '20℃~31℃', '22℃~29℃', '22℃~30℃', '4', '1', '0', '1', '4', '0'),
('101320101', 'hongkong', '27℃~33℃', '28℃~32℃', '29℃~33℃', '27℃~33℃', '27℃~32℃', '26℃~29℃', '1', '0', '0', '8', '3', '1'),
('101340102', 'taoyuan', '27℃~36℃', '27℃~36℃', '26℃~36℃', '26℃~36℃', '27℃~36℃', '26℃~36℃', '1', '0', '1', '2', '7', '7');
我自己写了个.
说真的...你的文档写的真烂啊...cityid跟city还对不起来...还debug了一次才正常起来...