全球主要国家数据表mysql

  • J8_393451
    了解作者
  • 120.1KB
    文件大小
  • zip
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-05-26 09:35
    上传日期
全球主要国家数据表。mysql专用!适合php。全球主要国家数据表。mysql专用!适合php。
全球主要国家数据表mysql.zip
  • location.sql
    496.4KB
内容介绍
/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50540 Source Host : localhost:3306 Source Database : travel Target Server Type : MYSQL Target Server Version : 50540 File Encoding : 65001 Date: 2016-09-05 10:42:13 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for travel_location -- ---------------------------- DROP TABLE IF EXISTS `travel_location`; CREATE TABLE `travel_location` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键', `pid` int(11) unsigned DEFAULT '0' COMMENT '父ID', `path` varchar(255) DEFAULT NULL COMMENT '路径', `level` int(11) unsigned DEFAULT NULL COMMENT '层级', `name` varchar(255) DEFAULT NULL COMMENT '中文名称', `name_en` varchar(255) DEFAULT NULL COMMENT '英文名称', `name_pinyin` varchar(255) DEFAULT NULL COMMENT '中文拼音', `code` varchar(50) DEFAULT NULL COMMENT '代码', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4170 DEFAULT CHARSET=utf8 COMMENT='全球地区库,采集自腾讯QQ国内+国际版.ADD.JENA.20141221'; -- ---------------------------- -- Records of travel_location -- ---------------------------- INSERT INTO `travel_location` VALUES ('1', '0', ',1,', '1', '亚洲', 'Asia', 'yazhou', null); INSERT INTO `travel_location` VALUES ('2', '0', ',2,', '1', '欧洲', 'Europe', 'ouzhou', null); INSERT INTO `travel_location` VALUES ('3', '0', ',3,', '1', '非洲', 'Africa', 'feizhou', null); INSERT INTO `travel_location` VALUES ('4', '0', ',4,', '1', '北美', 'North America', 'beimei', null); INSERT INTO `travel_location` VALUES ('5', '0', ',5,', '1', '南美', 'South America', 'nanmei', null); INSERT INTO `travel_location` VALUES ('6', '0', ',6,', '1', '大洋洲', 'Oceania', 'dayangzhou', null); INSERT INTO `travel_location` VALUES ('7', '1', ',1,7,', '2', '中国', 'China', 'zhongguo', 'CN'); INSERT INTO `travel_location` VALUES ('8', '2', ',2,8,', '2', '阿尔巴尼亚', 'Albania', 'aerbaniya', 'ALB'); INSERT INTO `travel_location` VALUES ('9', '3', ',3,9,', '2', '阿尔及利亚', 'Algeria', 'aerjiliya', 'DZA'); INSERT INTO `travel_location` VALUES ('10', '1', ',1,10,', '2', '阿富汗', 'Afghanistan', 'afuhan', 'AFG'); INSERT INTO `travel_location` VALUES ('11', '5', ',5,11,', '2', '阿根廷', 'Argentina', 'agenting', 'ARG'); INSERT INTO `travel_location` VALUES ('12', '1', ',1,12,', '2', '阿拉伯联合酋长国', 'United Arab Emirates', 'alabolianheqiuchangguo', 'ARE'); INSERT INTO `travel_location` VALUES ('13', '5', ',5,13,', '2', '阿鲁巴', 'Aruba', 'aluba', 'ABW'); INSERT INTO `travel_location` VALUES ('14', '1', ',1,14,', '2', '阿曼', 'Oman', 'aman', 'OMN'); INSERT INTO `travel_location` VALUES ('15', '1', ',1,15,', '2', '阿塞拜疆', 'Azerbaijan', 'asaibaijiang', 'AZE'); INSERT INTO `travel_location` VALUES ('16', '3', ',3,16,', '2', '阿森松岛', 'Ascension Island', 'asensongdao', 'ASC'); INSERT INTO `travel_location` VALUES ('17', '3', ',3,17,', '2', '埃及', 'Egypt', 'aiji', 'EGY'); INSERT INTO `travel_location` VALUES ('18', '3', ',3,18,', '2', '埃塞俄比亚', 'Ethiopia', 'aisaiebiya', 'ETH'); INSERT INTO `travel_location` VALUES ('19', '2', ',2,19,', '2', '爱尔兰', 'Ireland', 'aierlan', 'IRL'); INSERT INTO `travel_location` VALUES ('20', '2', ',2,20,', '2', '爱沙尼亚', 'Estonia', 'aishaniya', 'EST'); INSERT INTO `travel_location` VALUES ('21', '2', ',2,21,', '2', '安道尔', 'Andorra', 'andaoer', 'AND'); INSERT INTO `travel_location` VALUES ('22', '3', ',3,22,', '2', '安哥拉', 'Angola', 'angela', 'AGO'); INSERT INTO `travel_location` VALUES ('23', '5', ',5,23,', '2', '安圭拉', 'Anguilla', 'anguila', 'AIA'); INSERT INTO `travel_location` VALUES ('24', '4', ',4,24,', '2', '安提瓜岛和巴布达', 'Antigua and Barbuda', 'antiguadaohebabuda', 'ATG'); INSERT INTO `travel_location` VALUES ('25', '6', ',6,25,', '2', '澳大利亚', 'Australia', 'aodaliya', 'AUS'); INSERT INTO `travel_location` VALUES ('26', '2', ',2,26,', '2', '奥地利', 'Austria', 'aodili', 'AUT'); INSERT INTO `travel_location` VALUES ('27', '2', ',2,27,', '2', '奥兰群岛', 'Aland lslands', 'aolanqundao', 'ALA'); INSERT INTO `travel_location` VALUES ('28', '5', ',5,28,', '2', '巴巴多斯岛', 'Barbados', 'babaduosidao', 'BRB'); INSERT INTO `travel_location` VALUES ('29', '6', ',6,29,', '2', '巴布亚新几内亚', 'Papua New Guinea', 'babuyaxinjineiya', 'PNG'); INSERT INTO `travel_location` VALUES ('30', '4', ',4,30,', '2', '巴哈马', 'Bahamas', 'bahama', 'BHS'); INSERT INTO `travel_location` VALUES ('31', '1', ',1,31,', '2', '巴基斯坦', 'Pakistan', 'bajisitan', 'PAK'); INSERT INTO `travel_location` VALUES ('32', '5', ',5,32,', '2', '巴拉圭', 'Paraguay', 'balagui', 'PRY'); INSERT INTO `travel_location` VALUES ('33', '1', ',1,33,', '2', '巴勒斯坦', 'Palestinian Authority', 'balesitan', 'PSE'); INSERT INTO `travel_location` VALUES ('34', '1', ',1,34,', '2', '巴林', 'Bahrain', 'balin', 'BHR'); INSERT INTO `travel_location` VALUES ('35', '4', ',4,35,', '2', '巴拿马', 'Panama', 'banama', 'PAN'); INSERT INTO `travel_location` VALUES ('36', '5', ',5,36,', '2', '巴西', 'Brazil', 'baxi', 'BRA'); INSERT INTO `travel_location` VALUES ('37', '2', ',2,37,', '2', '白俄罗斯', 'White Russia', 'baieluosi', 'BLR'); INSERT INTO `travel_location` VALUES ('38', '4', ',4,38,', '2', '百慕大', 'Bermuda', 'baimuda', 'BMU'); INSERT INTO `travel_location` VALUES ('39', '2', ',2,39,', '2', '保加利亚', 'Bulgaria', 'baojialiya', 'BGR'); INSERT INTO `travel_location` VALUES ('40', '4', ',4,40,', '2', '北马里亚纳群岛', 'Northern Mariana Islands', 'beimaliyanaqundao', 'MNP'); INSERT INTO `travel_location` VALUES ('41', '3', ',3,41,', '2', '贝宁', 'Benin', 'beining', 'BEN'); INSERT INTO `travel_location` VALUES ('42', '2', ',2,42,', '2', '比利时', 'Belgium', 'bilishi', 'BEL'); INSERT INTO `travel_location` VALUES ('43', '2', ',2,43,', '2', '冰岛', 'Iceland', 'bingdao', 'ISL'); INSERT INTO `travel_location` VALUES ('44', '4', ',4,44,', '2', '波多黎各', 'Puerto Rico', 'boduolige', 'PRI'); INSERT INTO `travel_location` VALUES ('45', '2', ',2,45,', '2', '波兰', 'Poland', 'bolan', 'POL'); INSERT INTO `travel_location` VALUES ('46', '5', ',5,46,', '2', '玻利维亚', 'Bolivia', 'boliweiya', 'BOL'); INSERT INTO `travel_location` VALUES ('47', '2', ',2,47,', '2', '波斯尼亚和黑塞哥维那', 'Bosnia and Herzegovina', 'bosiniyaheheisaigeweina', 'BIH'); INSERT INTO `travel_location` VALUES ('48', '3', ',3,48,', '2', '博茨瓦纳', 'Botswana', 'bociwana', 'BWA'); INSERT INTO `travel_location` VALUES ('49', '4', ',4,49,', '2', '伯利兹', 'Belize', 'bolizi', 'BLZ'); INSERT INTO `travel_location` VALUES ('50', '1', ',1,50,', '2', '不丹', 'Bhutan', 'budan', 'BTN'); INSERT INTO `travel_location` VALUES ('51', '3', ',3,51,', '2', '布基纳法索', 'Burkina Faso', 'bujinafasuo', 'BFA'); INSERT INTO `travel_location` VALUES ('52', '3', ',3,52,', '2', '布隆迪', 'Burundi', 'bulongdi', 'BDI'); INSERT INTO `travel_location` VALUES ('53', '2', ',2,53,', '2', '布韦岛', 'Bouvet Island', 'buweidao', 'BVT'); INSERT INTO `travel_location` VALUES ('54', '1', ',1,54,', '2', '朝鲜', 'North Korea', 'chaoxian', 'PRK'); INSERT INTO `travel_location` VALUES ('55', '2', ',2,55,', '2', '丹麦', 'Denmark', 'danmai', 'DNK'); INSERT INTO `travel_location` VALUES ('56', '2', ',2,56,', '2', '德国', 'Germany', 'deguo', 'DEU'); INSERT INTO `travel_location` VALUES ('57', '1', ',1,57,', '2', '东帝汶', 'Timor-Leste', 'dongdi', 'TLS'); INSERT INTO `travel_location` VALUES ('58', '3', ',3,58,', '2', '多哥', 'Togo', 'duoge', 'TGO'); INSERT INTO `travel_location` VALUES ('59', '4', ',4,59,', '2', '多米尼加', 'Dominica', 'duominijia', 'DMA'); INSERT INTO `travel_location` VALUES ('60', '4', ',4,60,', '2', '多米尼加共和国', 'Domini
评论
    相关推荐
    • php MySQL
      MySQL是一个小型关系型数据库管理系统,开发者为瑞典MySQLAB公司,在2008年1月16号被Sun公司收购。MySQL被广泛地应用在Internet上的中小型网站中。由于其体积小、速度快、总体拥有成本低,尤其是开放源码这一特点,...
    • PHP MYSQL 开发
      PHP MYSQL 开发 经典的PHP开发教材 英文版 好不容易整合的
    • PHPMySQL教程
      本文介绍堪称Web数据库黄金组合的PHP/MySQL如何构筑一个网络数据库应用的方法,PHP是一个类似微软ASP的服务器端的嵌入式超文本处理语言,是建立动态网站的强大工具。而MySQL是一个轻型SQL数据库服务器,可运行在多种...
    • Php MySQL中文教程
      Php MySQL中文教程Php MySQL中文教程Php MySQL中文教程
    • PHP mysql图片上传
      很清晰的PHP mysql图片上传,里面有配置文件。新手看看就明白了哦@
    • phpMysql.rar
      源生php连接mysql封装,包含数据查询,删除,修改,增加等。适合刚解除php人员学习参考.
    • php mysql ADO手册
      这里面包含php mysql ADO手册
    • php mysql
      php mysql HTML 下的看iuyanban留言板
    • php mysql js 手册
      本资源包含了php mysql js 中文手册 适合初学着快速上手........