insert.sql

一个手机站点采用WML 等编写开发,具体可以看代码,比较简单

--初始化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日周四<br>
今晚：晴<br>
风力：<3<br>
最低温度：-8<br>
明天：晴<br>
风力：<3<br>
最高温度：5<br>
污染指数：3');