initcity.sql

网上销售源代码

--初使化城市
insert into CityInfo(Province) values('新疆')
insert into CityInfo(Province) values('西藏')
insert into CityInfo(Province) values('甘肃')
insert into CityInfo(Province) values('青海')
insert into CityInfo(Province) values('内蒙古')
insert into CityInfo(Province) values('宁夏')
insert into CityInfo(Province) values('黑龙江')
insert into CityInfo(Province) values('吉林')
insert into CityInfo(Province) values('北京')
insert into CityInfo(Province) values('辽宁')
insert into CityInfo(Province) values('河北')
insert into CityInfo(Province) values('天津')
insert into CityInfo(Province) values('山西')
insert into CityInfo(Province) values('山东')
insert into CityInfo(Province) values('陕西')
insert into CityInfo(Province) values('河南')
insert into CityInfo(Province) values('江苏')
insert into CityInfo(Province) values('四川')
insert into CityInfo(Province) values('云南')
insert into CityInfo(Province) values('重庆')
insert into CityInfo(Province) values('湖北')
insert into CityInfo(Province) values('安徽')
insert into CityInfo(Province) values('上海')
insert into CityInfo(Province) values('贵州')
insert into CityInfo(Province) values('湖南')
insert into CityInfo(Province) values('江西')
insert into CityInfo(Province) values('浙江')
insert into CityInfo(Province) values('广西')
insert into CityInfo(Province) values('广东')
insert into CityInfo(Province) values('福建')
insert into CityInfo(Province) values('海南')
insert into CityInfo(Province) values('澳门')
insert into CityInfo(Province) values('香港')
insert into CityInfo(Province) values('台湾')