| Author |
Topic |
|
sparrow37
Posting Yak Master
148 Posts |
 Posted - 2009-06-15 : 02:09:33
|
| Hi all,I have a look up table. I want to insert all countries names and their three digit abbreviation into that table. Like for USA i would insert 'United States' and 'USA' and for india , 'India' , 'IND'. Can someone send me this list in the form of insert sql script.Regards,Asif Hameed |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
sparrow37
Posting Yak Master
148 Posts |
Posted - 2009-06-15 : 02:24:50
|
| Hi Khtan,Thanks for your response. I need SQL script which i use and all data is inserted in my table and I dont have to insert country one by one.Regards,Asif Hameed |
 |
|
|
malaytech2008
Yak Posting Veteran
95 Posts |
Posted - 2009-06-15 : 03:00:20
|
| You can copy the data from the link provided to you in a excel sheet. Then import the data from excel sheet using Openrowset() and insert into the desired table.Malay |
|
|
|
sparrow37
Posting Yak Master
148 Posts |
Posted - 2009-06-15 : 03:04:01
|
| I have tried pasting in excel but it has an image before country name. so no luck |
|
|
|
malaytech2008
Yak Posting Veteran
95 Posts |
Posted - 2009-06-15 : 03:11:05
|
| You can find some other links for the data and do the same again..Malay |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-15 : 03:14:35
|
quote:
Originally posted by sparrow37
I have tried pasting in excel but it has an image before country name. so no luck
save the page. Open the html with word, select & copy the table and paste into excel
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
sparrow37
Posting Yak Master
148 Posts |
Posted - 2009-06-15 : 03:16:41
|
| Can some one send me script or links please. I am sure some one must have this script. |
|
|
|
sparrow37
Posting Yak Master
148 Posts |
Posted - 2009-06-15 : 06:36:22
|
| I have tried copying and pasting to excel but there is a flag with each country name. how to remove this |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-15 : 06:59:42
|
[code]INSERT Country (Name, bigram, trigram, num) values ('Afghanistan', 'AF', 'AFG', 4)INSERT Country (Name, bigram, trigram, num) values ('Aland Islands ? Åland Islands', 'AX', 'ALA', 248)INSERT Country (Name, bigram, trigram, num) values ('Albania', 'AL', 'ALB', 8)INSERT Country (Name, bigram, trigram, num) values ('Algeria', 'DZ', 'DZA', 12)INSERT Country (Name, bigram, trigram, num) values ('American Samoa', 'AS', 'ASM', 16)INSERT Country (Name, bigram, trigram, num) values ('Andorra', 'AD', 'AND', 20)INSERT Country (Name, bigram, trigram, num) values ('Angola', 'AO', 'AGO', 24)INSERT Country (Name, bigram, trigram, num) values ('Anguilla', 'AI', 'AIA', 660)INSERT Country (Name, bigram, trigram, num) values ('Antarctica', 'AQ', 'ATA', 10)INSERT Country (Name, bigram, trigram, num) values ('Antigua and Barbuda', 'AG', 'ATG', 28)INSERT Country (Name, bigram, trigram, num) values ('Argentina', 'AR', 'ARG', 32)INSERT Country (Name, bigram, trigram, num) values ('Armenia', 'AM', 'ARM', 51)INSERT Country (Name, bigram, trigram, num) values ('Aruba', 'AW', 'ABW', 533)INSERT Country (Name, bigram, trigram, num) values ('Australia', 'AU', 'AUS', 36)INSERT Country (Name, bigram, trigram, num) values ('Austria', 'AT', 'AUT', 40)INSERT Country (Name, bigram, trigram, num) values ('Azerbaijan', 'AZ', 'AZE', 31)INSERT Country (Name, bigram, trigram, num) values ('Bahamas', 'BS', 'BHS', 44)INSERT Country (Name, bigram, trigram, num) values ('Bahrain', 'BH', 'BHR', 48)INSERT Country (Name, bigram, trigram, num) values ('Bangladesh', 'BD', 'BGD', 50)INSERT Country (Name, bigram, trigram, num) values ('Barbados', 'BB', 'BRB', 52)INSERT Country (Name, bigram, trigram, num) values ('Belarus', 'BY', 'BLR', 112)INSERT Country (Name, bigram, trigram, num) values ('Belgium', 'BE', 'BEL', 56)INSERT Country (Name, bigram, trigram, num) values ('Belize', 'BZ', 'BLZ', 84)INSERT Country (Name, bigram, trigram, num) values ('Benin', 'BJ', 'BEN', 204)INSERT Country (Name, bigram, trigram, num) values ('Bermuda', 'BM', 'BMU', 60)INSERT Country (Name, bigram, trigram, num) values ('Bhutan', 'BT', 'BTN', 64)INSERT Country (Name, bigram, trigram, num) values ('Bolivia, Plurinational State of', 'BO', 'BOL', 68)INSERT Country (Name, bigram, trigram, num) values ('Bosnia and Herzegovina', 'BA', 'BIH', 70)INSERT Country (Name, bigram, trigram, num) values ('Botswana', 'BW', 'BWA', 72)INSERT Country (Name, bigram, trigram, num) values ('Bouvet Island', 'BV', 'BVT', 74)INSERT Country (Name, bigram, trigram, num) values ('Brazil', 'BR', 'BRA', 76)INSERT Country (Name, bigram, trigram, num) values ('British Indian Ocean Territory', 'IO', 'IOT', 86)INSERT Country (Name, bigram, trigram, num) values ('Brunei Darussalam', 'BN', 'BRN', 96)INSERT Country (Name, bigram, trigram, num) values ('Bulgaria', 'BG', 'BGR', 100)INSERT Country (Name, bigram, trigram, num) values ('Burkina Faso', 'BF', 'BFA', 854)INSERT Country (Name, bigram, trigram, num) values ('Burundi', 'BI', 'BDI', 108)INSERT Country (Name, bigram, trigram, num) values ('Cambodia', 'KH', 'KHM', 116)INSERT Country (Name, bigram, trigram, num) values ('Cameroon', 'CM', 'CMR', 120)INSERT Country (Name, bigram, trigram, num) values ('Canada', 'CA', 'CAN', 124)INSERT Country (Name, bigram, trigram, num) values ('Cape Verde', 'CV', 'CPV', 132)INSERT Country (Name, bigram, trigram, num) values ('Cayman Islands', 'KY', 'CYM', 136)INSERT Country (Name, bigram, trigram, num) values ('Central African Republic', 'CF', 'CAF', 140)INSERT Country (Name, bigram, trigram, num) values ('Chad', 'TD', 'TCD', 148)INSERT Country (Name, bigram, trigram, num) values ('Chile', 'CL', 'CHL', 152)INSERT Country (Name, bigram, trigram, num) values ('China', 'CN', 'CHN', 156)INSERT Country (Name, bigram, trigram, num) values ('Christmas Island', 'CX', 'CXR', 162)INSERT Country (Name, bigram, trigram, num) values ('Cocos (Keeling) Islands', 'CC', 'CCK', 166)INSERT Country (Name, bigram, trigram, num) values ('Colombia', 'CO', 'COL', 170)INSERT Country (Name, bigram, trigram, num) values ('Comoros', 'KM', 'COM', 174)INSERT Country (Name, bigram, trigram, num) values ('Congo', 'CG', 'COG', 178)INSERT Country (Name, bigram, trigram, num) values ('Congo, Democratic Republic of the', 'CD', 'COD', 180)INSERT Country (Name, bigram, trigram, num) values ('Cook Islands', 'CK', 'COK', 184)INSERT Country (Name, bigram, trigram, num) values ('Costa Rica', 'CR', 'CRI', 188)INSERT Country (Name, bigram, trigram, num) values ('Cote d''Ivoire ? Côte d''Ivoire', 'CI', 'CIV', 384)INSERT Country (Name, bigram, trigram, num) values ('Croatia', 'HR', 'HRV', 191)INSERT Country (Name, bigram, trigram, num) values ('Cuba', 'CU', 'CUB', 192)INSERT Country (Name, bigram, trigram, num) values ('Cyprus', 'CY', 'CYP', 196)INSERT Country (Name, bigram, trigram, num) values ('Czech Republic', 'CZ', 'CZE', 203)INSERT Country (Name, bigram, trigram, num) values ('Denmark', 'DK', 'DNK', 208)INSERT Country (Name, bigram, trigram, num) values ('Djibouti', 'DJ', 'DJI', 262)INSERT Country (Name, bigram, trigram, num) values ('Dominica', 'DM', 'DMA', 212)INSERT Country (Name, bigram, trigram, num) values ('Dominican Republic', 'DO', 'DOM', 214)INSERT Country (Name, bigram, trigram, num) values ('Ecuador', 'EC', 'ECU', 218)INSERT Country (Name, bigram, trigram, num) values ('Egypt', 'EG', 'EGY', 818)INSERT Country (Name, bigram, trigram, num) values ('El Salvador', 'SV', 'SLV', 222)INSERT Country (Name, bigram, trigram, num) values ('Equatorial Guinea', 'GQ', 'GNQ', 226)INSERT Country (Name, bigram, trigram, num) values ('Eritrea', 'ER', 'ERI', 232)INSERT Country (Name, bigram, trigram, num) values ('Estonia', 'EE', 'EST', 233)INSERT Country (Name, bigram, trigram, num) values ('Ethiopia', 'ET', 'ETH', 231)INSERT Country (Name, bigram, trigram, num) values ('Falkland Islands (Malvinas)', 'FK', 'FLK', 238)INSERT Country (Name, bigram, trigram, num) values ('Faroe Islands', 'FO', 'FRO', 234)INSERT Country (Name, bigram, trigram, num) values ('Fiji', 'FJ', 'FJI', 242)INSERT Country (Name, bigram, trigram, num) values ('Finland', 'FI', 'FIN', 246)INSERT Country (Name, bigram, trigram, num) values ('France', 'FR', 'FRA', 250)INSERT Country (Name, bigram, trigram, num) values ('French Guiana', 'GF', 'GUF', 254)INSERT Country (Name, bigram, trigram, num) values ('French Polynesia', 'PF', 'PYF', 258)INSERT Country (Name, bigram, trigram, num) values ('French Southern Territories', 'TF', 'ATF', 260)INSERT Country (Name, bigram, trigram, num) values ('Gabon', 'GA', 'GAB', 266)INSERT Country (Name, bigram, trigram, num) values ('Gambia', 'GM', 'GMB', 270)INSERT Country (Name, bigram, trigram, num) values ('Georgia', 'GE', 'GEO', 268)INSERT Country (Name, bigram, trigram, num) values ('Germany', 'DE', 'DEU', 276)INSERT Country (Name, bigram, trigram, num) values ('Ghana', 'GH', 'GHA', 288)INSERT Country (Name, bigram, trigram, num) values ('Gibraltar', 'GI', 'GIB', 292)INSERT Country (Name, bigram, trigram, num) values ('Greece', 'GR', 'GRC', 300)INSERT Country (Name, bigram, trigram, num) values ('Greenland', 'GL', 'GRL', 304)INSERT Country (Name, bigram, trigram, num) values ('Grenada', 'GD', 'GRD', 308)INSERT Country (Name, bigram, trigram, num) values ('Guadeloupe', 'GP', 'GLP', 312)INSERT Country (Name, bigram, trigram, num) values ('Guam', 'GU', 'GUM', 316)INSERT Country (Name, bigram, trigram, num) values ('Guatemala', 'GT', 'GTM', 320)INSERT Country (Name, bigram, trigram, num) values ('Guernsey', 'GG', 'GGY', 831)INSERT Country (Name, bigram, trigram, num) values ('Guinea', 'GN', 'GIN', 324)INSERT Country (Name, bigram, trigram, num) values ('Guinea-Bissau', 'GW', 'GNB', 624)INSERT Country (Name, bigram, trigram, num) values ('Guyana', 'GY', 'GUY', 328)INSERT Country (Name, bigram, trigram, num) values ('Haiti', 'HT', 'HTI', 332)INSERT Country (Name, bigram, trigram, num) values ('Heard Island and McDonald Islands', 'HM', 'HMD', 334)INSERT Country (Name, bigram, trigram, num) values ('Holy See (Vatican City State)', 'VA', 'VAT', 336)INSERT Country (Name, bigram, trigram, num) values ('Honduras', 'HN', 'HND', 340)INSERT Country (Name, bigram, trigram, num) values ('Hong Kong', 'HK', 'HKG', 344)INSERT Country (Name, bigram, trigram, num) values ('Hungary', 'HU', 'HUN', 348)INSERT Country (Name, bigram, trigram, num) values ('Iceland', 'IS', 'ISL', 352)INSERT Country (Name, bigram, trigram, num) values ('India', 'IN', 'IND', 356)INSERT Country (Name, bigram, trigram, num) values ('Indonesia', 'ID', 'IDN', 360)INSERT Country (Name, bigram, trigram, num) values ('Iran, Islamic Republic of', 'IR', 'IRN', 364)INSERT Country (Name, bigram, trigram, num) values ('Iraq', 'IQ', 'IRQ', 368)INSERT Country (Name, bigram, trigram, num) values ('Ireland', 'IE', 'IRL', 372)INSERT Country (Name, bigram, trigram, num) values ('Isle of Man', 'IM', 'IMN', 833)INSERT Country (Name, bigram, trigram, num) values ('Israel', 'IL', 'ISR', 376)INSERT Country (Name, bigram, trigram, num) values ('Italy', 'IT', 'ITA', 380)INSERT Country (Name, bigram, trigram, num) values ('Jamaica', 'JM', 'JAM', 388)INSERT Country (Name, bigram, trigram, num) values ('Japan', 'JP', 'JPN', 392)INSERT Country (Name, bigram, trigram, num) values ('Jersey', 'JE', 'JEY', 832)INSERT Country (Name, bigram, trigram, num) values ('Jordan', 'JO', 'JOR', 400)INSERT Country (Name, bigram, trigram, num) values ('Kazakhstan', 'KZ', 'KAZ', 398)INSERT Country (Name, bigram, trigram, num) values ('Kenya', 'KE', 'KEN', 404)INSERT Country (Name, bigram, trigram, num) values ('Kiribati', 'KI', 'KIR', 296)INSERT Country (Name, bigram, trigram, num) values ('Korea, Democratic People''s Republic of', 'KP', 'PRK', 408)INSERT Country (Name, bigram, trigram, num) values ('Korea, Republic of', 'KR', 'KOR', 410)INSERT Country (Name, bigram, trigram, num) values ('Kuwait', 'KW', 'KWT', 414)INSERT Country (Name, bigram, trigram, num) values ('Kyrgyzstan', 'KG', 'KGZ', 417)INSERT Country (Name, bigram, trigram, num) values ('Lao People''s Democratic Republic', 'LA', 'LAO', 418)INSERT Country (Name, bigram, trigram, num) values ('Latvia', 'LV', 'LVA', 428)INSERT Country (Name, bigram, trigram, num) values ('Lebanon', 'LB', 'LBN', 422)INSERT Country (Name, bigram, trigram, num) values ('Lesotho', 'LS', 'LSO', 426)INSERT Country (Name, bigram, trigram, num) values ('Liberia', 'LR', 'LBR', 430)INSERT Country (Name, bigram, trigram, num) values ('Libyan Arab Jamahiriya', 'LY', 'LBY', 434)INSERT Country (Name, bigram, trigram, num) values ('Liechtenstein', 'LI', 'LIE', 438)INSERT Country (Name, bigram, trigram, num) values ('Lithuania', 'LT', 'LTU', 440)INSERT Country (Name, bigram, trigram, num) values ('Luxembourg', 'LU', 'LUX', 442)INSERT Country (Name, bigram, trigram, num) values ('Macao', 'MO', 'MAC', 446)INSERT Country (Name, bigram, trigram, num) values ('Macedonia, the former Yugoslav Republic of', 'MK', 'MKD', 807)INSERT Country (Name, bigram, trigram, num) values ('Madagascar', 'MG', 'MDG', 450)INSERT Country (Name, bigram, trigram, num) values ('Malawi', 'MW', 'MWI', 454)INSERT Country (Name, bigram, trigram, num) values ('Malaysia', 'MY', 'MYS', 458)INSERT Country (Name, bigram, trigram, num) values ('Maldives', 'MV', 'MDV', 462)INSERT Country (Name, bigram, trigram, num) values ('Mali', 'ML', 'MLI', 466)INSERT Country (Name, bigram, trigram, num) values ('Malta', 'MT', 'MLT', 470)INSERT Country (Name, bigram, trigram, num) values ('Marshall Islands', 'MH', 'MHL', 584)INSERT Country (Name, bigram, trigram, num) values ('Martinique', 'MQ', 'MTQ', 474)INSERT Country (Name, bigram, trigram, num) values ('Mauritania', 'MR', 'MRT', 478)INSERT Country (Name, bigram, trigram, num) values ('Mauritius', 'MU', 'MUS', 480)INSERT Country (Name, bigram, trigram, num) values ('Mayotte', 'YT', 'MYT', 175)INSERT Country (Name, bigram, trigram, num) values ('Mexico', 'MX', 'MEX', 484)INSERT Country (Name, bigram, trigram, num) values ('Micronesia, Federated States of', 'FM', 'FSM', 583)INSERT Country (Name, bigram, trigram, num) values ('Moldova, Republic of', 'MD', 'MDA', 498)INSERT Country (Name, bigram, trigram, num) values ('Monaco', 'MC', 'MCO', 492)INSERT Country (Name, bigram, trigram, num) values ('Mongolia', 'MN', 'MNG', 496)INSERT Country (Name, bigram, trigram, num) values ('Montenegro', 'ME', 'MNE', 499)INSERT Country (Name, bigram, trigram, num) values ('Montserrat', 'MS', 'MSR', 500)INSERT Country (Name, bigram, trigram, num) values ('Morocco', 'MA', 'MAR', 504)INSERT Country (Name, bigram, trigram, num) values ('Mozambique', 'MZ', 'MOZ', 508)INSERT Country (Name, bigram, trigram, num) values ('Myanmar', 'MM', 'MMR', 104)INSERT Country (Name, bigram, trigram, num) values ('Namibia', 'NA', 'NAM', 516)INSERT Country (Name, bigram, trigram, num) values ('Nauru', 'NR', 'NRU', 520)INSERT Country (Name, bigram, trigram, num) values ('Nepal', 'NP', 'NPL', 524)INSERT Country (Name, bigram, trigram, num) values ('Netherlands', 'NL', 'NLD', 528)INSERT Country (Name, bigram, trigram, num) values ('Netherlands Antilles', 'AN', 'ANT', 530)INSERT Country (Name, bigram, trigram, num) values ('New Caledonia', 'NC', 'NCL', 540)INSERT Country (Name, bigram, trigram, num) values ('New Zealand', 'NZ', 'NZL', 554)INSERT Country (Name, bigram, trigram, num) values ('Nicaragua', 'NI', 'NIC', 558)INSERT Country (Name, bigram, trigram, num) values ('Niger', 'NE', 'NER', 562)INSERT Country (Name, bigram, trigram, num) values ('Nigeria', 'NG', 'NGA', 566)INSERT Country (Name, bigram, trigram, num) values ('Niue', 'NU', 'NIU', 570)INSERT Country (Name, bigram, trigram, num) values ('Norfolk Island', 'NF', 'NFK', 574)INSERT Country (Name, bigram, trigram, num) values ('Northern Mariana Islands', 'MP', 'MNP', 580)INSERT Country (Name, bigram, trigram, num) values ('Norway', 'NO', 'NOR', 578)INSERT Country (Name, bigram, trigram, num) values ('Oman', 'OM', 'OMN', 512)INSERT Country (Name, bigram, trigram, num) values ('Pakistan', 'PK', 'PAK', 586)INSERT Country (Name, bigram, trigram, num) values ('Palau', 'PW', 'PLW', 585)INSERT Country (Name, bigram, trigram, num) values ('Palestinian Territory, Occupied', 'PS', 'PSE', 275)INSERT Country (Name, bigram, trigram, num) values ('Panama', 'PA', 'PAN', 591)INSERT Country (Name, bigram, trigram, num) values ('Papua New Guinea', 'PG', 'PNG', 598)INSERT Country (Name, bigram, trigram, num) values ('Paraguay', 'PY', 'PRY', 600)INSERT Country (Name, bigram, trigram, num) values ('Peru', 'PE', 'PER', 604)INSERT Country (Name, bigram, trigram, num) values ('Philippines', 'PH', 'PHL', 608)INSERT Country (Name, bigram, trigram, num) values ('Pitcairn', 'PN', 'PCN', 612)INSERT Country (Name, bigram, trigram, num) values ('Poland', 'PL', 'POL', 616)INSERT Country (Name, bigram, trigram, num) values ('Portugal', 'PT', 'PRT', 620)INSERT Country (Name, bigram, trigram, num) values ('Puerto Rico', 'PR', 'PRI', 630)INSERT Country (Name, bigram, trigram, num) values ('Qatar', 'QA', 'QAT', 634)INSERT Country (Name, bigram, trigram, num) values ('Reunion ? Réunion', 'RE', 'REU', 638)INSERT Country (Name, bigram, trigram, num) values ('Romania', 'RO', 'ROU', 642)INSERT Country (Name, bigram, trigram, num) values ('Russian Federation', 'RU', 'RUS', 643)INSERT Country (Name, bigram, trigram, num) values ('Rwanda', 'RW', 'RWA', 646)INSERT Country (Name, bigram, trigram, num) values ('Saint Barthélemy', 'BL', 'BLM', 652)INSERT Country (Name, bigram, trigram, num) values ('Saint Helena', 'SH', 'SHN', 654)INSERT Country (Name, bigram, trigram, num) values ('Saint Kitts and Nevis', 'KN', 'KNA', 659)INSERT Country (Name, bigram, trigram, num) values ('Saint Lucia', 'LC', 'LCA', 662)INSERT Country (Name, bigram, trigram, num) values ('Saint Martin (French part)', 'MF', 'MAF', 663)INSERT Country (Name, bigram, trigram, num) values ('Saint Pierre and Miquelon', 'PM', 'SPM', 666)INSERT Country (Name, bigram, trigram, num) values ('Saint Vincent and the Grenadines', 'VC', 'VCT', 670)INSERT Country (Name, bigram, trigram, num) values ('Samoa', 'WS', 'WSM', 882)INSERT Country (Name, bigram, trigram, num) values ('San Marino', 'SM', 'SMR', 674)INSERT Country (Name, bigram, trigram, num) values ('Sao Tome and Principe', 'ST', 'STP', 678)INSERT Country (Name, bigram, trigram, num) values ('Saudi Arabia', 'SA', 'SAU', 682)INSERT Country (Name, bigram, trigram, num) values ('Senegal', 'SN', 'SEN', 686)INSERT Country (Name, bigram, trigram, num) values ('Serbia', 'RS', 'SRB', 688)INSERT Country (Name, bigram, trigram, num) values ('Seychelles', 'SC', 'SYC', 690)INSERT Country (Name, bigram, trigram, num) values ('Sierra Leone', 'SL', 'SLE', 694)INSERT Country (Name, bigram, trigram, num) values ('Singapore', 'SG', 'SGP', 702)INSERT Country (Name, bigram, trigram, num) values ('Slovakia', 'SK', 'SVK', 703)INSERT Country (Name, bigram, trigram, num) values ('Slovenia', 'SI', 'SVN', 705)INSERT Country (Name, bigram, trigram, num) values ('Solomon Islands', 'SB', 'SLB', 90)INSERT Country (Name, bigram, trigram, num) values ('Somalia', 'SO', 'SOM', 706)INSERT Country (Name, bigram, trigram, num) values ('South Africa', 'ZA', 'ZAF', 710)INSERT Country (Name, bigram, trigram, num) values ('South Georgia and the South Sandwich Islands', 'GS', 'SGS', 239)INSERT Country (Name, bigram, trigram, num) values ('Spain', 'ES', 'ESP', 724)INSERT Country (Name, bigram, trigram, num) values ('Sri Lanka', 'LK', 'LKA', 144)INSERT Country (Name, bigram, trigram, num) values ('Sudan', 'SD', 'SDN', 736)INSERT Country (Name, bigram, trigram, num) values ('Suriname', 'SR', 'SUR', 740)INSERT Country (Name, bigram, trigram, num) values ('Svalbard and Jan Mayen', 'SJ', 'SJM', 744)INSERT Country (Name, bigram, trigram, num) values ('Swaziland', 'SZ', 'SWZ', 748)INSERT Country (Name, bigram, trigram, num) values ('Sweden', 'SE', 'SWE', 752)INSERT Country (Name, bigram, trigram, num) values ('Switzerland', 'CH', 'CHE', 756)INSERT Country (Name, bigram, trigram, num) values ('Syrian Arab Republic', 'SY', 'SYR', 760)INSERT Country (Name, bigram, trigram, num) values ('Taiwan, Province of China', 'TW', 'TWN', 158)INSERT Country (Name, bigram, trigram, num) values ('Tajikistan', 'TJ', 'TJK', 762)INSERT Country (Name, bigram, trigram, num) values ('Tanzania, United Republic of', 'TZ', 'TZA', 834)INSERT Country (Name, bigram, trigram, num) values ('Thailand', 'TH', 'THA', 764)INSERT Country (Name, bigram, trigram, num) values ('Timor-Leste', 'TL', 'TLS', 626)INSERT Country (Name, bigram, trigram, num) values ('Togo', 'TG', 'TGO', 768)INSERT Country (Name, bigram, trigram, num) values ('Tokelau', 'TK', 'TKL', 772)INSERT Country (Name, bigram, trigram, num) values ('Tonga', 'TO', 'TON', 776)INSERT Country (Name, bigram, trigram, num) values ('Trinidad and Tobago', 'TT', 'TTO', 780)INSERT Country (Name, bigram, trigram, num) values ('Tunisia', 'TN', 'TUN', 788)INSERT Country (Name, bigram, trigram, num) values ('Turkey', 'TR', 'TUR', 792)INSERT Country (Name, bigram, trigram, num) values ('Turkmenistan', 'TM', 'TKM', 795)INSERT Country (Name, bigram, trigram, num) values ('Turks and Caicos Islands', 'TC', 'TCA', 796)INSERT Country (Name, bigram, trigram, num) values ('Tuvalu', 'TV', 'TUV', 798)INSERT Country (Name, bigram, trigram, num) values ('Uganda', 'UG', 'UGA', 800)INSERT Country (Name, bigram, trigram, num) values ('Ukraine', 'UA', 'UKR', 804)INSERT Country (Name, bigram, trigram, num) values ('United Arab Emirates', 'AE', 'ARE', 784)INSERT Country (Name, bigram, trigram, num) values ('United Kingdom', 'GB', 'GBR', 826)INSERT Country (Name, bigram, trigram, num) values ('United States', 'US', 'USA', 840)INSERT Country (Name, bigram, trigram, num) values ('United States Minor Outlying Islands', 'UM', 'UMI', 581)INSERT Country (Name, bigram, trigram, num) values ('Uruguay', 'UY', 'URY', 858)INSERT Country (Name, bigram, trigram, num) values ('Uzbekistan', 'UZ', 'UZB', 860)INSERT Country (Name, bigram, trigram, num) values ('Vanuatu', 'VU', 'VUT', 548)INSERT Country (Name, bigram, trigram, num) values ('Venezuela, Bolivarian Republic of', 'VE', 'VEN', 862)INSERT Country (Name, bigram, trigram, num) values ('Viet Nam', 'VN', 'VNM', 704)INSERT Country (Name, bigram, trigram, num) values ('Virgin Islands, British', 'VG', 'VGB', 92)INSERT Country (Name, bigram, trigram, num) values ('Virgin Islands, U.S.', 'VI', 'VIR', 850)INSERT Country (Name, bigram, trigram, num) values ('Wallis and Futuna', 'WF', 'WLF', 876)INSERT Country (Name, bigram, trigram, num) values ('Western Sahara', 'EH', 'ESH', 732)INSERT Country (Name, bigram, trigram, num) values ('Yemen', 'YE', 'YEM', 887)INSERT Country (Name, bigram, trigram, num) values ('Zambia', 'ZM', 'ZMB', 894)INSERT Country (Name, bigram, trigram, num) values ('Zimbabwe', 'ZW', 'ZWE', 716)[/code]
E 12°55'05.63"N 56°04'39.26" |
|
|
|
sparrow37
Posting Yak Master
148 Posts |
Posted - 2009-06-15 : 07:34:35
|
| Thank you very much peso |
|
|
|
|
|
|
countries list