项目中需要国际手机号前缀,于是乎,找到了一个网页。
于是乎,我就手动的,一个一个录入。
录了一下午,录的我脑仁疼,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脚本,轻松搞定!
$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);
小结:尽量开动脑筋,利用好技术,让技术为生活工作服务。