中国省份数据库+世界国家名数据库

tb_provinces.sql

中国行政区划,省份:全称、简称、车牌简称,数据库

-- ----------------------------
-- Table structure for tb_provinces
-- ----------------------------
DROP TABLE IF EXISTS `tb_provinces`;
CREATE TABLE `tb_provinces` (
  `code` varchar(10) NOT NULL,
  `name` varchar(20) DEFAULT NULL,
  `brief` varchar(12) DEFAULT NULL,
  `short` varchar(12) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

  

tb_countries.sql

世界国家名称数据库

CREATE TABLE `tb_countries` (
  `id` varchar(10) NOT NULL,
  `country` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_countries
-- ----------------------------
INSERT INTO `tb_countries` VALUES ('1', '中国');
INSERT INTO `tb_countries` VALUES ('3276', '阿尔巴尼亚');
INSERT INTO `tb_countries` VALUES ('3289', '阿尔及利亚');
INSERT INTO `tb_countries` VALUES ('3338', '阿富汗');
INSERT INTO `tb_countries` VALUES ('3343', '阿根廷');
INSERT INTO `tb_countries` VALUES ('3378', '阿拉伯联合酋长国');
INSERT INTO `tb_countries` VALUES ('3383', '阿鲁巴');
INSERT INTO `tb_countries` VALUES ('3384', '阿曼');
INSERT INTO `tb_countries` VALUES ('3393', '阿塞拜疆');
INSERT INTO `tb_countries` VALUES ('3408', '阿森松岛');
INSERT INTO `tb_countries` VALUES ('3409', '埃及');
INSERT INTO `tb_countries` VALUES ('3415', '埃塞俄比亚');
INSERT INTO `tb_countries` VALUES ('3427', '爱尔兰');
INSERT INTO `tb_countries` VALUES ('3454', '爱沙尼亚');
INSERT INTO `tb_countries` VALUES ('3470', '安道尔');
INSERT INTO `tb_countries` VALUES ('3478', '安哥拉');
INSERT INTO `tb_countries` VALUES ('3497', '安圭拉');
INSERT INTO `tb_countries` VALUES ('3498', '安提瓜岛和巴布达');
INSERT INTO `tb_countries` VALUES ('3499', '澳大利亚');
INSERT INTO `tb_countries` VALUES ('3541', '奥地利');
INSERT INTO `tb_countries` VALUES ('3551', '奥兰群岛');
INSERT INTO `tb_countries` VALUES ('3552', '巴巴多斯岛');
INSERT INTO `tb_countries` VALUES ('3553', '巴布亚新几内亚');
INSERT INTO `tb_countries` VALUES ('3573', '巴哈马');
INSERT INTO `tb_countries` VALUES ('3574', '巴基斯坦');
INSERT INTO `tb_countries` VALUES ('3584', '巴拉圭');
INSERT INTO `tb_countries` VALUES ('3603', '巴勒斯坦');
INSERT INTO `tb_countries` VALUES ('3606', '巴林');
INSERT INTO `tb_countries` VALUES ('3616', '巴拿马');
INSERT INTO `tb_countries` VALUES ('3617', '巴西');
INSERT INTO `tb_countries` VALUES ('3645', '白俄罗斯');
INSERT INTO `tb_countries` VALUES ('3652', '百慕大');
INSERT INTO `tb_countries` VALUES ('3653', '保加利亚');
INSERT INTO `tb_countries` VALUES ('3663', '北马里亚纳群岛');
INSERT INTO `tb_countries` VALUES ('3664', '贝宁');
INSERT INTO `tb_countries` VALUES ('3678', '比利时');
INSERT INTO `tb_countries` VALUES ('3690', '冰岛');
INSERT INTO `tb_countries` VALUES ('3691', '波多黎各');
INSERT INTO `tb_countries` VALUES ('3692', '波兰');
INSERT INTO `tb_countries` VALUES ('3756', '玻利维亚');
INSERT INTO `tb_countries` VALUES ('3769', '波斯尼亚和黑塞哥维那');
INSERT INTO `tb_countries` VALUES ('3781', '博茨瓦纳');
INSERT INTO `tb_countries` VALUES ('3782', '伯利兹');
INSERT INTO `tb_countries` VALUES ('3789', '不丹');
INSERT INTO `tb_countries` VALUES ('3790', '布基纳法索');
INSERT INTO `tb_countries` VALUES ('3836', '布隆迪');
INSERT INTO `tb_countries` VALUES ('3854', '布韦岛');
INSERT INTO `tb_countries` VALUES ('3855', '朝鲜');
INSERT INTO `tb_countries` VALUES ('3868', '丹麦');
INSERT INTO `tb_countries` VALUES ('3883', '德国');
INSERT INTO `tb_countries` VALUES ('3926', '东帝汶');
INSERT INTO `tb_countries` VALUES ('3940', '多哥');
INSERT INTO `tb_countries` VALUES ('3946', '多米尼加');
INSERT INTO `tb_countries` VALUES ('3947', '多米尼加共和国');
INSERT INTO `tb_countries` VALUES ('3948', '俄罗斯');
INSERT INTO `tb_countries` VALUES ('4034', '厄瓜多尔');
INSERT INTO `tb_countries` VALUES ('4056', '厄立特里亚');
INSERT INTO `tb_countries` VALUES ('4063', '法国');
INSERT INTO `tb_countries` VALUES ('4087', '法罗群岛');
INSERT INTO `tb_countries` VALUES ('4088', '法属波利尼西亚');
INSERT INTO `tb_countries` VALUES ('4089', '法属圭亚那');
INSERT INTO `tb_countries` VALUES ('4090', '法属南部领地');
INSERT INTO `tb_countries` VALUES ('4091', '梵蒂冈');
INSERT INTO `tb_countries` VALUES ('4092', '菲律宾');
INSERT INTO `tb_countries` VALUES ('4097', '斐济');
INSERT INTO `tb_countries` VALUES ('4098', '芬兰');
INSERT INTO `tb_countries` VALUES ('4119', '佛得角');
INSERT INTO `tb_countries` VALUES ('4140', '弗兰克群岛');
INSERT INTO `tb_countries` VALUES ('4141', '冈比亚');
INSERT INTO `tb_countries` VALUES ('4142', '刚果');
INSERT INTO `tb_countries` VALUES ('4143', '刚果民主共和国');
INSERT INTO `tb_countries` VALUES ('4144', '哥伦比亚');
INSERT INTO `tb_countries` VALUES ('4178', '哥斯达黎加');
INSERT INTO `tb_countries` VALUES ('4186', '格恩西岛');
INSERT INTO `tb_countries` VALUES ('4187', '格林纳达');
INSERT INTO `tb_countries` VALUES ('4188', '格陵兰');
INSERT INTO `tb_countries` VALUES ('4189', '古巴');
INSERT INTO `tb_countries` VALUES ('4207', '瓜德罗普');
INSERT INTO `tb_countries` VALUES ('4208', '关岛');
INSERT INTO `tb_countries` VALUES ('4209', '圭亚那');
INSERT INTO `tb_countries` VALUES ('4220', '哈萨克斯坦');
INSERT INTO `tb_countries` VALUES ('4258', '海地');
INSERT INTO `tb_countries` VALUES ('4259', '韩国');
INSERT INTO `tb_countries` VALUES ('4442', '荷兰');
INSERT INTO `tb_countries` VALUES ('4471', '荷属安地列斯');
INSERT INTO `tb_countries` VALUES ('4472', '赫德和麦克唐纳群岛');
INSERT INTO `tb_countries` VALUES ('4473', '洪都拉斯');
INSERT INTO `tb_countries` VALUES ('4493', '基里巴斯');
INSERT INTO `tb_countries` VALUES ('4497', '吉布提');
INSERT INTO `tb_countries` VALUES ('4502', '吉尔吉斯斯坦');
INSERT INTO `tb_countries` VALUES ('4519', '几内亚');
INSERT INTO `tb_countries` VALUES ('4528', '几内亚比绍');
INSERT INTO `tb_countries` VALUES ('4529', '加拿大');
INSERT INTO `tb_countries` VALUES ('4564', '加纳');
INSERT INTO `tb_countries` VALUES ('4576', '加蓬');
INSERT INTO `tb_countries` VALUES ('4586', '柬埔寨');
INSERT INTO `tb_countries` VALUES ('4611', '捷克共和国');
INSERT INTO `tb_countries` VALUES ('4625', '津巴布韦');
INSERT INTO `tb_countries` VALUES ('4636', '喀麦隆');
INSERT INTO `tb_countries` VALUES ('4647', '卡塔尔');
INSERT INTO `tb_countries` VALUES ('4657', '开曼群岛');
INSERT INTO `tb_countries` VALUES ('4658', '科科斯群岛');
INSERT INTO `tb_countries` VALUES ('4659', '科摩罗');
INSERT INTO `tb_countries` VALUES ('4660', '科特迪瓦');
INSERT INTO `tb_countries` VALUES ('4680', '科威特');
INSERT INTO `tb_countries` VALUES ('4681', '克罗地亚');
INSERT INTO `tb_countries` VALUES ('4703', '肯尼亚');
INSERT INTO `tb_countries` VALUES ('4752', '库克群岛');
INSERT INTO `tb_countries` VALUES ('4753', '拉脱维亚');
INSERT INTO `tb_countries` VALUES ('4780', '莱索托');
INSERT INTO `tb_countries` VALUES ('4791', '老挝');
INSERT INTO `tb_countries` VALUES ('4809', '黎巴嫩');
INSERT INTO `tb_countries` VALUES ('4816', '利比里亚');
INSERT INTO `tb_countries` VALUES ('4834', '利比亚');
INSERT INTO `tb_countries` VALUES ('4835', '立陶宛');
INSERT INTO `tb_countries` VALUES ('4847', '列支敦士登');
INSERT INTO `tb_countries` VALUES ('4848', '留尼旺岛');
INSERT INTO `tb_countries` VALUES ('4849', '卢森堡');
INSERT INTO `tb_countries` VALUES ('4853', '卢旺达');
INSERT INTO `tb_countries` VALUES ('4870', '罗马尼亚');
INSERT INTO `tb_countries` VALUES ('4912', '马达加斯加');
INSERT INTO `tb_countries` VALUES ('4919', '马尔代夫');
INSERT INTO `tb_countries` VALUES ('4941', '马耳他');
INSERT INTO `tb_countries` VALUES ('4942', '马拉维');
INSERT INTO `tb_countries` VALUES ('4946', '马来西亚');
INSERT INTO `tb_countries` VALUES ('5075', '马里');
INSERT INTO `tb_countries` VALUES ('5085', '马其顿');
INSERT INTO `tb_countries` VALUES ('5086', '马绍尔群岛');
INSERT INTO `tb_countries` VALUES ('5087', '马提尼克');
INSERT INTO `tb_countries` VALUES ('5088', '马约特岛');
INSERT INTO `tb_countries` VALUES ('5089', '曼岛');
INSERT INTO `tb_countries` VALUES ('5090', '毛里求斯');
INSERT INTO `tb_countries` VALUES ('5091', '毛里塔尼亚');
INSERT INTO `tb_countries` VALUES ('5105', '美国');
INSERT INTO `tb_countries` VALUES ('5440', '美属萨摩亚');
INSERT INTO `tb_countries` VALUES ('5454', '美属外岛');
INSERT INTO `tb_countries` VALUES ('5455', '蒙古');
INSERT INTO `tb_countries` VALUES ('5478', '蒙特塞拉特');
INSERT INTO `tb_countries` VALUES ('5479', '孟加拉');
INSERT INTO `tb_countries` VALUES ('5483', '密克罗尼西亚');
INSERT INTO `tb_countries` VALUES ('5484', '秘鲁');
INSERT INTO `tb_countries` VALUES ('5514', '缅甸');
INSERT INTO `tb_countries` VALUES ('5529', '摩尔多瓦');
INSERT INTO `tb_countries` VALUES ('5530', '摩洛哥');
INSERT INTO `tb_countries` VALUES ('5540', '摩纳哥');
INSERT INTO `tb_countries` VALUES ('5541', '莫桑比克');
INSERT INTO `tb_countries` VALUES ('5542', '墨西哥');
INSERT INTO `tb_countries` VALUES ('5603', '纳米比亚');
INSERT INTO `tb_countries` VALUES ('5617', '南非');
INSERT INTO `tb_countries` VALUES ('5668', '南极洲');
INSERT INTO `tb_countries` VALUES ('5669', '南乔治亚和南桑德威奇群岛');
INSERT INTO `tb_countries` VALUES ('5670', '瑙鲁');
INSERT INTO `tb_countries` VALUES ('5671', '尼泊尔');
INSERT INTO `tb_countries` VALUES ('5686', '尼加拉瓜');
INSERT INTO `tb_countries` VALUES ('5704', '尼日尔');
INSERT INTO `tb_countries` VALUES ('5713', '尼日利亚');
INSERT INTO `tb_countries` VALUES ('5719', '纽埃');
INSERT INTO `tb_countries` VALUES ('5720', '挪威');
INSERT INTO `tb_countries` VALUES ('5740', '诺福克');
INSERT INTO `tb_countries` VALUES ('5741', '帕劳群岛');
INSERT INTO `tb_countries` VALUES ('5742', '皮特凯恩');
INSERT INTO `tb_countries` VALUES ('5743', '葡萄牙');
INSERT INTO `tb_countries` VALUES ('5773', '乔治亚');
INSERT INTO `tb_countries` VALUES ('5774', '日本');
INSERT INTO `tb_countries` VALUES ('5822', '瑞典');
INSERT INTO `tb_countries` VALUES ('5844', '瑞士');
INSERT INTO `tb_countries` VALUES ('5872', '萨尔瓦多');
INSERT INTO `tb_countries` VALUES ('5896', '萨摩亚');
INSERT INTO `tb_countries` VALUES ('5897', '塞尔维亚,黑山');
INSERT INTO `tb_countries` VALUES ('5906', '塞拉利昂');
INSERT INTO `tb_countries` VALUES ('5911', '塞内加尔');
INSERT INTO `tb_countries` VALUES ('5923', '塞浦路斯');
INSERT INTO `tb_countries` VALUES ('5930', '塞舌尔');
INSERT INTO `tb_countries` VALUES ('5931', '沙特阿拉伯');
INSERT INTO `tb_countries` VALUES ('5954', '圣诞岛');
INSERT INTO `tb_countries` VALUES ('5955', '圣多美和普林西比');
INSERT INTO `tb_countries` VALUES ('5956', '圣赫勒拿');
INSERT INTO `tb_countries` VALUES ('5957', '圣基茨和尼维斯');
INSERT INTO `tb_countries` VALUES ('5958', '圣卢西亚');
INSERT INTO `tb_countries` VALUES ('5959', '圣马力诺');
INSERT INTO `tb_countries` VALUES ('5960', '圣皮埃尔和米克隆群岛');
INSERT INTO `tb_countries` VALUES ('5961', '圣文森特和格林纳丁斯');
INSERT INTO `tb_countries` VALUES ('5962', '斯里兰卡');
INSERT INTO `tb_countries` VALUES ('5988', '斯洛伐克');
INSERT INTO `tb_countries` VALUES ('5997', '斯洛文尼亚');
INSERT INTO `tb_countries` VALUES ('6010', '斯瓦尔巴和扬马廷');
INSERT INTO `tb_countries` VALUES ('6011', '斯威士兰');
INSERT INTO `tb_countries` VALUES ('6012', '苏丹');
INSERT INTO `tb_countries` VALUES ('6022', '苏里南');
INSERT INTO `tb_countries` VALUES ('6033', '所罗门群岛');
INSERT INTO `tb_countries` VALUES ('6044', '索马里');
INSERT INTO `tb_countries` VALUES ('6045', '塔吉克斯坦');
INSERT INTO `tb_countries` VALUES ('6061', '泰国');
INSERT INTO `tb_countries` VALUES ('6136', '坦桑尼亚');
INSERT INTO `tb_countries` VALUES ('6164', '汤加');
INSERT INTO `tb_countries` VALUES ('6170', '特克斯和凯克特斯群岛');
INSERT INTO `tb_countries` VALUES ('6171', '特里斯坦达昆哈');
INSERT INTO `tb_countries` VALUES ('6172', '特立尼达和多巴哥');
INSERT INTO `tb_countries` VALUES ('6173', '突尼斯');
INSERT INTO `tb_countries` VALUES ('6198', '图瓦卢');
INSERT INTO `tb_countries` VALUES ('6199', '土耳其');
INSERT INTO `tb_countries` VALUES ('6278', '土库曼斯坦');
INSERT INTO `tb_countries` VALUES ('6286', '托克劳');
INSERT INTO `tb_countries` VALUES ('6287', '瓦利斯和福图纳');
INSERT INTO `tb_countries` VALUES ('6288', '瓦努阿图');
INSERT INTO `tb_countries` VALUES ('6295', '危地马拉');
INSERT INTO `tb_countries` VALUES ('6320', '维尔京群岛,美属');
INSERT INTO `tb_countries` VALUES ('6321', '维尔京群岛,英属');
INSERT INTO `tb_countries` VALUES ('6322', '委内瑞拉');
INSERT INTO `tb_countries` VALUES ('6347', '文莱');
INSERT INTO `tb_countries` VALUES ('6348', '乌干达');
INSERT INTO `tb_countries` VALUES ('6405', '乌克兰');
INSERT INTO `tb_countries` VALUES ('6431', '乌拉圭');
INSERT INTO `tb_countries` VALUES ('6451', '乌兹别克斯坦');
INSERT INTO `tb_countries` VALUES ('6466', '西班牙');
INSERT INTO `tb_countries` VALUES ('6517', '希腊');
INSERT INTO `tb_countries` VALUES ('6528', '新加坡');
INSERT INTO `tb_countries` VALUES ('6529', '新喀里多尼亚');
INSERT INTO `tb_countries` VALUES ('6530', '新西兰');
INSERT INTO `tb_countries` VALUES ('6555', '匈牙利');
INSERT INTO `tb_countries` VALUES ('6576', '叙利亚');
INSERT INTO `tb_countries` VALUES ('6593', '牙买加');
INSERT INTO `tb_countries` VALUES ('6608', '亚美尼亚');
INSERT INTO `tb_countries` VALUES ('6620', '也门');
INSERT INTO `tb_countries` VALUES ('6642', '伊拉克');
INSERT INTO `tb_countries` VALUES ('6643', '伊朗');
INSERT INTO `tb_countries` VALUES ('6644', '以色列');
INSERT INTO `tb_countries` VALUES ('6653', '意大利');
INSERT INTO `tb_countries` VALUES ('6720', '印度');
INSERT INTO `tb_countries` VALUES ('6751', '印度尼西亚');
INSERT INTO `tb_countries` VALUES ('6780', '英国');
INSERT INTO `tb_countries` VALUES ('6848', '英属印度洋领地');
INSERT INTO `tb_countries` VALUES ('6849', '约旦');
INSERT INTO `tb_countries` VALUES ('6863', '越南');
INSERT INTO `tb_countries` VALUES ('6867', '赞比亚');
INSERT INTO `tb_countries` VALUES ('6877', '泽西岛');
INSERT INTO `tb_countries` VALUES ('6878', '乍得');
INSERT INTO `tb_countries` VALUES ('6879', '直布罗陀');
INSERT INTO `tb_countries` VALUES ('6880', '智利');
INSERT INTO `tb_countries` VALUES ('6894', '中非共和国');