mysql 世界各国国家名和英文名-程序员必看

一、国家表数据库表结构

CREATE TABLE `country_list` (
    `id` varchar(32) CHARACTER SET utf8 NOT NULL COMMENT '主键ID',
    `country_name` varchar(32) DEFAULT '' COMMENT '国家名称',
    `english_name` varchar(64) DEFAULT '' COMMENT '国家英文名',
    `create_by` varchar(32) DEFAULT '' COMMENT '创建人',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `update_by` varchar(32) DEFAULT '' COMMENT '更新人',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    `del_flag` tinyint(1) DEFAULT '0' COMMENT '删除标识:0-正常,1-已删除,默认0',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='国家表';


二、国家和英文名插入sql语句

1.打开ECSHOP网店根目录user.php文件,找到如下代码

    /* 订单 支付 配送 状态语言项 */
    $order['order_status'] = $_LANG['os'][$order['order_status']];

二、国家和英文名插入sql语句

s
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3338', '阿富汗', 'Afghanistan');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3551', '奥兰群岛', 'land Islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3276', '阿尔巴尼亚', 'Albania');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3289', '阿尔及利亚', 'Algeria');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5454', '美属外岛', 'American outer islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5440', '美属萨摩亚', 'American Samoa');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3454', '爱沙尼亚', 'Andorra');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3470', '安道尔', 'Angola');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3478', '安哥拉', 'Angola');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3497', '安圭拉', 'Anguilla');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5668', '南极洲', 'Antarctica');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3498', '安提瓜岛和巴布达', 'Antigua and Barbuda');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3343', '阿根廷', 'Argentina');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6608', '亚美尼亚', 'Armenia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3383', '阿鲁巴', 'Aruba');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3408', '阿森松岛', 'Ascension Island');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3499', '澳大利亚', 'Australia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3541', '奥地利', 'Austria');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3393', '阿塞拜疆', 'Azerbaijan');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3573', '巴哈马', 'Bahamas');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3606', '巴林', 'Bahrain');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3552', '巴巴多斯岛', 'Barbados');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3645', '白俄罗斯', 'Belarus');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3678', '比利时', 'Belgium');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3782', '伯利兹', 'Belize');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5479', '孟加拉', 'Bengal');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3664', '贝宁', 'Benin');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3652', '百慕大', 'Bermuda');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3789', '不丹', 'Bhutan');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3756', '玻利维亚', 'Bolivia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3769', '波斯尼亚和黑塞哥维那', 'Bosnia and Herzegovina');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3781', '博茨瓦纳', 'Botswana');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3854', '布韦岛', 'Bouvet Island');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3617', '巴西', 'Brazil');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6780', '英国', 'britain');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6848', '英属印度洋领地', 'British Indian Ocean Territory');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6347', '文莱', 'Brunei');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3653', '保加利亚', 'Bulgaria');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3790', '布基纳法索', 'Burkina Faso');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3836', '布隆迪', 'Burundi');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4586', '柬埔寨', 'Cambodia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4636', '喀麦隆', 'Cameroon');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4529', '加拿大', 'Canada');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4119', '佛得角', 'Cape Verde');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4657', '开曼群岛', 'Cayman Islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6894', '中非共和国', 'Central African Republic');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6878', '乍得', 'Chad');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6880', '智利', 'Chile');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('1', '中国', 'China');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5954', '圣诞岛', 'Christmas Island');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4658', '科科斯群岛', 'Cocos Islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4144', '哥伦比亚', 'Colombia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4659', '科摩罗', 'Comoros');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4142', '刚果', 'Congo');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4752', '库克群岛', 'Cook Islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4178', '哥斯达黎加', 'Costa Rica');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4660', '科特迪瓦', 'Cote dIvoire');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4681', '克罗地亚', 'Croatia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4189', '古巴', 'Cuba');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5923', '塞浦路斯', 'Cyprus');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4611', '捷克共和国', 'Czech Republic');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4143', '刚果民主共和国', 'Democratic Republic of Congo');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3868', '丹麦', 'Denmark');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4497', '吉布提', 'Djibouti');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3946', '多米尼加', 'Dominica');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3947', '多米尼加共和国', 'Dominican Republic');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3926', '东帝汶', 'East Timor');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4034', '厄瓜多尔', 'Ecuador');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3409', '埃及', 'Egypt');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5872', '萨尔瓦多', 'El Salvador');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4056', '厄立特里亚', 'Eritrea');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3427', '爱尔兰', 'Estonia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6011', '斯威士兰', 'Eswatini');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3415', '埃塞俄比亚', 'Ethiopia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4087', '法罗群岛', 'Faroe Islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4097', '斐济', 'Fiji');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4098', '芬兰', 'Finland');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4063', '法国', 'France');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4140', '弗兰克群岛', 'frank islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4089', '法属圭亚那', 'French Guiana');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4088', '法属波利尼西亚', 'French Polynesia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4090', '法属南部领地', 'French Southern Territory');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4576', '加蓬', 'Gabon');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4141', '冈比亚', 'Gambia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5773', '乔治亚', 'Georgia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3883', '德国', 'Germany');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4564', '加纳', 'Ghana');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6879', '直布罗陀', 'Gibraltar');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6517', '希腊', 'Greece');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4188', '格陵兰', 'Greenland');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4187', '格林纳达', 'Grenada');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4207', '瓜德罗普', 'Guadeloupe');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4208', '关岛', 'Guam');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6295', '危地马拉', 'Guatemala');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4186', '格恩西岛', 'Guernsey');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4519', '几内亚', 'Guinea');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4528', '几内亚比绍', 'Guinea-Bissau');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4209', '圭亚那', 'Guyana');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4258', '海地', 'Haiti');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4472', '赫德和麦克唐纳群岛', 'heard and macdonald islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4473', '洪都拉斯', 'Honduras');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6555', '匈牙利', 'Hungary');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3690', '冰岛', 'Iceland');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6720', '印度', 'India');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6751', '印度尼西亚', 'Indonesia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6643', '伊朗', 'Iran');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6642', '伊拉克', 'Iraq');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6644', '以色列', 'Israel');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6653', '意大利', 'Italy');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6593', '牙买加', 'Jamaica');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5774', '日本', 'Japan');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6877', '泽西岛', 'Jersey');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6849', '约旦', 'Jordan');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4220', '哈萨克斯坦', 'Kazakhstan');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4703', '肯尼亚', 'Kenya');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4493', '基里巴斯', 'Kiribati');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4680', '科威特', 'Kuwait');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4502', '吉尔吉斯斯坦', 'Kyrgyzstan');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4791', '老挝', 'Laos');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4753', '拉脱维亚', 'Latvia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4809', '黎巴嫩', 'Lebanon');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4780', '莱索托', 'Lesotho');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4816', '利比里亚', 'Liberia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4834', '利比亚', 'Libya');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4847', '列支敦士登', 'Liechtenstein');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4835', '立陶宛', 'Lithuania');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4849', '卢森堡', 'Luxembourg');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5085', '马其顿', 'Macedonia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4912', '马达加斯加', 'Madagascar');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4942', '马拉维', 'Malawi');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4946', '马来西亚', 'Malaysia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4919', '马尔代夫', 'Maldives');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5075', '马里', 'Mali');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4941', '马耳他', 'Malta');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5089', '曼岛', 'Man Island');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5086', '马绍尔群岛', 'Marshall Islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5087', '马提尼克', 'Martinique');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5091', '毛里塔尼亚', 'Mauritania');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5090', '毛里求斯', 'mauritius');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5088', '马约特岛', 'Mayotte Island');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5542', '墨西哥', 'Mexico');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5483', '密克罗尼西亚', 'Micronesia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5529', '摩尔多瓦', 'Moldova');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5540', '摩纳哥', 'Monaco');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5455', '蒙古', 'Mongolia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5478', '蒙特塞拉特', 'Montserrat');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5530', '摩洛哥', 'Morocco');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5541', '莫桑比克', 'Mozambique');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5514', '缅甸', 'Myanmar');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5603', '纳米比亚', 'Namibia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5670', '瑙鲁', 'Nauru');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5671', '尼泊尔', 'Nepal');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4442', '荷兰', 'Netherlands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4471', '荷属安地列斯', 'Netherlands Antilles');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6529', '新喀里多尼亚', 'New Caledonia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6530', '新西兰', 'New Zealand');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5686', '尼加拉瓜', 'Nicaragua');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5704', '尼日尔', 'Niger');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5713', '尼日利亚', 'Nigeria');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5719', '纽埃', 'Niue');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5740', '诺福克', 'Norfolk');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3855', '朝鲜', 'North Korea');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3663', '北马里亚纳群岛', 'Northern Mariana Islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5720', '挪威', 'Norway');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3384', '阿曼', 'Oman');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3574', '巴基斯坦', 'Pakistan');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5741', '帕劳群岛', 'Palau Islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3603', '巴勒斯坦', 'Palestine');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3616', '巴拿马', 'Panama');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3553', '巴布亚新几内亚', 'Papua New Guinea');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3584', '巴拉圭', 'Paraguay');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5484', '秘鲁', 'Peru');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4092', '菲律宾', 'Philippine');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5742', '皮特凯恩', 'Pitcairn');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3692', '波兰', 'Poland');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5743', '葡萄牙', 'Portugal');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3691', '波多黎各', 'Puerto Rico');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4647', '卡塔尔', 'Qatar');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4848', '留尼旺岛', 'Reunion Island');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4870', '罗马尼亚', 'Romania');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3948', '俄罗斯', 'Russia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4853', '卢旺达', 'Rwanda');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5957', '圣基茨和尼维斯', 'Saint Kitts and Nevis');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5958', '圣卢西亚', 'Saint Lucia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5961', '圣文森特和格林纳丁斯', 'Saint Vincent and the Grenadines');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5896', '萨摩亚', 'Samoa');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5959', '圣马力诺', 'San Marino');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5955', '圣多美和普林西比', 'Sao Tome and Principe');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5931', '沙特阿拉伯', 'Saudi Arabia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5911', '塞内加尔', 'Senegal');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5897', '塞尔维亚,黑山', 'Serbia, Montenegro');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5930', '塞舌尔', 'Seychelles');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5906', '塞拉利昂', 'sierra leone');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6528', '新加坡', 'Singapore');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5988', '斯洛伐克', 'Slovakia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5997', '斯洛文尼亚', 'Slovenia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6033', '所罗门群岛', 'Solomon Islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6044', '索马里', 'Somalia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5617', '南非', 'South Africa');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5669', '南乔治亚和南桑德威奇群岛', 'South Georgia and the South Sandwich Islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4259', '韩国', 'South Korea');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6466', '西班牙', 'Spain');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5962', '斯里兰卡', 'Sri Lanka');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5956', '圣赫勒拿', 'St Helena');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5960', '圣皮埃尔和米克隆群岛', 'St Pierre and Miquelon Islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6012', '苏丹', 'Sudan');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6022', '苏里南', 'Suriname');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6010', '斯瓦尔巴和扬马廷', 'Svalbard and Jan Martin');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5822', '瑞典', 'Sweden');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5844', '瑞士', 'Switzerland');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6576', '叙利亚', 'Syria');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6045', '塔吉克斯坦', 'Tajikistan');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6136', '坦桑尼亚', 'Tanzania');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6061', '泰国', 'Thailand');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3940', '多哥', 'togo');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6286', '托克劳', 'Tokelau');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6164', '汤加', 'Tonga');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6172', '特立尼达和多巴哥', 'Trinidad and Tobago');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6171', '特里斯坦达昆哈', 'Tristan Da kunha');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6173', '突尼斯', 'Tunisia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6199', '土耳其', 'turkey');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6278', '土库曼斯坦', 'Turkmenistan');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6170', '特克斯和凯克特斯群岛', 'Turks and Caicos Islands');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6198', '图瓦卢', 'Tuvalu');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('5105', '美国', 'U.S.A');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6348', '乌干达', 'Uganda');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6405', '乌克兰', 'Ukraine');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('3378', '阿拉伯联合酋长国', 'United Arab Emirates');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6431', '乌拉圭', 'Uruguay');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6451', '乌兹别克斯坦', 'Uzbekistan');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6288', '瓦努阿图', 'Vanuatu');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4091', '梵蒂冈', 'Vatican');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6322', '委内瑞拉', 'Venezuela');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6863', '越南', 'Vietnam');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6321', '维尔京群岛,英属', 'Virgin Islands, British');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6320', '维尔京群岛,美属', 'Virgin Islands, United States');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6287', '瓦利斯和福图纳', 'Wallis and Fortuna');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6620', '也门', 'Yemen');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('6867', '赞比亚', 'Zambia');
INSERT INTO `country_list`(`id`, `country_name`, `english_name`) VALUES ('4625', '津巴布韦', 'Zimbabwe');

-- 注意,有一个sql需要特殊处理:
-- 这个国家【'科特迪瓦', 'Cote d'Ivoire'】英文名比较特殊,有’号,不能执行sql插入,需要手动改一下数据。

本文原创地址:https://www.ecshopok.com/article-952.html
版权所有 © 转载时必须以链接形式注明出处!

觉得本文对您有用,想收藏下来!方法很简单:请点击-〉
我们一直坚持白天工作、晚上熬夜更新资源,付出了巨大的精力和时间,其中的辛酸难以言述。

文章评论

暂无评论,来发表一个吧

发表 取消
充值有惊喜 ECSHOP插件网微信客服edait_cn