"Jimmy" <nyhedsgruppe@get3_erstat_3_med_2_net.dk> wrote in message
news:fFT0a.159$jt7.59@news.get2net.dk...
> Hej
>
> Er der nogen der har en database med alle telefon-landekoder i?
Her er en MySQL-DB med 90 indgange, som jeg konstruerede udfra data fundet
på en hjemmeside:
#
# Struktur dump for tabellen `country_codes`
#
CREATE TABLE country_codes (
ID int(10) unsigned NOT NULL auto_increment,
Country_Code int(11) NOT NULL default '0',
Country varchar(50) NOT NULL default '',
PRIMARY KEY (ID)
) TYPE=MyISAM;
#
# Data dump for tabellen `country_codes`
#
INSERT INTO country_codes VALUES (1, 355, 'Albania');
INSERT INTO country_codes VALUES (2, 376, 'Andorra');
INSERT INTO country_codes VALUES (3, 54, 'Argentina');
INSERT INTO country_codes VALUES (4, 374, 'Armenia');
INSERT INTO country_codes VALUES (5, 61, 'Australia');
INSERT INTO country_codes VALUES (6, 43, 'Austria');
INSERT INTO country_codes VALUES (7, 994, 'Azerbaijan');
INSERT INTO country_codes VALUES (8, 973, 'Bahrain');
INSERT INTO country_codes VALUES (9, 880, 'Bangladesh');
INSERT INTO country_codes VALUES (10, 32, 'Belgium');
INSERT INTO country_codes VALUES (11, 387, 'Bosnia-Herzegovina');
INSERT INTO country_codes VALUES (12, 55, 'Brazil');
INSERT INTO country_codes VALUES (13, 673, 'Brunei');
INSERT INTO country_codes VALUES (14, 359, 'Bulgaria');
INSERT INTO country_codes VALUES (15, 855, 'Cambodia');
INSERT INTO country_codes VALUES (16, 1, 'Canada');
INSERT INTO country_codes VALUES (17, 56, 'Chile');
INSERT INTO country_codes VALUES (18, 86, 'China');
INSERT INTO country_codes VALUES (19, 57, 'Columbia');
INSERT INTO country_codes VALUES (20, 506, 'Costa Rica');
INSERT INTO country_codes VALUES (21, 385, 'Croatia');
INSERT INTO country_codes VALUES (22, 357, 'Cyprus');
INSERT INTO country_codes VALUES (23, 420, 'Czech Republic');
INSERT INTO country_codes VALUES (24, 45, 'Denmark');
INSERT INTO country_codes VALUES (25, 1809, 'Dominican Republic');
INSERT INTO country_codes VALUES (26, 593, 'Ecuador');
INSERT INTO country_codes VALUES (27, 20, 'Egypt');
INSERT INTO country_codes VALUES (28, 372, 'Estonia');
INSERT INTO country_codes VALUES (29, 298, 'Faroe Islands');
INSERT INTO country_codes VALUES (30, 358, 'Finland');
INSERT INTO country_codes VALUES (31, 49, 'Germany');
INSERT INTO country_codes VALUES (32, 350, 'Gibraltar');
INSERT INTO country_codes VALUES (33, 30, 'Greece');
INSERT INTO country_codes VALUES (34, 502, 'Guatemala');
INSERT INTO country_codes VALUES (35, 36, 'Hungary');
INSERT INTO country_codes VALUES (36, 354, 'Iceland');
INSERT INTO country_codes VALUES (37, 91, 'India');
INSERT INTO country_codes VALUES (38, 62, 'Indonesia');
INSERT INTO country_codes VALUES (39, 353, 'Ireland');
INSERT INTO country_codes VALUES (40, 972, 'Israel');
INSERT INTO country_codes VALUES (41, 39, 'Italy');
INSERT INTO country_codes VALUES (42, 962, 'Jordania');
INSERT INTO country_codes VALUES (43, 965, 'Kuwait');
INSERT INTO country_codes VALUES (44, 371, 'Latvia');
INSERT INTO country_codes VALUES (45, 961, 'Lebanon');
INSERT INTO country_codes VALUES (46, 423, 'Liechtenstein');
INSERT INTO country_codes VALUES (47, 370, 'Lithuania');
INSERT INTO country_codes VALUES (48, 352, 'Luxembourg');
INSERT INTO country_codes VALUES (49, 853, 'Macau');
INSERT INTO country_codes VALUES (50, 389, 'Macedonia');
INSERT INTO country_codes VALUES (51, 261, 'Madagascar');
INSERT INTO country_codes VALUES (52, 60, 'Malaysia');
INSERT INTO country_codes VALUES (53, 356, 'Malta');
INSERT INTO country_codes VALUES (54, 230, 'Mauricius');
INSERT INTO country_codes VALUES (55, 52, 'Mexico');
INSERT INTO country_codes VALUES (56, 212, 'Morocco');
INSERT INTO country_codes VALUES (57, 31, 'Netherlands');
INSERT INTO country_codes VALUES (58, 64, 'New Zealand');
INSERT INTO country_codes VALUES (59, 47, 'Norway');
INSERT INTO country_codes VALUES (60, 968, 'Oman');
INSERT INTO country_codes VALUES (61, 92, 'Pakistan');
INSERT INTO country_codes VALUES (62, 507, 'Panama');
INSERT INTO country_codes VALUES (63, 51, 'Peru');
INSERT INTO country_codes VALUES (64, 63, 'Philippines');
INSERT INTO country_codes VALUES (65, 48, 'Poland');
INSERT INTO country_codes VALUES (66, 351, 'Portugal');
INSERT INTO country_codes VALUES (67, 1787, 'Puerto Rico');
INSERT INTO country_codes VALUES (68, 40, 'Rumania');
INSERT INTO country_codes VALUES (69, 7, 'Russia');
INSERT INTO country_codes VALUES (70, 966, 'Saudi Arabia');
INSERT INTO country_codes VALUES (71, 65, 'Singapore');
INSERT INTO country_codes VALUES (72, 421, 'Slovak Republic');
INSERT INTO country_codes VALUES (73, 386, 'Slovenia');
INSERT INTO country_codes VALUES (74, 27, 'South Africa');
INSERT INTO country_codes VALUES (75, 34, 'Spain');
INSERT INTO country_codes VALUES (76, 94, 'Sri Lanka');
INSERT INTO country_codes VALUES (77, 46, 'Sweden');
INSERT INTO country_codes VALUES (78, 41, 'Switzerland');
INSERT INTO country_codes VALUES (79, 886, 'Taiwan');
INSERT INTO country_codes VALUES (80, 66, 'Thailand');
INSERT INTO country_codes VALUES (81, 216, 'Tunisia');
INSERT INTO country_codes VALUES (82, 90, 'Turkey');
INSERT INTO country_codes VALUES (83, 380, 'Ukraine');
INSERT INTO country_codes VALUES (84, 971, 'United Arab Emirates');
INSERT INTO country_codes VALUES (85, 44, 'United Kingdom');
INSERT INTO country_codes VALUES (86, 598, 'Uruquay');
INSERT INTO country_codes VALUES (87, 1, 'USA');
INSERT INTO country_codes VALUES (88, 58, 'Venezuela');
INSERT INTO country_codes VALUES (89, 381, 'Yugoslavia');
INSERT INTO country_codes VALUES (90, 263, 'Zimbabwe');
Mvh
Jimmy
|