文件名称：city+province+country.sql
文件大小：22.49MB
文件格式：SQL
更新时间：2023-01-10 12:05:23
sql 世界 城市 省份 国家
全球国家->省份/州->城市 数据表 国家表部分数据如下: 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', '