基本信息
源码名称:行政划分MYSQL脚本
源码大小:0.05M
文件格式:.rar
开发语言:SQL
更新时间:2022-01-03
   友情提示:(无需注册或充值,赞助后即可获取资源下载链接)

     嘿,亲!知识可是无价之宝呢,但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下,绝对物超所值哦!如有下载和支付问题,请联系我们QQ(微信同号):813200300

本次赞助数额为: 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');