AKB Forums

Go Back   AKB Forums > Technical sections > Languages, Compilers and Interpreters > Web Development
Home Register Blogs FAQ Members List Calendar Downloads Arcade Mark Forums Read

Web Development Java/PHP/Perl/ASP and more

Troubles when posting message? Click here! :: Проблемы с отправлением сообщения? Нажмите сюда!

Reply
 
LinkBack Thread Tools Display Modes
Old Jun 18, 2003, 10:18   #1
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: Sep 2002
Location: Yerevan
Posts: 892
Rep Power: 7
Reputation: 14
Send a message via ICQ to Aram Ghazanchyan Send a message via MSN to Aram Ghazanchyan
List of Countries in mySQL table

May be someone have lits of countries in mySQL table?
te che haves chka havaqel irar hetevic...
Aram Ghazanchyan is offline   Reply With Quote Quote selected
Old Jun 18, 2003, 13:23   #2
Главный Лысый
 
Pascal's Avatar
 
Join Date: Oct 2001
Location: AM
Posts: 2,829
Rep Power: 8
Reputation: 38
Send a message via ICQ to Pascal
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

----------------------------------------------------
Лысина - это полянка, вытоптанная мыслями.
----------------------------------------------------
Pascal is offline   Reply With Quote Quote selected
Old Jun 19, 2003, 04:51   #3
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: Sep 2002
Location: Yerevan
Posts: 892
Rep Power: 7
Reputation: 14
Send a message via ICQ to Aram Ghazanchyan Send a message via MSN to Aram Ghazanchyan
Ogromnoe spasibo
Aram Ghazanchyan is offline   Reply With Quote Quote selected
Old Jun 20, 2003, 18:36   #4
Stalker
 
Timewind's Avatar
 
Join Date: Sep 2002
Location: Припять
Posts: 847
Rep Power: 7
Reputation: 14
Send a message via ICQ to Timewind Send a message via Skype™ to Timewind
lol

Rub lavn er
dzec idean ....
__________________
... for long you live and high you fly ...
Timewind is offline   Reply With Quote Quote selected
Old Jun 20, 2003, 18:56   #5
ЙЦУКЕН
 
Join Date: Jul 2002
Location: 0x68,0x69,0x72, 0x69,0x6e,0x67, 0x20,0x6e,0x6f, 0x77
Posts: 3,114
Rep Power: 7
Reputation: 10
Send a message via ICQ to nm
INSERT INTO `country_names` (`long_name`, `two_letter`) VALUES ('Address and Routing Parameter Area', 'arpa');

мои приблизительно 0.0000010100 цента ...
nm is offline   Reply With Quote Quote selected
Old Jun 21, 2003, 10:43   #6
панаехавший
 
Obelix's Avatar
 
Join Date: Jun 2003
Location: форпост
Posts: 4,005
Rep Power: 6
Reputation: 10
Send a message via ICQ to Obelix
Vashe dlya takix celey ya zaxoju na kakoy nibud' registracionnik tipa yahoo, nu i progu pishu kakuyu nibud'
__________________
Իսկ ԴՈՒ արդեն վաճառե՞լ ես Հայրենիքդ ռուսներին:

My Exchange Rate Monitor | Իմ Արտարժույթի Մոնիտորը

Obelix is offline   Reply With Quote Quote selected
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 12:20.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
This board was founded on September 29, 2001
Powered by Viper Internet

Affordable Web Hosting | ParevNet

Buy text link