initcity.sql

来自「网上销售源代码」· SQL 代码 · 共 37 行

--初使化城市
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('台湾')