嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):813200300
本次赞助数额为: 2 元微信扫码支付:2 元
请留下您的邮箱,我们将在2小时内将文件发到您的邮箱
最新行政划分SQL脚本
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for administrativedivision
-- ----------------------------
DROP TABLE IF EXISTS `administrativedivision`;
CREATE TABLE `administrativedivision` (
`AdministrativeCode` int(11) NOT NULL,
`AdministrativeName` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`AdministrativeFatherCode` int(11) DEFAULT NULL,
`AdministrativeType` tinyint(4) DEFAULT NULL,
`AdministrativeFullDistrict` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`FirstLetter` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`AllInitials` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`AdministrativeCode`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of administrativedivision
-- ----------------------------
INSERT INTO `administrativedivision` VALUES (110000, '北京市', 0, 1, 'beijingshi', 'B', 'bjs');