-
全国省市区数据的SQL表示
资源介绍
INSERT INTO `area` (`aid`,`areaID`,`area`,`cityID`) VALUES
(1,110101,'东城区',110100),
(2,110102,'西城区',110100),
(3,110103,'崇文区',110100),
(4,110104,'宣武区',110100),
(5,110105,'朝阳区',110100),
(6,110106,'丰台区',110100),
(7,110107,'石景山区',110100),
(8,110108,'海淀区',110100),
(9,110109,'门头沟区',110100),
(10,110111,'房山区',110100),
(11,110112,'通州区',110100),
(12,110113,'顺义区',110100),
(13,110114,'昌平区',110100),
(14,110115,'大兴区',110100),
(15,110116,'怀柔区',110100),
(16,110117,'平谷区',110100),
(17,110228,'密云县',110200),
(18,110229,'延庆县',110200),
(19,120101,'和平区',120100),
(20,120102,'河东区',120100),
(21,120103,'河西区',120100),
(22,120104,'南开区',120100),
(23,120105,'河北区',120100),
(24,120106,'红桥区',120100),
(25,120107,'塘沽区',120100),
(26,120108,'汉沽区',120100),
(27,120109,'大港区',120100),
(28,120110,'东丽区',120100),
(29,120111,'西青区',120100),
(30,120112,'津南区',120100);
- 上一篇: YiTie V1.2分类信息管理系统商业正式版
- 下一篇: 全国省市县镇村数据库sql带表结构