记一次傻逼的录入
项目中需要国际手机号前缀，于是乎，找到了一个网页。
于是乎，我就手动的，一个一个录入。
录了一下午，录的我脑仁疼，Ctrl+C，Ctrl+V。还要时刻对比，是否有错误。
真是傻逼到家了。
INSERT INTO `tf_phone_nation` VALUES (NULL,'China','中国','CN','86',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Afghanistan','阿富汗','AF','93',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Albania','阿尔巴尼亚','AL','355',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Algeria','阿尔及利亚','DZ','213',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'American Samoa','美属萨摩亚','AS','1684',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Andorra','安道尔','AD','376',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Angola','安哥拉','AO','244',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Anguilla','安圭拉','AI','1264',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Antigua and Barbuda','安提瓜和巴布达','AG','1268',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Argentina','阿根廷','AR','54',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Armenia','亚美尼亚','AM','374',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Aruba','阿鲁巴','AW','297',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Australia','澳大利亚','AU','61',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Austria','奥地利','AT','43',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Azerbaijan','阿塞拜疆','AZ','994',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bahamas','巴哈马','BS','1242',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bahrain','巴林','BH','973',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bangladesh','孟加拉国','BD','880',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Barbados','巴巴多斯','BB','1246',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Belarus','白俄罗斯','BY','375',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Belgium','比利时','BE','32',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Belize','伯利兹','BZ','501',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Benin','贝宁','BJ','229',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bermuda','百慕大群岛','BM','1441',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bhutan','不丹','BT','975',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bolivia','玻利维亚','BO','591',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bosnia and Herzegovina','波斯尼亚和黑塞哥维那','BA','387',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Botswana','博茨瓦纳','BW','267',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Brazil','巴西','BR','55',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Brunei','文莱','BN','673',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bulgaria','保加利亚','BG','359',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Burkina Faso','布基纳法索','BF','226',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Burundi','布隆迪','BI','257',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cambodia','柬埔寨','KH','855',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cameroon','喀麦隆','CM','237',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cape Verde','开普','CV','238',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cayman Islands','开曼群岛','KY','1345',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Central African Republic','中非共和国','CF','236',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Chad','乍得','TD','235',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Chile','智利','CL','56',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Colombia','哥伦比亚','CO','57',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Comoros','科摩罗','KM','269',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cook Islands','库克群岛','CK','682',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Costa Rica','哥斯达黎加','CR','506',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Croatia','克罗地亚','HR','385',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cuba','古巴','CU','53',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Curacao','库拉索','CW','599',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cyprus','塞浦路斯','CY','357',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Czech','捷克','CZ','420',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Democratic Republic of the Congo','刚果民主共和国','CD','243',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Denmark','丹麦','DK','45',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Djibouti','吉布提','DJ','253',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Dominica','多米尼加','DM','1767',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Dominican Republic','多米尼加共和国','DO','1809',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'East Timor','东帝汶','TL','670',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ecuador','厄瓜多尔','EC','593',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Egypt','埃及','EG','20',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'El Salvador','萨尔瓦多','SV','503',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Equatorial Guinea','赤道几内亚','GQ','240',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Eritrea','厄立特里亚','ER','291',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Estonia','爱沙尼亚','EE','372',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ethiopia','埃塞俄比亚','ET','251',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Faroe Islands','法罗群岛','FO','298',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Fiji','斐济','FJ','679',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Finland','芬兰','FI','358',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'France','法国','FR','33',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'French Guiana','法属圭亚那','GF','594',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'French Polynesia','法属波利尼西亚','PF','689',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Gabon','加蓬','GA','241',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Gambia','冈比亚','GM','220',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Georgia','格鲁吉亚','GE','995',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Germany','德国','DE','49',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ghana','加纳','GH','233',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Gibraltar','直布罗陀','GI','350',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Greece','希腊','GR','30',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Greenland','格陵兰岛','GL','299',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Grenada','格林纳达','GD','1473',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guadeloupe','瓜德罗普岛','GP','590',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guam','关岛','GU','1671',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guatemala','瓜地马拉','GT','502',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guinea','几内亚','GN','224',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guinea-Bissau','几内亚比绍共和国','GW','245',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guyana','圭亚那','GY','592',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Haiti','海地','HT','509',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Honduras','洪都拉斯','HN','504',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Hong Kong','中国香港','HK','852',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Hungary','匈牙利','HU','36',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Iceland','冰岛','IS','354',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'India','印度','IN','91',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Indonesia','印度尼西亚','ID','62',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Iran','伊朗','IR','98',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Iraq','伊拉克','IQ','964',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ireland','爱尔兰','IE','353',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Israel','以色列','IL','972',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Italy','意大利','IT','39',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ivory Coast','象牙海岸','CI','225',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Jamaica','牙买加','JM','1876',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Japan','日本','JP','81',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Jordan','约旦','JO','962',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kazakhstan','哈萨克斯坦','KZ','7',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kenya','肯尼亚','KE','254',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kiribati','基里巴斯','KI','686',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kuwait','科威特','KW','965',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kyrgyzstan','吉尔吉斯斯坦','KG','996',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Laos','老挝','LA','856',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Latvia','拉脱维亚','LV','371',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Lebanon','黎巴嫩','LB','961',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Lesotho','莱索托','LS','266',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Liberia','利比里亚','LR','231',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Libya','利比亚','LY','218',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Liechtenstein','列支敦士登','LI','423',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Lithuania','立陶宛','LT','370',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Luxembourg','卢森堡','LU','352',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Macau','中国澳门','MO','853',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Macedonia','马其顿','MK','389',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Madagascar','马达加斯加','MG','261',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Malawi','马拉维','MW ','265',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Malaysia','马来西亚','MY','60',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Maldives','马尔代夫','MV','960',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mali','马里','ML','223',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Malta','马耳他','MT','356',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Martinique','马提尼克','MQ','596',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mauritania','毛里塔尼亚','MR','222',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mauritius','毛里求斯','MU','230',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mayotte','马约特','YT','269',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mexico','墨西哥','MX','52',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Moldova','摩尔多瓦','MD','373',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Monaco','摩纳哥','MC','377',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mongolia','蒙古','MN','976',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Montenegro','黑山','ME','382',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Montserrat','蒙特塞拉特岛','MS','1664',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Morocco','摩洛哥','MA','212',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mozambique','莫桑比克','MZ','258',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Myanmar','缅甸','MM','95',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Namibia','纳米比亚','NA','264',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Nepal','尼泊尔','NP','977',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Netherlands','荷兰','NL','31',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'New Caledonia','新喀里多尼亚','NC','687',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'New Zealand','新西兰','NZ','64',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Nicaragua','尼加拉瓜','NI','505',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Niger','尼日尔','NE','227',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Nigeria','尼日利亚','NG','234',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Norway','挪威','NO','47',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Oman','阿曼','OM','968',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
以上是我一个一个录的。纪念一下。
后来，脑子一热，想到了爬虫技术。想着如何把网页数据爬下来。分析着，发现，原来这些数据是通过json的方式渲染出来的。就找到了json数据，如下。
[{
"1": "Afghanistan",
"2": "阿富汗",
"3": "AF",
"4": "93",
"5": "¥0.053",
"tce_rule_count": "1"
}, {
"1": "Albania",
"2": "阿尔巴尼亚",
"3": "AL",
"4": "355",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Algeria",
"2": "阿尔及利亚",
"3": "DZ",
"4": "213",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "American Samoa",
"2": "美属萨摩亚",
"3": "AS",
"4": "1684",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Andorra",
"2": "安道尔",
"3": "AD",
"4": "376",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Angola",
"2": "安哥拉",
"3": "AO",
"4": "244",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Anguilla",
"2": "安圭拉",
"3": "AI",
"4": "1264",
"5": "¥0.179",
"tce_rule_count": "1"
}, {
"1": "Antigua and Barbuda",
"2": "安提瓜和巴布达",
"3": "AG",
"4": "1268",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Argentina",
"2": "阿根廷",
"3": "AR",
"4": "54",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Armenia",
"2": "亚美尼亚",
"3": "AM",
"4": "374",
"5": "¥0.389",
"tce_rule_count": "1"
}, {
"1": "Aruba",
"2": "阿鲁巴",
"3": "AW",
"4": "297",
"5": "¥0.179",
"tce_rule_count": "1"
}, {
"1": "Australia",
"2": "澳大利亚",
"3": "AU",
"4": "61",
"5": "¥0.315",
"tce_rule_count": "1"
}, {
"1": "Austria",
"2": "奥地利",
"3": "AT",
"4": "43",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Azerbaijan",
"2": "阿塞拜疆",
"3": "AZ",
"4": "994",
"5": "¥0.389",
"tce_rule_count": "1"
}, {
"1": "Bahamas",
"2": "巴哈马",
"3": "BS",
"4": "1242",
"5": "¥0.179",
"tce_rule_count": "1"
}, {
"1": "Bahrain",
"2": "巴林",
"3": "BH",
"4": "973",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Bangladesh",
"2": "孟加拉国",
"3": "BD",
"4": "880",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Barbados",
"2": "巴巴多斯",
"3": "BB",
"4": "1246",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Belarus",
"2": "白俄罗斯",
"3": "BY",
"4": "375",
"5": "¥0.405",
"tce_rule_count": "1"
}, {
"1": "Belgium",
"2": "比利时",
"3": "BE",
"4": "32",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Belize",
"2": "伯利兹",
"3": "BZ",
"4": "501",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Benin",
"2": "贝宁",
"3": "BJ",
"4": "229",
"5": "¥0.273",
"tce_rule_count": "1"
}, {
"1": "Bermuda",
"2": "百慕大群岛",
"3": "BM",
"4": "1441",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Bhutan",
"2": "不丹",
"3": "BT",
"4": "975",
"5": "¥0.273",
"tce_rule_count": "1"
}, {
"1": "Bolivia",
"2": "玻利维亚",
"3": "BO",
"4": "591",
"5": "¥0.179",
"tce_rule_count": "1"
}, {
"1": "Bosnia and Herzegovina",
"2": "波斯尼亚和黑塞哥维那",
"3": "BA",
"4": "387",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Botswana",
"2": "博茨瓦纳",
"3": "BW",
"4": "267",
"5": "¥0.105",
"tce_rule_count": "1"
}, {
"1": "Brazil",
"2": "巴西",
"3": "BR",
"4": "55",
"5": "¥0.311",
"tce_rule_count": "1"
}, {
"1": "Brunei",
"2": "文莱",
"3": "BN",
"4": "673",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Bulgaria",
"2": "保加利亚",
"3": "BG",
"4": "359",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Burkina Faso",
"2": "布基纳法索",
"3": "BF",
"4": "226",
"5": "¥0.179",
"tce_rule_count": "1"
}, {
"1": "Burundi",
"2": "布隆迪",
"3": "BI",
"4": "257",
"5": "¥0.053",
"tce_rule_count": "1"
}, {
"1": "Cambodia",
"2": "柬埔寨",
"3": "KH",
"4": "855",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Cameroon",
"2": "喀麦隆",
"3": "CM",
"4": "237",
"5": "¥0.221",
"tce_rule_count": "1"
}, {
"1": "Canada",
"2": "加拿大",
"3": "CA",
"4": "1",
"5": "¥0.042",
"tce_rule_count": "1"
}, {
"1": "Cape Verde",
"2": "开普",
"3": "CV",
"4": "238",
"5": "¥0.317",
"tce_rule_count": "1"
}, {
"1": "Cayman Islands",
"2": "开曼群岛",
"3": "KY",
"4": "1345",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Central African Republic",
"2": "中非共和国",
"3": "CF",
"4": "236",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Chad",
"2": "乍得",
"3": "TD",
"4": "235",
"5": "¥0.032",
"tce_rule_count": "1"
}, {
"1": "Chile",
"2": "智利",
"3": "CL",
"4": "56",
"5": "¥0.326",
"tce_rule_count": "1"
}, {
"1": "Colombia",
"2": "哥伦比亚",
"3": "CO",
"4": "57",
"5": "¥0.382",
"tce_rule_count": "1"
}, {
"1": "Comoros",
"2": "科摩罗",
"3": "KM",
"4": "269",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Cook Islands",
"2": "库克群岛",
"3": "CK",
"4": "682",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Costa Rica",
"2": "哥斯达黎加",
"3": "CR",
"4": "506",
"5": "¥0.179",
"tce_rule_count": "1"
}, {
"1": "Croatia",
"2": "克罗地亚",
"3": "HR",
"4": "385",
"5": "¥0.166",
"tce_rule_count": "1"
}, {
"1": "Cuba",
"2": "古巴",
"3": "CU",
"4": "53",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Curacao",
"2": "库拉索",
"3": "CW",
"4": "599",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Cyprus",
"2": "塞浦路斯",
"3": "CY",
"4": "357",
"5": "¥0.221",
"tce_rule_count": "1"
}, {
"1": "Czech",
"2": "捷克",
"3": "CZ",
"4": "420",
"5": "¥0.315",
"tce_rule_count": "1"
}, {
"1": "Democratic Republic of the Congo",
"2": "刚果民主共和国",
"3": "CD",
"4": "243",
"5": "¥0.263",
"tce_rule_count": "1"
}, {
"1": "Denmark",
"2": "丹麦",
"3": "DK",
"4": "45",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Djibouti",
"2": "吉布提",
"3": "DJ",
"4": "253",
"5": "¥0.113",
"tce_rule_count": "1"
}, {
"1": "Dominica",
"2": "多米尼加",
"3": "DM",
"4": "1767",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Dominican Republic",
"2": "多米尼加共和国",
"3": "DO",
"4": "1809",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "East Timor",
"2": "东帝汶",
"3": "TL",
"4": "670",
"5": "¥0.399",
"tce_rule_count": "1"
}, {
"1": "Ecuador",
"2": "厄瓜多尔",
"3": "EC",
"4": "593",
"5": "¥0.273",
"tce_rule_count": "1"
}, {
"1": "Egypt",
"2": "埃及",
"3": "EG",
"4": "20",
"5": "¥0.263",
"tce_rule_count": "1"
}, {
"1": "El Salvador",
"2": "萨尔瓦多",
"3": "SV",
"4": "503",
"5": "¥0.147",
"tce_rule_count": "1"
}, {
"1": "Equatorial Guinea",
"2": "赤道几内亚",
"3": "GQ",
"4": "240",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Eritrea",
"2": "厄立特里亚",
"3": "ER",
"4": "291",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Estonia",
"2": "爱沙尼亚",
"3": "EE",
"4": "372",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Ethiopia",
"2": "埃塞俄比亚",
"3": "ET",
"4": "251",
"5": "¥0.042",
"tce_rule_count": "1"
}, {
"1": "Faroe Islands",
"2": "法罗群岛",
"3": "FO",
"4": "298",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Fiji",
"2": "斐济",
"3": "FJ",
"4": "679",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Finland",
"2": "芬兰",
"3": "FI",
"4": "358",
"5": "¥0.341",
"tce_rule_count": "1"
}, {
"1": "France",
"2": "法国",
"3": "FR",
"4": "33",
"5": "¥0.389",
"tce_rule_count": "1"
}, {
"1": "French Guiana",
"2": "法属圭亚那",
"3": "GF",
"4": "594",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "French Polynesia",
"2": "法属波利尼西亚",
"3": "PF",
"4": "689",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Gabon",
"2": "加蓬",
"3": "GA",
"4": "241",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Gambia",
"2": "冈比亚",
"3": "GM",
"4": "220",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Georgia",
"2": "格鲁吉亚",
"3": "GE",
"4": "995",
"5": "¥0.179",
"tce_rule_count": "1"
}, {
"1": "Germany",
"2": "德国",
"3": "DE",
"4": "49",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Ghana",
"2": "加纳",
"3": "GH",
"4": "233",
"5": "¥0.179",
"tce_rule_count": "1"
}, {
"1": "Gibraltar",
"2": "直布罗陀",
"3": "GI",
"4": "350",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Greece",
"2": "希腊",
"3": "GR",
"4": "30",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Greenland",
"2": "格陵兰岛",
"3": "GL",
"4": "299",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Grenada",
"2": "格林纳达",
"3": "GD",
"4": "1473",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Guadeloupe",
"2": "瓜德罗普岛",
"3": "GP",
"4": "590",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Guam",
"2": "关岛",
"3": "GU",
"4": "1671",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Guatemala",
"2": "瓜地马拉",
"3": "GT",
"4": "502",
"5": "¥0.273",
"tce_rule_count": "1"
}, {
"1": "Guinea",
"2": "几内亚",
"3": "GN",
"4": "224",
"5": "¥0.158",
"tce_rule_count": "1"
}, {
"1": "Guinea-Bissau",
"2": "几内亚比绍共和国",
"3": "GW",
"4": "245",
"5": "¥0.042",
"tce_rule_count": "1"
}, {
"1": "Guyana",
"2": "圭亚那",
"3": "GY",
"4": "592",
"5": "¥0.357",
"tce_rule_count": "1"
}, {
"1": "Haiti",
"2": "海地",
"3": "HT",
"4": "509",
"5": "¥0.105",
"tce_rule_count": "1"
}, {
"1": "Honduras",
"2": "洪都拉斯",
"3": "HN",
"4": "504",
"5": "¥0.221",
"tce_rule_count": "1"
}, {
"1": "Hong Kong",
"2": "中国香港",
"3": "HK",
"4": "852",
"5": "¥0.243",
"tce_rule_count": "1"
}, {
"1": "Hungary",
"2": "匈牙利",
"3": "HU",
"4": "36",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Iceland",
"2": "冰岛",
"3": "IS",
"4": "354",
"5": "¥0.137",
"tce_rule_count": "1"
}, {
"1": "India",
"2": "印度",
"3": "IN",
"4": "91",
"5": "¥0.053",
"tce_rule_count": "1"
}, {
"1": "Indonesia",
"2": "印度尼西亚",
"3": "ID",
"4": "62",
"5": "¥0.255",
"tce_rule_count": "1"
}, {
"1": "Iran",
"2": "伊朗",
"3": "IR",
"4": "98",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Iraq",
"2": "伊拉克",
"3": "IQ",
"4": "964",
"5": "¥0.378",
"tce_rule_count": "1"
}, {
"1": "Ireland",
"2": "爱尔兰",
"3": "IE",
"4": "353",
"5": "¥0.168",
"tce_rule_count": "1"
}, {
"1": "Israel",
"2": "以色列",
"3": "IL",
"4": "972",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Italy",
"2": "意大利",
"3": "IT",
"4": "39",
"5": "¥0.393",
"tce_rule_count": "1"
}, {
"1": "Ivory Coast",
"2": "象牙海岸",
"3": "CI",
"4": "225",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Jamaica",
"2": "牙买加",
"3": "JM",
"4": "1876",
"5": "¥0.053",
"tce_rule_count": "1"
}, {
"1": "Japan",
"2": "日本",
"3": "JP",
"4": "81",
"5": "¥0.214",
"tce_rule_count": "1"
}, {
"1": "Jordan",
"2": "约旦",
"3": "JO",
"4": "962",
"5": "¥0.179",
"tce_rule_count": "1"
}, {
"1": "Kazakhstan",
"2": "哈萨克斯坦",
"3": "KZ",
"4": "7",
"5": "¥0.266",
"tce_rule_count": "1"
}, {
"1": "Kenya",
"2": "肯尼亚",
"3": "KE",
"4": "254",
"5": "¥0.179",
"tce_rule_count": "1"
}, {
"1": "Kiribati",
"2": "基里巴斯",
"3": "KI",
"4": "686",
"5": "¥0.250",
"tce_rule_count": "1"
}, {
"1": "Kuwait",
"2": "科威特",
"3": "KW",
"4": "965",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Kyrgyzstan",
"2": "吉尔吉斯斯坦",
"3": "KG",
"4": "996",
"5": "¥0.284",
"tce_rule_count": "1"
}, {
"1": "Laos",
"2": "老挝",
"3": "LA",
"4": "856",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Latvia",
"2": "拉脱维亚",
"3": "LV",
"4": "371",
"5": "¥0.315",
"tce_rule_count": "1"
}, {
"1": "Lebanon",
"2": "黎巴嫩",
"3": "LB",
"4": "961",
"5": "¥0.189",
"tce_rule_count": "1"
}, {
"1": "Lesotho",
"2": "莱索托",
"3": "LS",
"4": "266",
"5": "¥0.200",
"tce_rule_count": "1"
}, {
"1": "Liberia",
"2": "利比里亚",
"3": "LR",
"4": "231",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Libya",
"2": "利比亚",
"3": "LY",
"4": "218",
"5": "¥0.221",
"tce_rule_count": "1"
}, {
"1": "Liechtenstein",
"2": "列支敦士登",
"3": "LI",
"4": "423",
"5": "¥0.147",
"tce_rule_count": "1"
}, {
"1": "Lithuania",
"2": "立陶宛",
"3": "LT",
"4": "370",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Luxembourg",
"2": "卢森堡",
"3": "LU",
"4": "352",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Macau",
"2": "中国澳门",
"3": "MO",
"4": "853",
"5": "¥0.105",
"tce_rule_count": "1"
}, {
"1": "Macedonia",
"2": "马其顿",
"3": "MK",
"4": "389",
"5": "¥0.105",
"tce_rule_count": "1"
}, {
"1": "Madagascar",
"2": "马达加斯加",
"3": "MG",
"4": "261",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Malawi",
"2": "马拉维",
"3": "MW",
"4": "265",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Malaysia",
"2": "马来西亚",
"3": "MY",
"4": "60",
"5": "¥0.157",
"tce_rule_count": "1"
}, {
"1": "Maldives",
"2": "马尔代夫",
"3": "MV",
"4": "960",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Mali",
"2": "马里",
"3": "ML",
"4": "223",
"5": "¥0.147",
"tce_rule_count": "1"
}, {
"1": "Malta",
"2": "马耳他",
"3": "MT",
"4": "356",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Martinique",
"2": "马提尼克",
"3": "MQ",
"4": "596",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Mauritania",
"2": "毛里塔尼亚",
"3": "MR",
"4": "222",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Mauritius",
"2": "毛里求斯",
"3": "MU",
"4": "230",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Mayotte",
"2": "马约特",
"3": "YT",
"4": "269",
"5": "¥0.324",
"tce_rule_count": "1"
}, {
"1": "Mexico",
"2": "墨西哥",
"3": "MX",
"4": "52",
"5": "¥0.315",
"tce_rule_count": "1"
}, {
"1": "Moldova",
"2": "摩尔多瓦",
"3": "MD",
"4": "373",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Monaco",
"2": "摩纳哥",
"3": "MC",
"4": "377",
"5": "¥0.232",
"tce_rule_count": "1"
}, {
"1": "Mongolia",
"2": "蒙古",
"3": "MN",
"4": "976",
"5": "¥0.053",
"tce_rule_count": "1"
}, {
"1": "Montenegro",
"2": "黑山",
"3": "ME",
"4": "382",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Montserrat",
"2": "蒙特塞拉特岛",
"3": "MS",
"4": "1664",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Morocco",
"2": "摩洛哥",
"3": "MA",
"4": "212",
"5": "¥0.347",
"tce_rule_count": "1"
}, {
"1": "Mozambique",
"2": "莫桑比克",
"3": "MZ",
"4": "258",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Myanmar",
"2": "缅甸",
"3": "MM",
"4": "95",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Namibia",
"2": "纳米比亚",
"3": "NA",
"4": "264",
"5": "¥0.284",
"tce_rule_count": "1"
}, {
"1": "Nepal",
"2": "尼泊尔",
"3": "NP",
"4": "977",
"5": "¥0.221",
"tce_rule_count": "1"
}, {
"1": "Netherlands",
"2": "荷兰",
"3": "NL",
"4": "31",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "New Caledonia",
"2": "新喀里多尼亚",
"3": "NC",
"4": "687",
"5": "¥0.147",
"tce_rule_count": "1"
}, {
"1": "New Zealand",
"2": "新西兰",
"3": "NZ",
"4": "64",
"5": "¥0.326",
"tce_rule_count": "1"
}, {
"1": "Nicaragua",
"2": "尼加拉瓜",
"3": "NI",
"4": "505",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Niger",
"2": "尼日尔",
"3": "NE",
"4": "227",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Nigeria",
"2": "尼日利亚",
"3": "NG",
"4": "234",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Norway",
"2": "挪威",
"3": "NO",
"4": "47",
"5": "¥0.263",
"tce_rule_count": "1"
}, {
"1": "Oman",
"2": "阿曼",
"3": "OM",
"4": "968",
"5": "¥0.053",
"tce_rule_count": "1"
}, {
"1": "Pakistan",
"2": "巴基斯坦",
"3": "PK",
"4": "92",
"5": "¥0.042",
"tce_rule_count": "1"
}, {
"1": "Palau",
"2": "帕劳",
"3": "PW",
"4": "680",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Palestine",
"2": "巴勒斯坦",
"3": "BL",
"4": "970",
"5": "¥0.397",
"tce_rule_count": "1"
}, {
"1": "Panama",
"2": "巴拿马",
"3": "PA",
"4": "507",
"5": "¥0.407",
"tce_rule_count": "1"
}, {
"1": "Papua New Guinea",
"2": "巴布亚新几内亚",
"3": "PG",
"4": "675",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Paraguay",
"2": "巴拉圭",
"3": "PY",
"4": "595",
"5": "¥0.042",
"tce_rule_count": "1"
}, {
"1": "Peru",
"2": "秘鲁",
"3": "PE",
"4": "51",
"5": "¥0.357",
"tce_rule_count": "1"
}, {
"1": "Philippines",
"2": "菲律宾",
"3": "PH",
"4": "63",
"5": "¥0.137",
"tce_rule_count": "1"
}, {
"1": "Poland",
"2": "波兰",
"3": "PL",
"4": "48",
"5": "¥0.305",
"tce_rule_count": "1"
}, {
"1": "Portugal",
"2": "葡萄牙",
"3": "PT",
"4": "351",
"5": "¥0.393",
"tce_rule_count": "1"
}, {
"1": "Puerto Rico",
"2": "波多黎各",
"3": "PR",
"4": "1787",
"5": "¥0.053",
"tce_rule_count": "1"
}, {
"1": "Qatar",
"2": "卡塔尔",
"3": "QA",
"4": "974",
"5": "¥0.273",
"tce_rule_count": "1"
}, {
"1": "Republic Of The Congo",
"2": "刚果共和国",
"3": "CG",
"4": "242",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Réunion Island",
"2": "留尼汪",
"3": "RE",
"4": "262",
"5": "¥0.116",
"tce_rule_count": "1"
}, {
"1": "Romania",
"2": "罗马尼亚",
"3": "RO",
"4": "40",
"5": "¥0.357",
"tce_rule_count": "1"
}, {
"1": "Russia",
"2": "俄罗斯",
"3": "RU",
"4": "7",
"5": "¥0.105",
"tce_rule_count": "1"
}, {
"1": "Rwanda",
"2": "卢旺达",
"3": "RW",
"4": "250",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Saint Kitts and Nevis",
"2": "圣基茨和尼维斯",
"3": "KN",
"4": "1869",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Saint Lucia",
"2": "圣露西亚",
"3": "LC",
"4": "1758",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Saint Pierre and Miquelon",
"2": "圣彼埃尔和密克隆岛",
"3": "PM",
"4": "508",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Saint Vincent and The Grenadines",
"2": "圣文森特和格林纳丁斯",
"3": "VC",
"4": "1784",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Samoa",
"2": "萨摩亚",
"3": "WS",
"4": "685",
"5": "¥0.273",
"tce_rule_count": "1"
}, {
"1": "San Marino",
"2": "圣马力诺",
"3": "SM",
"4": "378",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Sao Tome and Principe",
"2": "圣多美和普林西比",
"3": "ST",
"4": "239",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Saudi Arabia",
"2": "沙特阿拉伯",
"3": "SA",
"4": "966",
"5": "¥0.189",
"tce_rule_count": "1"
}, {
"1": "Senegal",
"2": "塞内加尔",
"3": "SN",
"4": "221",
"5": "¥0.399",
"tce_rule_count": "1"
}, {
"1": "Serbia",
"2": "塞尔维亚",
"3": "RS",
"4": "381",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Seychelles",
"2": "塞舌尔",
"3": "SC",
"4": "248",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Sierra Leone",
"2": "塞拉利昂",
"3": "SL",
"4": "232",
"5": "¥0.221",
"tce_rule_count": "1"
}, {
"1": "Singapore",
"2": "新加坡",
"3": "SG",
"4": "65",
"5": "¥0.180",
"tce_rule_count": "1"
}, {
"1": "Sint Maarten (Dutch Part)",
"2": "圣马丁岛（荷兰部分）",
"3": "SX",
"4": "1721",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Slovakia",
"2": "斯洛伐克",
"3": "SK",
"4": "421",
"5": "¥0.399",
"tce_rule_count": "1"
}, {
"1": "Slovenia",
"2": "斯洛文尼亚",
"3": "SI",
"4": "386",
"5": "¥0.210",
"tce_rule_count": "1"
}, {
"1": "Solomon Islands",
"2": "所罗门群岛",
"3": "SB",
"4": "677",
"5": "¥0.392",
"tce_rule_count": "1"
}, {
"1": "Somalia",
"2": "索马里",
"3": "SO",
"4": "252",
"5": "¥0.210",
"tce_rule_count": "1"
}, {
"1": "South Africa",
"2": "南非",
"3": "ZA",
"4": "27",
"5": "¥0.154",
"tce_rule_count": "1"
}, {
"1": "South Korea",
"2": "韩国",
"3": "KR",
"4": "82",
"5": "¥0.252",
"tce_rule_count": "1"
}, {
"1": "Spain",
"2": "西班牙",
"3": "ES",
"4": "34",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Sri Lanka",
"2": "斯里兰卡",
"3": "LK",
"4": "94",
"5": "¥0.273",
"tce_rule_count": "1"
}, {
"1": "Sudan",
"2": "苏丹",
"3": "SD",
"4": "249",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Suriname",
"2": "苏里南",
"3": "SR",
"4": "597",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Swaziland",
"2": "斯威士兰",
"3": "SZ",
"4": "268",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Sweden",
"2": "瑞典",
"3": "SE",
"4": "46",
"5": "¥0.242",
"tce_rule_count": "1"
}, {
"1": "Switzerland",
"2": "瑞士",
"3": "CH",
"4": "41",
"5": "¥0.294",
"tce_rule_count": "1"
}, {
"1": "Syria",
"2": "叙利亚",
"3": "SY",
"4": "963",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Taiwan",
"2": "中国台湾",
"3": "TW",
"4": "886",
"5": "¥0.257",
"tce_rule_count": "1"
}, {
"1": "Tajikistan",
"2": "塔吉克斯坦",
"3": "TJ",
"4": "992",
"5": "¥0.042",
"tce_rule_count": "1"
}, {
"1": "Tanzania",
"2": "坦桑尼亚",
"3": "TZ",
"4": "255",
"5": "¥0.336",
"tce_rule_count": "1"
}, {
"1": "Thailand",
"2": "泰国",
"3": "TH",
"4": "66",
"5": "¥0.148",
"tce_rule_count": "1"
}, {
"1": "Timor-Leste",
"2": "东帝汶",
"3": "TL",
"4": "670",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Togo",
"2": "多哥",
"3": "TG",
"4": "228",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Tonga",
"2": "汤加",
"3": "TO",
"4": "676",
"5": "¥0.074",
"tce_rule_count": "1"
}, {
"1": "Trinidad and Tobago",
"2": "特立尼达和多巴哥",
"3": "TT",
"4": "1868",
"5": "¥0.137",
"tce_rule_count": "1"
}, {
"1": "Tunisia",
"2": "突尼斯",
"3": "TN",
"4": "216",
"5": "¥0.221",
"tce_rule_count": "1"
}, {
"1": "Turkey",
"2": "土耳其",
"3": "TR",
"4": "90",
"5": "¥0.189",
"tce_rule_count": "1"
}, {
"1": "Turkmenistan",
"2": "土库曼斯坦",
"3": "TM",
"4": "993",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Turks and Caicos Islands",
"2": "特克斯和凯科斯群岛",
"3": "TC",
"4": "1649",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Uganda",
"2": "乌干达",
"3": "UG",
"4": "256",
"5": "¥0.242",
"tce_rule_count": "1"
}, {
"1": "Ukraine",
"2": "乌克兰",
"3": "UA",
"4": "380",
"5": "¥0.246",
"tce_rule_count": "1"
}, {
"1": "United Arab Emirates",
"2": "阿拉伯联合酋长国",
"3": "AE",
"4": "971",
"5": "¥0.179",
"tce_rule_count": "1"
}, {
"1": "United Kingdom",
"2": "英国",
"3": "GB",
"4": "44",
"5": "¥0.242",
"tce_rule_count": "1"
}, {
"1": "United States",
"2": "美国",
"3": "US",
"4": "1",
"5": "¥0.042",
"tce_rule_count": "1"
}, {
"1": "Uruguay",
"2": "乌拉圭",
"3": "UY",
"4": "598",
"5": "¥0.341",
"tce_rule_count": "1"
}, {
"1": "Uzbekistan",
"2": "乌兹别克斯坦",
"3": "UZ",
"4": "998",
"5": "¥0.095",
"tce_rule_count": "1"
}, {
"1": "Vanuatu",
"2": "瓦努阿图",
"3": "VU",
"4": "678",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Venezuela",
"2": "委内瑞拉",
"3": "VE",
"4": "58",
"5": "¥0.221",
"tce_rule_count": "1"
}, {
"1": "Vietnam",
"2": "越南",
"3": "VN",
"4": "84",
"5": "¥0.210",
"tce_rule_count": "1"
}, {
"1": "Virgin Islands, British",
"2": "英属处女群岛",
"3": "VG",
"4": "1340",
"5": "¥0.210",
"tce_rule_count": "1"
}, {
"1": "Virgin Islands, US",
"2": "美属维尔京群岛",
"3": "VI",
"4": "1284",
"5": "¥0.429",
"tce_rule_count": "1"
}, {
"1": "Yemen",
"2": "也门",
"3": "YE",
"4": "967",
"5": "¥0.063",
"tce_rule_count": "1"
}, {
"1": "Zambia",
"2": "赞比亚",
"3": "ZM",
"4": "260",
"5": "¥0.315",
"tce_rule_count": "1"
}, {
"1": "Zimbabwe",
"2": "津巴布韦",
"3": "ZW",
"4": "263",
"5": "¥0.137",
"tce_rule_count": "1"
}]
经过一个php脚本，轻松搞定！
<?php
// 从文件中读取数据到PHP变量
$json_string = file_get_contents('data.json');
// 用参数true把JSON字符串强制转成PHP数组
$data = json_decode($json_string, true);
// 显示出来看看
// var_dump($json_string);
print_r($data);
$file = "./phone_code.sql";
foreach ($data as $k => $v) {
$insert_str = "INSERT INTO `tf_phone_nation` VALUES (NULL,'".$v[1]."','".$v[2]."','".$v[3]."','".$v[4]."',0);".PHP_EOL;
file_put_contents($file, $insert_str,FILE_APPEND);
}
轻轻一执行，得到无数条数据，不用脑仁疼了。这大概就是技术的魅力。
INSERT INTO `tf_phone_nation` VALUES (NULL,'Afghanistan','阿富汗','AF','93',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Albania','阿尔巴尼亚','AL','355',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Algeria','阿尔及利亚','DZ','213',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'American Samoa','美属萨摩亚','AS','1684',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Andorra','安道尔','AD','376',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Angola','安哥拉','AO','244',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Anguilla','安圭拉','AI','1264',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Antigua and Barbuda','安提瓜和巴布达','AG','1268',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Argentina','阿根廷','AR','54',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Armenia','亚美尼亚','AM','374',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Aruba','阿鲁巴','AW','297',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Australia','澳大利亚','AU','61',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Austria','奥地利','AT','43',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Azerbaijan','阿塞拜疆','AZ','994',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bahamas','巴哈马','BS','1242',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bahrain','巴林','BH','973',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bangladesh','孟加拉国','BD','880',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Barbados','巴巴多斯','BB','1246',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Belarus','白俄罗斯','BY','375',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Belgium','比利时','BE','32',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Belize','伯利兹','BZ','501',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Benin','贝宁','BJ','229',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bermuda','百慕大群岛','BM','1441',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bhutan','不丹','BT','975',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bolivia','玻利维亚','BO','591',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bosnia and Herzegovina','波斯尼亚和黑塞哥维那','BA','387',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Botswana','博茨瓦纳','BW','267',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Brazil','巴西','BR','55',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Brunei','文莱','BN','673',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bulgaria','保加利亚','BG','359',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Burkina Faso','布基纳法索','BF','226',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Burundi','布隆迪','BI','257',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cambodia','柬埔寨','KH','855',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cameroon','喀麦隆','CM','237',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cape Verde','开普','CV','238',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cayman Islands','开曼群岛','KY','1345',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Central African Republic','中非共和国','CF','236',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Chad','乍得','TD','235',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Chile','智利','CL','56',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Colombia','哥伦比亚','CO','57',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Comoros','科摩罗','KM','269',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cook Islands','库克群岛','CK','682',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Costa Rica','哥斯达黎加','CR','506',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Croatia','克罗地亚','HR','385',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cuba','古巴','CU','53',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Curacao','库拉索','CW','599',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cyprus','塞浦路斯','CY','357',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Czech','捷克','CZ','420',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Democratic Republic of the Congo','刚果民主共和国','CD','243',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Denmark','丹麦','DK','45',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Djibouti','吉布提','DJ','253',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Dominica','多米尼加','DM','1767',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Dominican Republic','多米尼加共和国','DO','1809',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'East Timor','东帝汶','TL','670',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ecuador','厄瓜多尔','EC','593',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Egypt','埃及','EG','20',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'El Salvador','萨尔瓦多','SV','503',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Equatorial Guinea','赤道几内亚','GQ','240',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Eritrea','厄立特里亚','ER','291',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Estonia','爱沙尼亚','EE','372',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ethiopia','埃塞俄比亚','ET','251',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Faroe Islands','法罗群岛','FO','298',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Fiji','斐济','FJ','679',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Finland','芬兰','FI','358',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'France','法国','FR','33',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'French Guiana','法属圭亚那','GF','594',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'French Polynesia','法属波利尼西亚','PF','689',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Gabon','加蓬','GA','241',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Gambia','冈比亚','GM','220',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Georgia','格鲁吉亚','GE','995',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Germany','德国','DE','49',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ghana','加纳','GH','233',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Gibraltar','直布罗陀','GI','350',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Greece','希腊','GR','30',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Greenland','格陵兰岛','GL','299',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Grenada','格林纳达','GD','1473',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guadeloupe','瓜德罗普岛','GP','590',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guam','关岛','GU','1671',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guatemala','瓜地马拉','GT','502',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guinea','几内亚','GN','224',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guinea-Bissau','几内亚比绍共和国','GW','245',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guyana','圭亚那','GY','592',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Haiti','海地','HT','509',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Honduras','洪都拉斯','HN','504',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Hong Kong','中国香港','HK','852',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Hungary','匈牙利','HU','36',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Iceland','冰岛','IS','354',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'India','印度','IN','91',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Indonesia','印度尼西亚','ID','62',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Iran','伊朗','IR','98',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Iraq','伊拉克','IQ','964',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ireland','爱尔兰','IE','353',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Israel','以色列','IL','972',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Italy','意大利','IT','39',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ivory Coast','象牙海岸','CI','225',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Jamaica','牙买加','JM','1876',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Japan','日本','JP','81',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Jordan','约旦','JO','962',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kazakhstan','哈萨克斯坦','KZ','7',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kenya','肯尼亚','KE','254',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kiribati','基里巴斯','KI','686',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kuwait','科威特','KW','965',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kyrgyzstan','吉尔吉斯斯坦','KG','996',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Laos','老挝','LA','856',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Latvia','拉脱维亚','LV','371',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Lebanon','黎巴嫩','LB','961',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Lesotho','莱索托','LS','266',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Liberia','利比里亚','LR','231',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Libya','利比亚','LY','218',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Liechtenstein','列支敦士登','LI','423',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Lithuania','立陶宛','LT','370',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Luxembourg','卢森堡','LU','352',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Macau','中国澳门','MO','853',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Macedonia','马其顿','MK','389',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Madagascar','马达加斯加','MG','261',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Malawi','马拉维','MW','265',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Malaysia','马来西亚','MY','60',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Maldives','马尔代夫','MV','960',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mali','马里','ML','223',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Malta','马耳他','MT','356',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Martinique','马提尼克','MQ','596',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mauritania','毛里塔尼亚','MR','222',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mauritius','毛里求斯','MU','230',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mayotte','马约特','YT','269',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mexico','墨西哥','MX','52',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Moldova','摩尔多瓦','MD','373',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Monaco','摩纳哥','MC','377',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mongolia','蒙古','MN','976',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Montenegro','黑山','ME','382',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Montserrat','蒙特塞拉特岛','MS','1664',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Morocco','摩洛哥','MA','212',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mozambique','莫桑比克','MZ','258',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Myanmar','缅甸','MM','95',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Namibia','纳米比亚','NA','264',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Nepal','尼泊尔','NP','977',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Netherlands','荷兰','NL','31',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'New Caledonia','新喀里多尼亚','NC','687',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'New Zealand','新西兰','NZ','64',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Nicaragua','尼加拉瓜','NI','505',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Niger','尼日尔','NE','227',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Nigeria','尼日利亚','NG','234',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Norway','挪威','NO','47',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Oman','阿曼','OM','968',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Pakistan','巴基斯坦','PK','92',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Palau','帕劳','PW','680',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Palestine','巴勒斯坦','BL','970',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Panama','巴拿马','PA','507',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Papua New Guinea','巴布亚新几内亚','PG','675',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Paraguay','巴拉圭','PY','595',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Peru','秘鲁','PE','51',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Philippines','菲律宾','PH','63',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Poland','波兰','PL','48',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Portugal','葡萄牙','PT','351',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Puerto Rico','波多黎各','PR','1787',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Qatar','卡塔尔','QA','974',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Republic Of The Congo','刚果共和国','CG','242',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Réunion Island','留尼汪','RE','262',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Romania','罗马尼亚','RO','40',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Russia','俄罗斯','RU','7',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Rwanda','卢旺达','RW','250',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Saint Kitts and Nevis','圣基茨和尼维斯','KN','1869',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Saint Lucia','圣露西亚','LC','1758',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Saint Pierre and Miquelon','圣彼埃尔和密克隆岛','PM','508',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Saint Vincent and The Grenadines','圣文森特和格林纳丁斯','VC','1784',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Samoa','萨摩亚','WS','685',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'San Marino','圣马力诺','SM','378',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Sao Tome and Principe','圣多美和普林西比','ST','239',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Saudi Arabia','沙特阿拉伯','SA','966',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Senegal','塞内加尔','SN','221',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Serbia','塞尔维亚','RS','381',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Seychelles','塞舌尔','SC','248',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Sierra Leone','塞拉利昂','SL','232',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Singapore','新加坡','SG','65',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Sint Maarten (Dutch Part)','圣马丁岛（荷兰部分）','SX','1721',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Slovakia','斯洛伐克','SK','421',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Slovenia','斯洛文尼亚','SI','386',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Solomon Islands','所罗门群岛','SB','677',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Somalia','索马里','SO','252',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'South Africa','南非','ZA','27',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'South Korea','韩国','KR','82',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Spain','西班牙','ES','34',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Sri Lanka','斯里兰卡','LK','94',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Sudan','苏丹','SD','249',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Suriname','苏里南','SR','597',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Swaziland','斯威士兰','SZ','268',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Sweden','瑞典','SE','46',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Switzerland','瑞士','CH','41',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Syria','叙利亚','SY','963',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Taiwan','中国台湾','TW','886',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Tajikistan','塔吉克斯坦','TJ','992',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Tanzania','坦桑尼亚','TZ','255',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Thailand','泰国','TH','66',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Timor-Leste','东帝汶','TL','670',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Togo','多哥','TG','228',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Tonga','汤加','TO','676',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Trinidad and Tobago','特立尼达和多巴哥','TT','1868',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Tunisia','突尼斯','TN','216',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Turkey','土耳其','TR','90',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Turkmenistan','土库曼斯坦','TM','993',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Turks and Caicos Islands','特克斯和凯科斯群岛','TC','1649',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Uganda','乌干达','UG','256',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ukraine','乌克兰','UA','380',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'United Arab Emirates','阿拉伯联合酋长国','AE','971',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'United Kingdom','英国','GB','44',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'United States','美国','US','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Uruguay','乌拉圭','UY','598',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Uzbekistan','乌兹别克斯坦','UZ','998',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Vanuatu','瓦努阿图','VU','678',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Venezuela','委内瑞拉','VE','58',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Vietnam','越南','VN','84',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Virgin Islands, British','英属处女群岛','VG','1340',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Virgin Islands, US','美属维尔京群岛','VI','1284',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Yemen','也门','YE','967',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Zambia','赞比亚','ZM','260',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Zimbabwe','津巴布韦','ZW','263',0);
最后对顺序继续微调，让常用的在前面显示
INSERT INTO `tf_phone_nation` VALUES (NULL,'China','中国','CN','86',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Hong Kong','中国香港','HK','852',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Macau','中国澳门','MO','853',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Taiwan','中国台湾','TW','886',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'South Korea','韩国','KR','82',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Japan','日本','JP','81',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'United States','美国','US','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Canada','加拿大','CA','1',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'United Kingdom','英国','GB','44',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Singapore','新加坡','SG','65',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Malaysia','马来西亚','MY','60',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Thailand','泰国','TH','66',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Vietnam','越南','VN','84',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Philippines','菲律宾','PH','63',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Indonesia','印度尼西亚','ID','62',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Italy','意大利','IT','39',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Russia','俄罗斯','RU','7',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'New Zealand','新西兰','NZ','64',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Netherlands','荷兰','NL','31',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Sweden','瑞典','SE','46',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Australia','澳大利亚','AU','61',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ukraine','乌克兰','UA','380',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'France','法国','FR','33',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Germany','德国','DE','49',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Spain','西班牙','ES','34',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Afghanistan','阿富汗','AF','93',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Albania','阿尔巴尼亚','AL','355',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Algeria','阿尔及利亚','DZ','213',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'American Samoa','美属萨摩亚','AS','1684',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Andorra','安道尔','AD','376',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Angola','安哥拉','AO','244',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Anguilla','安圭拉','AI','1264',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Antigua and Barbuda','安提瓜和巴布达','AG','1268',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Argentina','阿根廷','AR','54',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Armenia','亚美尼亚','AM','374',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Aruba','阿鲁巴','AW','297',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Austria','奥地利','AT','43',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Azerbaijan','阿塞拜疆','AZ','994',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bahamas','巴哈马','BS','1242',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bahrain','巴林','BH','973',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bangladesh','孟加拉国','BD','880',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Barbados','巴巴多斯','BB','1246',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Belarus','白俄罗斯','BY','375',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Belgium','比利时','BE','32',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Belize','伯利兹','BZ','501',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Benin','贝宁','BJ','229',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bermuda','百慕大群岛','BM','1441',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bhutan','不丹','BT','975',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bolivia','玻利维亚','BO','591',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bosnia and Herzegovina','波斯尼亚和黑塞哥维那','BA','387',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Botswana','博茨瓦纳','BW','267',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Brazil','巴西','BR','55',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Brunei','文莱','BN','673',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Bulgaria','保加利亚','BG','359',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Burkina Faso','布基纳法索','BF','226',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Burundi','布隆迪','BI','257',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cambodia','柬埔寨','KH','855',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cameroon','喀麦隆','CM','237',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cape Verde','开普','CV','238',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cayman Islands','开曼群岛','KY','1345',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Central African Republic','中非共和国','CF','236',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Chad','乍得','TD','235',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Chile','智利','CL','56',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Colombia','哥伦比亚','CO','57',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Comoros','科摩罗','KM','269',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cook Islands','库克群岛','CK','682',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Costa Rica','哥斯达黎加','CR','506',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Croatia','克罗地亚','HR','385',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cuba','古巴','CU','53',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Curacao','库拉索','CW','599',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Cyprus','塞浦路斯','CY','357',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Czech','捷克','CZ','420',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Democratic Republic of the Congo','刚果民主共和国','CD','243',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Denmark','丹麦','DK','45',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Djibouti','吉布提','DJ','253',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Dominica','多米尼加','DM','1767',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Dominican Republic','多米尼加共和国','DO','1809',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'East Timor','东帝汶','TL','670',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ecuador','厄瓜多尔','EC','593',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Egypt','埃及','EG','20',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'El Salvador','萨尔瓦多','SV','503',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Equatorial Guinea','赤道几内亚','GQ','240',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Eritrea','厄立特里亚','ER','291',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Estonia','爱沙尼亚','EE','372',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ethiopia','埃塞俄比亚','ET','251',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Faroe Islands','法罗群岛','FO','298',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Fiji','斐济','FJ','679',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Finland','芬兰','FI','358',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'French Guiana','法属圭亚那','GF','594',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'French Polynesia','法属波利尼西亚','PF','689',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Gabon','加蓬','GA','241',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Gambia','冈比亚','GM','220',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Georgia','格鲁吉亚','GE','995',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ghana','加纳','GH','233',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Gibraltar','直布罗陀','GI','350',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Greece','希腊','GR','30',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Greenland','格陵兰岛','GL','299',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Grenada','格林纳达','GD','1473',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guadeloupe','瓜德罗普岛','GP','590',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guam','关岛','GU','1671',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guatemala','瓜地马拉','GT','502',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guinea','几内亚','GN','224',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guinea-Bissau','几内亚比绍共和国','GW','245',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Guyana','圭亚那','GY','592',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Haiti','海地','HT','509',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Honduras','洪都拉斯','HN','504',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Hungary','匈牙利','HU','36',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Iceland','冰岛','IS','354',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'India','印度','IN','91',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Iran','伊朗','IR','98',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Iraq','伊拉克','IQ','964',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ireland','爱尔兰','IE','353',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Israel','以色列','IL','972',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Ivory Coast','象牙海岸','CI','225',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Jamaica','牙买加','JM','1876',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Jordan','约旦','JO','962',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kazakhstan','哈萨克斯坦','KZ','7',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kenya','肯尼亚','KE','254',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kiribati','基里巴斯','KI','686',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kuwait','科威特','KW','965',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Kyrgyzstan','吉尔吉斯斯坦','KG','996',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Laos','老挝','LA','856',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Latvia','拉脱维亚','LV','371',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Lebanon','黎巴嫩','LB','961',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Lesotho','莱索托','LS','266',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Liberia','利比里亚','LR','231',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Libya','利比亚','LY','218',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Liechtenstein','列支敦士登','LI','423',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Lithuania','立陶宛','LT','370',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Luxembourg','卢森堡','LU','352',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Macedonia','马其顿','MK','389',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Madagascar','马达加斯加','MG','261',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Malawi','马拉维','MW','265',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Maldives','马尔代夫','MV','960',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mali','马里','ML','223',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Malta','马耳他','MT','356',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Martinique','马提尼克','MQ','596',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mauritania','毛里塔尼亚','MR','222',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mauritius','毛里求斯','MU','230',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mayotte','马约特','YT','269',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mexico','墨西哥','MX','52',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Moldova','摩尔多瓦','MD','373',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Monaco','摩纳哥','MC','377',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mongolia','蒙古','MN','976',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Montenegro','黑山','ME','382',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Montserrat','蒙特塞拉特岛','MS','1664',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Morocco','摩洛哥','MA','212',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Mozambique','莫桑比克','MZ','258',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Myanmar','缅甸','MM','95',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Namibia','纳米比亚','NA','264',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Nepal','尼泊尔','NP','977',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'New Caledonia','新喀里多尼亚','NC','687',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Nicaragua','尼加拉瓜','NI','505',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Niger','尼日尔','NE','227',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Nigeria','尼日利亚','NG','234',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Norway','挪威','NO','47',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Oman','阿曼','OM','968',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Pakistan','巴基斯坦','PK','92',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Palau','帕劳','PW','680',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Palestine','巴勒斯坦','BL','970',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Panama','巴拿马','PA','507',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Papua New Guinea','巴布亚新几内亚','PG','675',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Paraguay','巴拉圭','PY','595',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Peru','秘鲁','PE','51',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Poland','波兰','PL','48',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Portugal','葡萄牙','PT','351',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Puerto Rico','波多黎各','PR','1787',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Qatar','卡塔尔','QA','974',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Republic Of The Congo','刚果共和国','CG','242',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Réunion Island','留尼汪','RE','262',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Romania','罗马尼亚','RO','40',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Rwanda','卢旺达','RW','250',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Saint Kitts and Nevis','圣基茨和尼维斯','KN','1869',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Saint Lucia','圣露西亚','LC','1758',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Saint Pierre and Miquelon','圣彼埃尔和密克隆岛','PM','508',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Saint Vincent and The Grenadines','圣文森特和格林纳丁斯','VC','1784',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Samoa','萨摩亚','WS','685',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'San Marino','圣马力诺','SM','378',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Sao Tome and Principe','圣多美和普林西比','ST','239',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Saudi Arabia','沙特阿拉伯','SA','966',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Senegal','塞内加尔','SN','221',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Serbia','塞尔维亚','RS','381',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Seychelles','塞舌尔','SC','248',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Sierra Leone','塞拉利昂','SL','232',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Sint Maarten (Dutch Part)','圣马丁岛（荷兰部分）','SX','1721',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Slovakia','斯洛伐克','SK','421',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Slovenia','斯洛文尼亚','SI','386',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Solomon Islands','所罗门群岛','SB','677',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Somalia','索马里','SO','252',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'South Africa','南非','ZA','27',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Sri Lanka','斯里兰卡','LK','94',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Sudan','苏丹','SD','249',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Suriname','苏里南','SR','597',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Swaziland','斯威士兰','SZ','268',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Switzerland','瑞士','CH','41',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Syria','叙利亚','SY','963',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Tajikistan','塔吉克斯坦','TJ','992',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Tanzania','坦桑尼亚','TZ','255',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Timor-Leste','东帝汶','TL','670',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Togo','多哥','TG','228',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Tonga','汤加','TO','676',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Trinidad and Tobago','特立尼达和多巴哥','TT','1868',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Tunisia','突尼斯','TN','216',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Turkey','土耳其','TR','90',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Turkmenistan','土库曼斯坦','TM','993',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Turks and Caicos Islands','特克斯和凯科斯群岛','TC','1649',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Uganda','乌干达','UG','256',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'United Arab Emirates','阿拉伯联合酋长国','AE','971',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Uruguay','乌拉圭','UY','598',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Uzbekistan','乌兹别克斯坦','UZ','998',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Vanuatu','瓦努阿图','VU','678',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Venezuela','委内瑞拉','VE','58',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Virgin Islands, British','英属处女群岛','VG','1340',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Virgin Islands, US','美属维尔京群岛','VI','1284',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Yemen','也门','YE','967',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Zambia','赞比亚','ZM','260',0);
INSERT INTO `tf_phone_nation` VALUES (NULL,'Zimbabwe','津巴布韦','ZW','263',0);
小结：尽量开动脑筋，利用好技术，让技术为生活工作服务。
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· Linux系列：如何用heaptrack跟踪.NET程序的非托管内存泄露
· 开发者必知的日志记录最佳实践
· SQL Server 2025 AI相关能力初探
· Linux系列：如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 被坑几百块钱后，我竟然真的恢复了删除的微信聊天记录！
· 没有Manus邀请码？试试免邀请码的MGX或者开源的OpenManus吧
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· Docker 太简单，K8s 太复杂？w7panel 让容器管理更轻松！
2017-06-06 转化一下解决问题的思路，弯道超车
2016-06-06 php创建token
2014-06-06 PHP大小写：函数名和类名不区分,变量名区分
2014-06-06 Sublime text3使用积累
2013-06-06 代码整洁之道
2013-06-06 TCP/IP 运输层