省市区三级数据的MYSQL内容
省：
/*
Navicat MySQL Data Transfer
Source Server : rm-2ze0lz594rof5nn72.mysql.rds.aliyuncs.com
Source Server Version : 50640
Source Host : rm-2ze0lz594rof5nn72.mysql.rds.aliyuncs.com:3306
Source Database : overseas_erp
Target Server Type : MYSQL
Target Server Version : 50640
File Encoding : 65001
Date: 2018-07-18 18:25:06
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for all_province
-- ----------------------------
DROP TABLE IF EXISTS `all_province`;
CREATE TABLE `all_province` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(6) NOT NULL,
`name` varchar(20) NOT NULL,
`SIMPLENAME` varchar(32) DEFAULT NULL COMMENT '省的简称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of all_province
-- ----------------------------
INSERT INTO `all_province` VALUES ('1', '110000', '北京市', '京');
INSERT INTO `all_province` VALUES ('2', '120000', '天津市', '津');
INSERT INTO `all_province` VALUES ('3', '130000', '河北省', '冀');
INSERT INTO `all_province` VALUES ('4', '140000', '山西省', '晋');
INSERT INTO `all_province` VALUES ('5', '150000', '内蒙古', '蒙');
INSERT INTO `all_province` VALUES ('6', '210000', '辽宁省', '辽');
INSERT INTO `all_province` VALUES ('7', '220000', '吉林省', '吉');
INSERT INTO `all_province` VALUES ('8', '230000', '黑龙江', '黑');
INSERT INTO `all_province` VALUES ('9', '310000', '上海市', '沪');
INSERT INTO `all_province` VALUES ('10', '320000', '江苏省', '苏');
INSERT INTO `all_province` VALUES ('11', '330000', '浙江省', '浙');
INSERT INTO `all_province` VALUES ('12', '340000', '安徽省', '皖');
INSERT INTO `all_province` VALUES ('13', '350000', '福建省', '闽');
INSERT INTO `all_province` VALUES ('14', '360000', '江西省', '赣');
INSERT INTO `all_province` VALUES ('15', '370000', '山东省', '鲁');
INSERT INTO `all_province` VALUES ('16', '410000', '河南省', '豫');
INSERT INTO `all_province` VALUES ('17', '420000', '湖北省', '鄂');
INSERT INTO `all_province` VALUES ('18', '430000', '湖南省', '湘');
INSERT INTO `all_province` VALUES ('19', '440000', '广东省', '粤');
INSERT INTO `all_province` VALUES ('20', '450000', '广 西', '桂');
INSERT INTO `all_province` VALUES ('21', '460000', '海南省', '琼');
INSERT INTO `all_province` VALUES ('22', '500000', '重庆市', '渝');
INSERT INTO `all_province` VALUES ('23', '510000', '四川省', '川');
INSERT INTO `all_province` VALUES ('24', '520000', '贵州省', '贵');
INSERT INTO `all_province` VALUES ('25', '530000', '云南省', '云');
INSERT INTO `all_province` VALUES ('26', '540000', '西 藏', '藏');
INSERT INTO `all_province` VALUES ('27', '610000', '陕西省', '陕');
INSERT INTO `all_province` VALUES ('28', '620000', '甘肃省', '甘');
INSERT INTO `all_province` VALUES ('29', '630000', '青海省', '青');
INSERT INTO `all_province` VALUES ('30', '640000', '宁 夏', '宁');
INSERT INTO `all_province` VALUES ('31', '650000', '新 疆', '新');
INSERT INTO `all_province` VALUES ('32', '710000', '台湾省', '台');
INSERT INTO `all_province` VALUES ('33', '810000', '香 港', '港');
INSERT INTO `all_province` VALUES ('34', '820000', '澳 门', '澳');
/*
Navicat MySQL D
