www.pudn.com > WSMS.rar > insert.sql

--初始化cityinfo表 
insert into cityinfo(cityid,cityname) values('100001','北京'); 
insert into cityinfo(cityid,cityname) values('100002','天津'); 
insert into cityinfo(cityid,cityname) values('100003','太原'); 
insert into cityinfo(cityid,cityname) values('100004','石家庄'); 
insert into cityinfo(cityid,cityname) values('100005','济南'); 
insert into cityinfo(cityid,cityname) values('100006','青岛'); 
insert into cityinfo(cityid,cityname) values('100007','呼和浩特'); 
insert into cityinfo(cityid,cityname) values('100008','福州'); 
insert into cityinfo(cityid,cityname) values('100009','广州'); 
insert into cityinfo(cityid,cityname) values('100010','厦门'); 
insert into cityinfo(cityid,cityname) values('100011','南宁'); 
insert into cityinfo(cityid,cityname) values('100013','海口'); 
insert into cityinfo(cityid,cityname) values('100015','郑州'); 
insert into cityinfo(cityid,cityname) values('100016','武汉'); 
insert into cityinfo(cityid,cityname) values('100017','长沙'); 
insert into cityinfo(cityid,cityname) values('100018','南昌'); 
insert into cityinfo(cityid,cityname) values('100019','合肥'); 
insert into cityinfo(cityid,cityname) values('100020','上海'); 
insert into cityinfo(cityid,cityname) values('100021','南京'); 
insert into cityinfo(cityid,cityname) values('100024','杭州'); 
insert into cityinfo(cityid,cityname) values('100025','哈尔滨'); 
insert into cityinfo(cityid,cityname) values('100026','沈阳'); 
insert into cityinfo(cityid,cityname) values('100027','长春'); 
insert into cityinfo(cityid,cityname) values('100028','大连'); 
insert into cityinfo(cityid,cityname) values('100029','乌鲁木齐'); 
insert into cityinfo(cityid,cityname) values('100030','银川'); 
insert into cityinfo(cityid,cityname) values('100031','西安'); 
insert into cityinfo(cityid,cityname) values('100032','西宁'); 
insert into cityinfo(cityid,cityname) values('100033','兰州'); 
insert into cityinfo(cityid,cityname) values('100034','拉萨'); 
insert into cityinfo(cityid,cityname) values('100035','重庆'); 
insert into cityinfo(cityid,cityname) values('100036','昆明'); 
insert into cityinfo(cityid,cityname) values('100037','成都'); 
insert into cityinfo(cityid,cityname) values('100038','贵阳'); 
insert into cityinfo(cityid,cityname) values('100039','香港'); 
insert into cityinfo(cityid,cityname) values('100040','澳门'); 
insert into cityinfo(cityid,cityname) values('100041','台北'); 
insert into cityinfo(cityid,cityname) values('100042','东京'); 
insert into cityinfo(cityid,cityname) values('100044','新加坡'); 
insert into cityinfo(cityid,cityname) values('100046','曼谷'); 
insert into cityinfo(cityid,cityname) values('100047','汉城'); 
/ 
--初始化业务信息表 
insert into serviceinfo 
(serviceid,name,priceinfo,ServiceDesc,freqdesc,example) 
values( 
99, 
'天气预报', 
'包月计费，每城市3元 ', 
'提供全国37个主要城市和10个国际城市的24小时天气预报。(每天晚上6-7时发布。)', 
'1 条/日', 
'北京天气预报：1月17日周四
 
今晚：晴
 
风力：<3
 
最低温度：-8
 
明天：晴
 
风力：<3
 
最高温度：5
 
污染指数：3');