![]() |
![]() | #1 |
Web developer Join Date: 09 2002 Location: Yerevan Age: 40
Posts: 896
Downloads: 1 Uploads: 0
Reputation: 9 | 0 | ![]()
May be someone have lits of countries in mySQL table? te che haves chka havaqel irar hetevic... |
![]() |
![]() | #2 |
Главный Лысый Join Date: 10 2001 Location: AM Age: 43
Posts: 2,829
Downloads: 4 Uploads: 0
Reputation: 28 | 4 | ![]()
Eto dump na moyu bazu domainov pervogo urovnya. Poslednie zapisi kasayutsya domainov, a ostal'nye vzyaty iz ISO 3306, kotoriy i est' standart dlya nazvaniya stran, i ikh perechisleniya. BTW tut takzhe napisany i national codes. # # Table structure for table `country_names` # # Creation: Oct 29, 2001 at 10:04 PM # Last update: Oct 29, 2001 at 10:04 PM # CREATE TABLE `country_names` ( long_name varchar(50) NOT NULL default ' ', two_letter varchar(5) NOT NULL default ' ', KEY long_name(long_name), KEY two_letter(two_letter) ) TYPE=MyISAM; # # Dumping data for table `country_names` # INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('AFGHANISTAN', 'AF'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ALBANIA', 'AL'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ALGERIA', 'DZ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('AMERICAN SAMOA', 'AS'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ANDORRA', 'AD'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ANGOLA', 'AO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ANGUILLA', 'AI'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ANTARCTICA', 'AQ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ANTIGUA AND BARBUDA', 'AG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ARGENTINA', 'AR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ARMENIA', 'AM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ARUBA', 'AW'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('AUSTRALIA', 'AU'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('AUSTRIA', 'AT'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('AZERBAIJAN', 'AZ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BAHAMAS', 'BS'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BAHRAIN', 'BH'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BANGLADESH', 'BD'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BARBADOS', 'BB'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BELARUS', 'BY'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BELGIUM', 'BE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BELIZE', 'BZ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BENIN', 'BJ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BERMUDA', 'BM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BHUTAN', 'BT'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BOLIVIA', 'BO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BOSNIA AND HERZEGOWINA', 'BA'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BOTSWANA', 'BW'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BOUVET ISLAND', 'BV'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BRAZIL', 'BR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BRITISH INDIAN OCEAN TERRITORY', 'IO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BRUNEI DARUSSALAM', 'BN'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BULGARIA', 'BG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BURKINA FASO', 'BF'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('BURUNDI', 'BI'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CAMBODIA', 'KH'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CAMEROON', 'CM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CANADA', 'CA'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CAPE VERDE', 'CV'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CAYMAN ISLANDS', 'KY'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CENTRAL AFRICAN REPUBLIC', 'CF'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CHAD', 'TD'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CHILE', 'CL'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CHINA', 'CN'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CHRISTMAS ISLAND', 'CX'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('COCOS (KEELING) ISLANDS', 'CC'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('COLOMBIA', 'CO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('COMOROS', 'KM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CONGO', 'CG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'CD'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('COOK ISLANDS', 'CK'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('COSTA RICA', 'CR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('COTE D\'IVOIRE', 'CI'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CROATIA (local name: Hrvatska)', 'HR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CUBA', 'CU'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CYPRUS', 'CY'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('CZECH REPUBLIC', 'CZ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('DENMARK', 'DK'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('DJIBOUTI', 'DJ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('DOMINICA', 'DM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('DOMINICAN REPUBLIC', 'DO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('EAST TIMOR', 'TP'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ECUADOR', 'EC'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('EGYPT', 'EG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('EL SALVADOR', 'SV'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('EQUATORIAL GUINEA', 'GQ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ERITREA', 'ER'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ESTONIA', 'EE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ETHIOPIA', 'ET'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('FALKLAND ISLANDS (MALVINAS)', 'FK'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('FAROE ISLANDS', 'FO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('FIJI', 'FJ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('FINLAND', 'FI'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('FRANCE', 'FR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('FRANCE, METROPOLITAN', 'FX'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('FRENCH GUIANA', 'GF'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('FRENCH POLYNESIA', 'PF'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('FRENCH SOUTHERN TERRITORIES', 'TF'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GABON', 'GA'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GAMBIA', 'GM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GEORGIA', 'GE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GERMANY', 'DE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GHANA', 'GH'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GIBRALTAR', 'GI'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GREECE', 'GR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GREENLAND', 'GL'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GRENADA', 'GD'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GUADELOUPE', 'GP'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GUAM', 'GU'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GUATEMALA', 'GT'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GUINEA', 'GN'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GUINEA-BISSAU', 'GW'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('GUYANA', 'GY'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('HAITI', 'HT'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('HEARD AND MC DONALD ISLANDS', 'HM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('HOLY SEE (VATICAN CITY STATE)', 'VA'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('HONDURAS', 'HN'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('HONG KONG', 'HK'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('HUNGARY', 'HU'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ICELAND', 'IS'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('INDIA', 'IN'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('INDONESIA', 'ID'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('IRAN (ISLAMIC REPUBLIC OF)', 'IR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('IRAQ', 'IQ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('IRELAND', 'IE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ISRAEL', 'IL'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ITALY', 'IT'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('JAMAICA', 'JM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('JAPAN', 'JP'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('JORDAN', 'JO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('KAZAKHSTAN', 'KZ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('KENYA', 'KE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('KIRIBATI', 'KI'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF', 'KP'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('KOREA, REPUBLIC OF', 'KR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('KUWAIT', 'KW'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('KYRGYZSTAN', 'KG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('LAO PEOPLE\'S DEMOCRATIC REPUBLIC', 'LA'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('LATVIA', 'LV'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('LEBANON', 'LB'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('LESOTHO', 'LS'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('LIBERIA', 'LR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('LIBYAN ARAB JAMAHIRIYA', 'LY'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('LIECHTENSTEIN', 'LI'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('LITHUANIA', 'LT'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('LUXEMBOURG', 'LU'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MACAU', 'MO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'MK'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MADAGASCAR', 'MG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MALAWI', 'MW'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MALAYSIA', 'MY'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MALDIVES', 'MV'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MALI', 'ML'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MALTA', 'MT'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MARSHALL ISLANDS', 'MH'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MARTINIQUE', 'MQ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MAURITANIA', 'MR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MAURITIUS', 'MU'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MAYOTTE', 'YT'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MEXICO', 'MX'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MICRONESIA, FEDERATED STATES OF', 'FM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MOLDOVA, REPUBLIC OF', 'MD'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MONACO', 'MC'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MONGOLIA', 'MN'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MONTSERRAT', 'MS'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MOROCCO', 'MA'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MOZAMBIQUE', 'MZ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('MYANMAR', 'MM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NAMIBIA', 'NA'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NAURU', 'NR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NEPAL', 'NP'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NETHERLANDS', 'NL'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NETHERLANDS ANTILLES', 'AN'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NEW CALEDONIA', 'NC'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NEW ZEALAND', 'NZ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NICARAGUA', 'NI'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NIGER', 'NE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NIGERIA', 'NG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NIUE', 'NU'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NORFOLK ISLAND', 'NF'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NORTHERN MARIANA ISLANDS', 'MP'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('NORWAY', 'NO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('OMAN', 'OM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('PAKISTAN', 'PK'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('PALAU', 'PW'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('PANAMA', 'PA'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('PAPUA NEW GUINEA', 'PG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('PARAGUAY', 'PY'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('PERU', 'PE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('PHILIPPINES', 'PH'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('PITCAIRN', 'PN'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('POLAND', 'PL'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('PORTUGAL', 'PT'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('PUERTO RICO', 'PR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('QATAR', 'QA'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('REUNION', 'RE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ROMANIA', 'RO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('RUSSIAN FEDERATION', 'RU'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('RWANDA', 'RW'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SAINT KITTS AND NEVIS', 'KN'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SAINT LUCIA', 'LC'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SAINT VINCENT AND THE GRENADINES', 'VC'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SAMOA', 'WS'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SAN MARINO', 'SM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SAO TOME AND PRINCIPE', 'ST'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SAUDI ARABIA', 'SA'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SENEGAL', 'SN'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SEYCHELLES', 'SC'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SIERRA LEONE', 'SL'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SINGAPORE', 'SG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SLOVAKIA (Slovak Republic)', 'SK'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SLOVENIA', 'SI'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SOLOMON ISLANDS', 'SB'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SOMALIA', 'SO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SOUTH AFRICA', 'ZA'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'GS'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SPAIN', 'ES'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SRI LANKA', 'LK'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ST. HELENA', 'SH'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ST. PIERRE AND MIQUELON', 'PM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SUDAN', 'SD'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SURINAME', 'SR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SVALBARD AND JAN MAYEN ISLANDS', 'SJ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SWAZILAND', 'SZ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SWEDEN', 'SE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SWITZERLAND', 'CH'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('SYRIAN ARAB REPUBLIC', 'SY'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('TAIWAN, PROVINCE OF CHINA', 'TW'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('TAJIKISTAN', 'TJ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('TANZANIA, UNITED REPUBLIC OF', 'TZ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('THAILAND', 'TH'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('TOGO', 'TG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('TOKELAU', 'TK'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('TONGA', 'TO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('TRINIDAD AND TOBAGO', 'TT'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('TUNISIA', 'TN'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('TURKEY', 'TR'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('TURKMENISTAN', 'TM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('TURKS AND CAICOS ISLANDS', 'TC'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('TUVALU', 'TV'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('UGANDA', 'UG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('UKRAINE', 'UA'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('UNITED ARAB EMIRATES', 'AE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('UNITED KINGDOM', 'GB'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('UNITED STATES', 'US'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('UNITED STATES MINOR OUTLYING ISLANDS', 'UM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('URUGUAY', 'UY'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('UZBEKISTAN', 'UZ'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('VANUATU', 'VU'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('VENEZUELA', 'VE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('VIET NAM', 'VN'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('VIRGIN ISLANDS (BRITISH)', 'VG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('VIRGIN ISLANDS (U.S.)', 'VI'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('WALLIS AND FUTUNA ISLANDS', 'WF'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('WESTERN SAHARA', 'EH'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('YEMEN', 'YE'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('YUGOSLAVIA', 'YU'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ZAMBIA', 'ZM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('ZIMBABWE', 'ZW'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('Commercial Organisations', 'COM'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('Non-Profit Organizations', 'ORG'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('Military Organizations', 'MIL'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('Informational', 'INFO'); INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('Networks', 'NET');
__________________ Ruben Muradyan Technical Director PanARMENIAN Network: Armenian News ---------------------------------------------------- Лысина - это полянка, вытоптанная мыслями. ---------------------------------------------------- |
![]() |
![]() | #3 |
Web developer Join Date: 09 2002 Location: Yerevan Age: 40
Posts: 896
Downloads: 1 Uploads: 0
Reputation: 9 | 0 | ![]()
Ogromnoe spasibo
|
![]() |
![]() | #5 |
ЙЦУКЕН Join Date: 07 2002 Location: 0x68,0x69,0x72, 0x69,0x6e,0x67, 0x20,0x6e,0x6f, 0x77 Age: 51
Posts: 3,118
Downloads: 0 Uploads: 0
Reputation: 5 | 0 | ![]()
INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('Address and Routing Parameter Area', 'arpa'); мои приблизительно 0.0000010100 цента ... |
![]() |