全球国家->省份/州->城市 数据表
国家表部分数据如下:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for country
-- ----------------------------
DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`country_code` varchar(100) NOT NULL DEFAULT '' COMMENT '国家代码',
`country_name` varchar(100) NOT NULL DEFAULT '' COMMENT '英文国家名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=260 DEFAULT CHARSET=utf8mb4 COMMENT='国家表';
-- ----------------------------
-- Records of country
-- ----------------------------
INSERT INTO `country` VALUES ('1', 'AX', 'Aland Island');
INSERT INTO `country` VALUES ('2', 'AL', 'Albania');
INSERT INTO `country` VALUES ('3', 'DZ', 'Algeria');
INSERT INTO `country` VALUES ('4', 'AS', 'American Samoa');
INSERT INTO `country` VALUES ('5', 'AD', 'Andorra');
INSERT INTO `country` VALUES ('6', 'AO', 'Angola');
INSERT INTO `country` VALUES ('7', 'AI', 'Anguilla');
INSERT INTO `country` VALUES ('8', 'AG', 'Antigua And Barbuda');
INSERT INTO `country` VALUES ('9', 'AR', 'Argentina');
INSERT INTO `country` VALUES ('10', 'AM', 'Armenia');
INSERT INTO `country` VALUES ('11', 'AW', 'Aruba');
INSERT INTO `country` VALUES ('12', 'XD', 'Ascension');
省份表部分数据如下
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for province
-- ----------------------------
DROP TABLE IF EXISTS `province`;
CREATE TABLE `province` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '关联city表的province_id',
`country_id` int(11) NOT NULL DEFAULT 0 COMMENT '国家id',
`province_name` varchar(100) NOT NULL DEFAULT '' COMMENT '省份名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3836 DEFAULT CHARSET=utf8mb4 COMMENT='省份表';
-- ----------------------------
-- Records of province
-- ----------------------------
INSERT INTO `province` VALUES ('1', '2', 'Berat');
INSERT INTO `province` VALUES ('2', '2', 'Bulqize');
INSERT INTO `province` VALUES ('3', '2', 'Diber');
INSERT INTO `province` VALUES ('4', '2', 'Delvine');
INSERT INTO `province` VALUES ('5', '2', 'Durres');
INSERT INTO `province` VALUES ('6', '2', 'Devoll');
INSERT INTO `province` VALUES ('7', '2', 'Elbasan');
INSERT INTO `province` VALUES ('8', '2', 'Kolonje');
INSERT INTO `province` VALUES ('9', '2', 'Fier');
INSERT INTO `province` VALUES ('10', '2', 'Gjirokaster');
INSERT INTO `province` VALUES ('11', '2', 'Gramsh');
INSERT INTO `province` VALUES ('12', '2', 'Has');
INSERT INTO `province` VALUES ('13', '2', 'Kavaje');
INSERT INTO `province` VALUES ('14', '2', 'Kurbin');
INSERT INTO `province` VALUES ('15', '2', 'Kucove');
INSERT INTO `province` VALUES ('16', '2', 'Korce');
城市表部分数据如下:
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`province_id` int(11) NOT NULL DEFAULT 0 COMMENT 'province表id',
`city_name` varchar(100) NOT NULL DEFAULT '' COMMENT '城市名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=381115 DEFAULT CHARSET=utf8mb4 COMMENT='城市表';
-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO `city` VALUES ('1', '120', 'ROSARIO.DE LA FRONTERA');
INSERT INTO `city` VALUES ('2', '120', 'SALTA');
INSERT INTO `city` VALUES ('3', '120', 'TRES CERRITOS');
INSERT INTO `city` VALUES ('4', '120', 'ROSARIO.DE LA LERMA');
INSERT INTO `city` VALUES ('5', '120', 'CERRILLOS');
INSERT INTO `city` VALUES ('6', '120', 'C. QUIJANO');
INSERT INTO `city` VALUES ('7', '120', 'CAMPO SANTO');
INSERT INTO `city` VALUES ('8', '120', 'GENERAL.GUEMES');
INSERT INTO `city` VALUES ('9', '120', 'METAN');
INSERT INTO `city` VALUES ('10', '120', 'CARRERA');
INSERT INTO `city` VALUES ('11', '120', 'EL GALPON');
INSERT INTO `city` VALUES ('12', '120', 'AGUAS BLANCAS');
INSERT INTO `city` VALUES ('13', '120', 'ORAN');
INSERT INTO `city` VALUES ('14', '120', 'TABACAL');
INSERT INTO `city` VALUES ('15', '120', 'COLONIA SANTA ROSA');
INSERT INTO `city` VALUES ('16', '120', 'PICHANAL');
关于中国的部分城市数据:
INSERT INTO `city` VALUES ('41614', '640', 'Qinzhou');
INSERT INTO `city` VALUES ('41615', '640', 'Yulin');
INSERT INTO `city` VALUES ('41616', '640', 'Baise');
INSERT INTO `city` VALUES ('41617', '640', 'Hezhou');
INSERT INTO `city` VALUES ('41618', '640', 'Hechi');
INSERT INTO `city` VALUES ('41619', '640', 'Chongzuo');
INSERT INTO `city` VALUES ('41620', '640', 'Laibin');
INSERT INTO `city` VALUES ('41621', '641', 'Shaoguan');
INSERT INTO `city` VALUES ('41622', '641', 'Guangzhou');
INSERT INTO `city` VALUES ('41623', '641', 'Zhuhai');
INSERT INTO `city` VALUES ('41624', '641', 'Shenzhen');
INSERT INTO `city` VALUES ('41625', '641', 'Foshan');
INSERT INTO `city` VALUES ('41626', '641', 'Shantou');
INSERT INTO `city` VALUES ('41627', '641', 'Zhanjiang');
INSERT INTO `city` VALUES ('41628', '641', 'Jiangmen');
INSERT INTO `city` VALUES ('41629', '641', 'Zhaoqing');
INSERT INTO `city` VALUES ('41630', '641', 'Maoming');
INSERT INTO `city` VALUES ('41631', '641', 'Meizhou');
关于中国部分省份数据如下:
INSERT INTO `province` VALUES ('653', '