mysql -省市区（省）

下载

https://download.csdn.net/download/fm15136/85028672

省

包含简称的

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for province
-- ----------------------------
DROP TABLE IF EXISTS `province`;
CREATE TABLE `province` (
  `code` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省编码',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省名',
  `SIMPLENAME` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '省的简称'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='省';

-- ----------------------------
-- Records of province
-- ----------------------------
INSERT INTO `province` VALUES ('110000', '北京市', '京');
INSERT INTO `province` VALUES ('120000', '天津市', '津');
INSERT INTO `province` VALUES ('130000', '河北省', '冀');
INSERT INTO `province` VALUES ('140000', '山西省', '晋');
INSERT INTO `province` VALUES ('150000', '内蒙古', '蒙');
INSERT INTO `province` VALUES ('210000', '辽宁省', '辽');
INSERT INTO `province` VALUES ('220000', '吉林省', '吉');
INSERT INTO `province` VALUES ('230000', '黑龙江', '黑');
INSERT INTO `province` VALUES ('310000', '上海市', '沪');
INSERT INTO `province` VALUES ('320000', '江苏省', '苏');
INSERT INTO `province` VALUES ('330000', '浙江省', '浙');
INSERT INTO `province` VALUES ('340000', '安徽省', '皖');
INSERT INTO `province` VALUES ('350000', '福建省', '闽');
INSERT INTO `province` VALUES ('360000', '江西省', '赣');
INSERT INTO `province` VALUES ('370000', '山东省', '鲁');
INSERT INTO `province` VALUES ('410000', '河南省', '豫');
INSERT INTO `province` VALUES ('420000', '湖北省', '鄂');
INSERT INTO `province` VALUES ('430000', '湖南省', '湘');
INSERT INTO `province` VALUES ('440000', '广东省', '粤');
INSERT INTO `province` VALUES ('450000', '广  西', '桂');
INSERT INTO `province` VALUES ('460000', '海南省', '琼');
INSERT INTO `province` VALUES ('500000', '重庆市', '渝');
INSERT INTO `province` VALUES ('510000', '四川省', '川');
INSERT INTO `province` VALUES ('520000', '贵州省', '贵');
INSERT INTO `province` VALUES ('530000', '云南省', '云');
INSERT INTO `province` VALUES ('540000', '西  藏', '藏');
INSERT INTO `province` VALUES ('610000', '陕西省', '陕');
INSERT INTO `province` VALUES ('620000', '甘肃省', '甘');
INSERT INTO `province` VALUES ('630000', '青海省', '青');
INSERT INTO `province` VALUES ('640000', '宁  夏', '宁');
INSERT INTO `province` VALUES ('650000', '新  疆', '新');
INSERT INTO `province` VALUES ('710000', '台湾省', '台');
INSERT INTO `province` VALUES ('810000', '香  港', '港');
INSERT INTO `province` VALUES ('820000', '澳  门', '澳');
SET FOREIGN_KEY_CHECKS=1;

没有简称

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for province
-- ----------------------------
DROP TABLE IF EXISTS `province`;
CREATE TABLE `province` (
  `code` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省编码',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '省名'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='省';

-- ----------------------------
-- Records of province
-- ----------------------------
INSERT INTO `province` VALUES ('110000', '北京市');
INSERT INTO `province` VALUES ('120000', '天津市');
INSERT INTO `province` VALUES ('130000', '河北省');
INSERT INTO `province` VALUES ('140000', '山西省');
INSERT INTO `province` VALUES ('150000', '内蒙古');
INSERT INTO `province` VALUES ('210000', '辽宁省');
INSERT INTO `province` VALUES ('220000', '吉林省');
INSERT INTO `province` VALUES ('230000', '黑龙江');
INSERT INTO `province` VALUES ('310000', '上海市');
INSERT INTO `province` VALUES ('320000', '江苏省');
INSERT INTO `province` VALUES ('330000', '浙江省');
INSERT INTO `province` VALUES ('340000', '安徽省');
INSERT INTO `province` VALUES ('350000', '福建省');
INSERT INTO `province` VALUES ('360000', '江西省');
INSERT INTO `province` VALUES ('370000', '山东省');
INSERT INTO `province` VALUES ('410000', '河南省');
INSERT INTO `province` VALUES ('420000', '湖北省');
INSERT INTO `province` VALUES ('430000', '湖南省');
INSERT INTO `province` VALUES ('440000', '广东省');
INSERT INTO `province` VALUES ('450000', '广  西');
INSERT INTO `province` VALUES ('460000', '海南省');
INSERT INTO `province` VALUES ('500000', '重庆市');
INSERT INTO `province` VALUES ('510000', '四川省');
INSERT INTO `province` VALUES ('520000', '贵州省');
INSERT INTO `province` VALUES ('530000', '云南省');
INSERT INTO `province` VALUES ('540000', '西  藏');
INSERT INTO `province` VALUES ('610000', '陕西省');
INSERT INTO `province` VALUES ('620000', '甘肃省');
INSERT INTO `province` VALUES ('630000', '青海省');
INSERT INTO `province` VALUES ('640000', '宁  夏');
INSERT INTO `province` VALUES ('650000', '新  疆');
INSERT INTO `province` VALUES ('710000', '台湾省');
INSERT INTO `province` VALUES ('810000', '香  港');
INSERT INTO `province` VALUES ('820000', '澳  门');
SET FOREIGN_KEY_CHECKS=1;

市

https://blog.csdn.net/fm15136/article/details/123706109

区

区太多无法保存