全国省市区数据库,可以直接进行下载!
INSERT INTO `areainfo` VALUES ('110000', '北京市', NULL);
INSERT INTO `areainfo` VALUES ('110100', '市辖区', '110000');
INSERT INTO `areainfo` VALUES ('110101', '东城区', '110100');
INSERT INTO `areainfo` VALUES ('110102', '西城区', '110100');
INSERT INTO `areainfo` VALUES ('110105', '朝阳区', '110100');
INSERT INTO `areainfo` VALUES ('110106', '丰台区', '110100');
INSERT INTO `areainfo` VALUES ('110107', '石景山区', '110100');
INSERT INTO `areainfo` VALUES ('110108', '海淀区', '110100');
INSERT INTO `areainfo` VALUES ('110109', '门头沟区', '110100');
INSERT INTO `areainfo` VALUES ('110111', '房山区', '110100');
INSERT INTO `areainfo` VALUES ('110112', '通州区', '110100');
INSERT INTO `areainfo` VALUES ('110113', '顺义区', '110100');
INSERT INTO `areainfo` VALUES ('110114', '昌平区', '110100');
INSERT INTO `areainfo` VALUES ('110115', '大兴区', '110100');
INSERT INTO `areainfo` VALUES ('110116', '怀柔区', '110100');
INSERT INTO `areainfo` VALUES ('110117', '平谷区', '110100');
INSERT INTO `areainfo` VALUES ('110118', '密云区', '110100');
INSERT INTO `areainfo` VALUES ('110119', '延庆区', '110100');