天气数据大全（ORACLE版），使用SQL语句自建天气数据表

最新推荐文章于 2022-04-25 21:27:00 发布
最新推荐文章于 2022-04-25 21:27:00 发布
阅读量1.8k 收藏 1
点赞数
文章标签： 天气 数据 oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hu3971898/article/details/35987691
版权

首先，创建表：

create table WEATHER(weatherindex varchar2(10),cityCode varchar2(20),cityName varchar2(50));

其次，插入多条数据：

INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(1, '101010100', '北京');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(2, '101010200', '海淀');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(3, '101010400', '顺义');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(4, '101010500', '怀柔');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(5, '101010600', '通州');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(6, '101010700', '昌平');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(7, '101010800', '延庆');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(8, '101010900', '丰台');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(9, '101011000', '石景山');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(10, '101011100', '大兴');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(11, '101011200', '房山');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(12, '101011300', '密云');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(13, '101011400', '门头沟');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(14, '101011500', '平谷');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(15, '101020100', '上海');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(16, '101020200', '闵行');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(17, '101020300', '宝山');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(18, '101020500', '嘉定');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(19, '101020600', '浦东南汇');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(20, '101020700', '金山');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(21, '101020800', '青浦');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(22, '101020900', '松江');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(23, '101021000', '奉贤');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(24, '101021100', '崇明');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(25, '101021300', '浦东');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(26, '101030100', '天津');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(27, '101030200', '武清');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(28, '101030300', '宝坻');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(29, '101030400', '东丽');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(30, '101030500', '西青');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(31, '101030600', '北辰');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(32, '101030700', '宁河');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(33, '101030800', '汉沽');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(34, '101030900', '静海');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(35, '101031000', '津南');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(36, '101031100', '塘沽');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(37, '101031200', '大港');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(38, '101031400', '蓟县');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(39, '101040100', '重庆');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(40, '101040200', '永川');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(41, '101040300', '合川');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(42, '101040400', '南川');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(43, '101040500', '江津');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(44, '101040600', '万盛');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(45, '101040700', '渝北');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(46, '101040800', '北碚');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(47, '101041000', '长寿');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(48, '101041100', '黔江');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(49, '101041300', '万州');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(50, '101041400', '涪陵');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(51, '101041500', '开县');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(52, '101041600', '城口');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(53, '101041700', '云阳');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(54, '101041800', '巫溪');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(55, '101041900', '奉节');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(56, '101042000', '巫山');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(57, '101042100', '潼南');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(58, '101042200', '垫江');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(59, '101042300', '梁平');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(60, '101042400', '忠县');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(61, '101042500', '石柱');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(62, '101042600', '大足');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(63, '101042700', '荣昌');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(64, '101042800', '铜梁');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(65, '101042900', '璧山');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(66, '101043000', '丰都');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(67, '101043100', '武隆');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(68, '101043200', '彭水');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(69, '101043300', '綦江');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(70, '101043400', '酉阳');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(71, '101043600', '秀山');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(72, '101050101', '哈尔滨');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(73, '101050102', '双城');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(74, '101050103', '呼兰');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(75, '101050104', '阿城');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(76, '101050105', '宾县');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(77, '101050106', '依兰');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(78, '101050107', '巴彦');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(79, '101050108', '通河');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(80, '101050109', '方正');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(81, '101050110', '延寿');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(82, '101050111', '尚志');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(83, '101050112', '五常');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(84, '101050113', '木兰');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(85, '101050201', '齐齐哈尔');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(86, '101050202', '讷河');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(87, '101050203', '龙江');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(88, '101050204', '甘南');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(89, '101050205', '富裕');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(90, '101050206', '依安');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(91, '101050207', '拜泉');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(92, '101050208', '克山');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(93, '101050209', '克东');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(94, '101050210', '泰来');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(95, '101050301', '牡丹江');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(96, '101050302', '海林');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(97, '101050303', '穆棱');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(98, '101050304', '林口');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(99, '101050305', '绥芬河');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(100, '101050306', '宁安');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(101, '101050307', '东宁');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(102, '101050401', '佳木斯');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(103, '101050402', '汤原');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(104, '101050403', '抚远');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(105, '101050404', '桦川');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(106, '101050405', '桦南');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(107, '101050406', '同江');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(305, '101080807', '乌后');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(306, '101080810', '杭锦后');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(307, '101080901', '锡林浩特');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(308, '101080903', '二连浩特');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(309, '101080904', '阿巴嘎');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(633, '101110506', '富平');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(634, '101110507', '蒲城');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(635, '101110508', '澄城');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(636, '101110509', '合阳');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(637, '101110510', '韩城');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(638, '101110511', '华阴');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(639, '101110601', '商洛');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(640, '101110602', '洛南');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(641, '101110603', '柞水');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(642, '101110604', '商州');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(643, '101110605', '镇安');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(644, '101110606', '丹凤');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(645, '101110607', '商南');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(646, '101110608', '山阳');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(647, '101110701', '安康');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(648, '101110702', '紫阳');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(649, '101110703', '石泉');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(650, '101110704', '汉阴');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(651, '101110705', '旬阳');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(652, '101110706', '岚皋');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(653, '101110707', '平利');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(654, '101110708', '白河');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(655, '101110709', '镇坪');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(656, '101110710', '宁陕');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(657, '101110801', '汉中');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(658, '101110802', '略阳');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(659, '101110803', '勉县');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(660, '101110804', '留坝');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(661, '101110805', '洋县');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(662, '101110806', '城固');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(663, '101110807', '西乡');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(664, '101110808', '佛坪');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(665, '101110809', '宁强');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(666, '101110810', '南郑');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(667, '101110811', '镇巴');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(668, '101110901', '宝鸡');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(669, '101110903', '千阳');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(670, '101110904', '麟游');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(671, '101110905', '岐山');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(672, '101110906', '凤翔');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(673, '101110907', '扶风');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(674, '101110908', '眉县');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(675, '101110909', '太白');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(676, '101110910', '凤县');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(677, '101110911', '陇县');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(678, '101111001', '铜川');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(679, '101111003', '宜君');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(680, '101111101', '杨凌');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(681, '101120101', '济南');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(682, '101120103', '商河');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(683, '101120104', '章丘');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(684, '101120105', '平阴');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(685, '101120106', '济阳');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(686, '101120201', '青岛');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(687, '101120204', '即墨');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(688, '101120205', '胶州');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(689, '101120206', '胶南');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(690, '101120207', '莱西');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(691, '101120208', '平度');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(692, '101120301', '淄博');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(693, '101120304', '高青');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(694, '101120306', '沂源');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(695, '101120307', '桓台');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(696, '101120401', '德州');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(697, '101120402', '武城');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(698, '101120403', '临邑');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(699, '101120404', '陵县');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(700, '101120405', '齐河');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(701, '101120406', '乐陵');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(702, '101120407', '庆云');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(703, '101120408', '平原');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(704, '101120409', '宁津');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(705, '101120410', '夏津');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(706, '101120411', '禹城');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(707, '101120501', '烟台');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(708, '101120502', '莱州');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(709, '101120503', '长岛');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(710, '101120504', '蓬莱');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(711, '101120505', '龙口');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(712, '101120506', '招远');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(713, '101120507', '栖霞');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(714, '101120510', '莱阳');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(715, '101120511', '海阳');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(716, '101120601', '潍坊');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(717, '101120602', '青州');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(718, '101120603', '寿光');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(719, '101120604', '临朐');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(720, '101120605', '昌乐');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(721, '101120606', '昌邑');
INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(722, '101120607', '安丘');

在ORACLE中执行上述sql语句既可以创建表和插入数据了，全部数据2500条，这里显示了部分；全贴出来有点浪费空间，这里仅做展示；

链接在此：http://download.csdn.net/detail/hu3971898/7570955

凡人胡大仙
关注
天气预报所有城市代码数据库（SQL）
11-12
天气预报所有城市代码数据库（SQL）,新建城市表city_code,字段：province 省,city市,area地区,city_code城市代码，直接在数据库工具里执行就可以生成数据.
基于mysql数据库的天气查询系统
03-26
适合大学生写项目实训，从底层了解怎么写，之后可以采取ssm框架写。后台能实现数据库的增删改查，能够发布当日天气，能及时更改天气状况，能增加、删除、修改日期，还能实现用户修改信息、用户查询天气等功能。数据库选择的是MySql技术，用Navicat for MySQL来管理数据库，通过MySql技术，使界面连接至数据库中，用户可以使用登录注册等功能。而管理员可以对用户数据，资料数据进行动态的管理。 开发工具选择的是IDEA2020版本。 发布工具使用的是Tomcat9.0.38版本。 私信还可提供实训文档
城市表的sql文件(天气,pm2.5所用)
05-15
城市表的sql文件,如('101010100','beijing','北京','beijing','北京','China','中国','beijing','北京','39.904989','116.405285')
天气sql数据库，实验测试可用
05-14
天气sql数据库，实验测试可用
天气数据处理
qq_51641196的博客
04-25 447
1.site_code 取前五位(因为是先用文件名作为site_code,然后从文件名中截取前五位即为site_code)(图上错了,图上取得是6位,但是懒得在找一遍截图了)2.存储过程+游标对数据进行处理(1)缺失数据(-9999)置为一个大概值(2)将10比例的数据除以10,例如温度220→22(好家伙,处理了一下午)3.删除列游标更新的时候忘了sky和wind_direction了,这两列...
oracle求每天的最大值,sql语句查询每天数据中的最大值
weixin_32820311的博客
04-04 1046
案例：创建天气小时表和天气日期表create table dbo.T_WeatherStreetDataHourly (ID bigint identity(1, 1),DDATETIME datetime not null,OBTID nvarchar(50...
天气数据库 ORACLE
06-30
根据文档说明，先用oracle中的sql语句创建表；然后向表中插入数据；
【python爬虫】爬取全国天气数据并存入数据库
qq_45707085的博客
04-17 4204
提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档 文章目录前言一、导包二、代码1.连接数据库2.爬虫总结最后 前言 爬取的网站：http://www.weather.com.cn/textFC 采用BeautifulSoup库爬取数据和pymysql导入数据库 一、导包 import requests from bs4 import BeautifulSoup import pymysql 二、代码 1.连接数据库 代码如下（示例）： conn = pymysql.connect(h.
基于ORACLE的陇东南区域自动气象站数据库设计及应用.pdf
10-09
标题“基于ORACLE的陇东南区域自动气象站数据库设计及应用”和描述中提及的内容围绕着数据库设计、SQL语句优化以及ORACLE数据库在气象领域的应用等多个IT知识点展开。本篇论文详细阐述了为适应区域自动气象站数据的...
sql基础大全
05-10
11. **存储过程PROCEDURE**和函数FUNCTION**：预编译的SQL语句集合，可重复使用，提高效率。函数返回值，而存储过程不一定要返回。 12. **触发器TRIGGER**：在特定数据库操作（如INSERT、UPDATE、DELETE）发生时...
天气城市列表
02-26
墨迹天气选择的城市列表，包含城市ID以及城市天气ID，精细到各个区。
城市名对应城市代码表sql，用于天气查询等
09-30
城市名对应城市代码表sql，用于天气查询等，包含省份、城市、地区对应的城市代码，2000多条数据
SQL分组处理气象数据及注意事项
「 刘一哥与GIS的故事」
12-10 2195
问题：从全国所有气象站点数据气候数据表中（温度，降水量，风速等）找出研究区气象站点及所需气象信息。 解决： select 台站号 as 台站号,年 as 年,降水量 as 降水量,平均气温 as 年均温 from 站点气候年数据 where 台站号 in (select 台站号 from 研究区站点 ) and 年 in(select distinct(年) from 研究区站点) gr
气象用sql语句搜寻极大值等（期待更优语句）
weixin_30439031的博客
05-15 185
--最高温度 最高温度出现时间 最低温度 最低温度出现时间select top 1 BCMX,BCMXT from F7471DataTable where bcmx=(select MAX(BCMX) from F7471DataTable where area_Code=1 and (Area_Date between '2015-05-14 08:00:00' and '2015-05-15...
天气预报查询网开发总结数据库模块篇[含建表源代码]
fish747的专栏
05-20 461
                   开始之前大家先看看网站 , 可以查询 5 天， 7 天， 10 天，一周的天气预报查询网 使用的数据库是 MySQL5.1 ， 使用的表引擎是 MyISAM ，理由是目前只是用来存储省份 id ，城市 id...
python爬取综合信息需要的数据库表以及天气配置表
qq_48663998的博客
06-19 288
python爬取综合信息需要的数据库表已经天气配置表 天气表 SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; – Table structure for weather DROP TABLE IF EXISTS weather; CREATE TABLE weather ( weather_id int(0) NOT NULL AUTO_INCREMENT COMMENT ‘id’, province varchar(255) CHARACTER SET
R语音 rvest爬取中国天气网所有城市未来七天天气数据并写入oracle数据库
yepeng2007fei的博客
01-04 945
本文使用R语音 rvest爬取中国天气网所有城市未来七天天气数据并写入oracle数据库，其中包括了如何使用R语言连接oracle数据库，以及爬取时候的简单策略，最后对爬取到的数据组装成数据框并写入数据库，可以作为R语音初中级爱好者们很好的参考例子，当然这是我很久前写的代码，很多地方没有进行优化，比如使用了for循环，其实应该封装到函数中使用sapply来处理循环以提高效率。感兴趣的朋友想与我交流
安卓学习专栏——实战项目酷欧天气（1）创建数据库和表
MZH
11-25 1431
实战项目酷欧天气（1）创建数据库和表
SQL Server 和 Oracle 数据类型及函数对照表
SQL Server 和 Oracle 数据类型对照 数据库管理系统中，数据类型是指数据的存储格式和结构。不同的数据库管理系统可能具有不同的数据类型，例如 SQL Server 和 Oracle。了解这些数据类型的对照关系对于数据迁移和...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值