Armenian Knowledge Base  

Go Back   Armenian Knowledge Base > Technical sections > Webmaster Zone > Web Development
Register

Reply
 
LinkBack Thread Tools
Old 18.06.2003, 11:18   #1
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: 09 2002
Location: Yerevan
Age: 36
Posts: 896
Downloads: 1
Uploads: 0
Reputation: 9 | 0
Default List of Countries in mySQL table

May be someone have lits of countries in mySQL table?
te che haves chka havaqel irar hetevic...
Reply With Quote
Old 18.06.2003, 14:23   #2
Главный Лысый
 
Pascal's Avatar
 
Join Date: 10 2001
Location: AM
Age: 39
Posts: 2,829
Downloads: 4
Uploads: 0
Reputation: 28 | 4
Default

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

----------------------------------------------------
Лысина - это полянка, вытоптанная мыслями.
----------------------------------------------------
Reply With Quote
Old 19.06.2003, 05:51   #3
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: 09 2002
Location: Yerevan
Age: 36
Posts: 896
Downloads: 1
Uploads: 0
Reputation: 9 | 0
Default

Ogromnoe spasibo
Reply With Quote
Old 20.06.2003, 19:36   #4
Stalker
 
Timewind's Avatar
 
Join Date: 09 2002
Location: Припять
Age: 83
Posts: 853
Downloads: 0
Uploads: 0
Reputation: 12 | 3
Default

lol

Rub lavn er
dzec idean ....
Reply With Quote
Old 20.06.2003, 19:56   #5
ЙЦУКЕН
 
Join Date: 07 2002
Location: 0x68,0x69,0x72, 0x69,0x6e,0x67, 0x20,0x6e,0x6f, 0x77
Age: 47
Posts: 3,118
Downloads: 0
Uploads: 0
Reputation: 5 | 0
Default

INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('Address and Routing Parameter Area', 'arpa');

мои приблизительно 0.0000010100 цента ...
Reply With Quote
Old 21.06.2003, 11:43   #6
панаехавший
 
Obelix's Avatar
 
Join Date: 06 2003
Location: форпост
Age: 30
Posts: 4,007
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

Vashe dlya takix celey ya zaxoju na kakoy nibud' registracionnik tipa yahoo, nu i progu pishu kakuyu nibud'
Reply With Quote
Sponsored Links
Reply

Thread Tools


На правах рекламы:
реклама

All times are GMT. The time now is 07:25.


Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.