lande databse

Kun navnene eller også lidt info: størrelse,indbyggere, hovedstad, valuta etc. ?

kun navne og et id på hver...

Kan du bruge f.eks. ISO listen (http://www.iso.org/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html) ?

hmm, jeg vill jo egentligt gerne ha en sql fil, der kan blot smider navnene i en db og tildeler dem auto id (auto_increment).

/13

Det er da bare lige at masere dataene lidt

-- MySQL dump 8.22
--
-- Host: localhost    Database: Test
---------------------------------------------------------
-- Server version    3.23.52-max-nt

--
-- Table structure for table 'countrycode'
--

CREATE TABLE countrycode (
  id int(11) NOT NULL auto_increment,
  country varchar(50) default NULL,
  code char(2) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'countrycode'
--


INSERT INTO countrycode VALUES (1,'Afghanistan','AF');
INSERT INTO countrycode VALUES (2,'Åland Islands','AX');
INSERT INTO countrycode VALUES (3,'Albania','AL');
INSERT INTO countrycode VALUES (4,'Algeria','DZ');
INSERT INTO countrycode VALUES (5,'American Samoa','AS');
INSERT INTO countrycode VALUES (6,'Andorra','AD');
INSERT INTO countrycode VALUES (7,'Angola','AO');
INSERT INTO countrycode VALUES (8,'Anguilla','AI');
INSERT INTO countrycode VALUES (9,'Antarctica','AQ');
INSERT INTO countrycode VALUES (10,'Antigua and Barbuda','AG');
INSERT INTO countrycode VALUES (11,'Argentina','AR');
INSERT INTO countrycode VALUES (12,'Armenia','AM');
INSERT INTO countrycode VALUES (13,'Aruba','AW');
INSERT INTO countrycode VALUES (14,'Australia','AU');
INSERT INTO countrycode VALUES (15,'Austria','AT');
INSERT INTO countrycode VALUES (16,'Azerbaijan','AZ');
INSERT INTO countrycode VALUES (17,'Bahamas','BS');
INSERT INTO countrycode VALUES (18,'Bahrain','BH');
INSERT INTO countrycode VALUES (19,'Bangladesh','BD');
INSERT INTO countrycode VALUES (20,'Barbados','BB');
INSERT INTO countrycode VALUES (21,'Belarus','BY');
INSERT INTO countrycode VALUES (22,'Belgium','BE');
INSERT INTO countrycode VALUES (23,'Belize','BZ');
INSERT INTO countrycode VALUES (24,'Benin','BJ');
INSERT INTO countrycode VALUES (25,'Bermuda','BM');
INSERT INTO countrycode VALUES (26,'Bhutan','BT');
INSERT INTO countrycode VALUES (27,'Bolivia','BO');
INSERT INTO countrycode VALUES (28,'Bosnia and Herzegovina','BA');
INSERT INTO countrycode VALUES (29,'Botswana','BW');
INSERT INTO countrycode VALUES (30,'Bouvet Island','BV');
INSERT INTO countrycode VALUES (31,'Brazil','BR');
INSERT INTO countrycode VALUES (32,'British Indian Ocean Territory','IO');
INSERT INTO countrycode VALUES (33,'Brunei Darussalam','BN');
INSERT INTO countrycode VALUES (34,'Bulgaria','BG');
INSERT INTO countrycode VALUES (35,'Burkina Faso','BF');
INSERT INTO countrycode VALUES (36,'Burundi','BI');
INSERT INTO countrycode VALUES (37,'Cambodia','KH');
INSERT INTO countrycode VALUES (38,'Cameroon','CM');
INSERT INTO countrycode VALUES (39,'Canada','CA');
INSERT INTO countrycode VALUES (40,'Cape Verde','CV');
INSERT INTO countrycode VALUES (41,'Cayman Islands','KY');
INSERT INTO countrycode VALUES (42,'Central African Republic','CF');
INSERT INTO countrycode VALUES (43,'Chad','TD');
INSERT INTO countrycode VALUES (44,'Chile','CL');
INSERT INTO countrycode VALUES (45,'China, mainland','CN');
INSERT INTO countrycode VALUES (46,'Christmas Island','CX');
INSERT INTO countrycode VALUES (47,'Cocos (Keeling) Islands','CC');
INSERT INTO countrycode VALUES (48,'Colombia','CO');
INSERT INTO countrycode VALUES (49,'Comoros','KM');
INSERT INTO countrycode VALUES (50,'Congo, Republic of the','CG');
INSERT INTO countrycode VALUES (51,'Congo, The Democratic Republic Of The','CD');
INSERT INTO countrycode VALUES (52,'Cook Islands','CK');
INSERT INTO countrycode VALUES (53,'Costa Rica','CR');
INSERT INTO countrycode VALUES (54,'Côte d\'Ivoire','CI');
INSERT INTO countrycode VALUES (55,'Croatia','HR');
INSERT INTO countrycode VALUES (56,'Cuba','CU');
INSERT INTO countrycode VALUES (57,'Cyprus','CY');
INSERT INTO countrycode VALUES (58,'Czech Republic','CZ');
INSERT INTO countrycode VALUES (59,'Denmark','DK');
INSERT INTO countrycode VALUES (60,'Djibouti','DJ');
INSERT INTO countrycode VALUES (61,'Dominica','DM');
INSERT INTO countrycode VALUES (62,'Dominican Republic','DO');
INSERT INTO countrycode VALUES (63,'Ecuador','EC');
INSERT INTO countrycode VALUES (64,'Egypt','EG');
INSERT INTO countrycode VALUES (65,'El Salvador','SV');
INSERT INTO countrycode VALUES (66,'Equatorial Guinea','GQ');
INSERT INTO countrycode VALUES (67,'Eritrea','ER');
INSERT INTO countrycode VALUES (68,'Estonia','EE');
INSERT INTO countrycode VALUES (69,'Ethiopia','ET');
INSERT INTO countrycode VALUES (70,'Falkland Islands','FK');
INSERT INTO countrycode VALUES (71,'Faroe Islands','FO');
INSERT INTO countrycode VALUES (72,'Fiji','FJ');
INSERT INTO countrycode VALUES (73,'Finland','FI');
INSERT INTO countrycode VALUES (74,'France','FR');
INSERT INTO countrycode VALUES (75,'French Guiana','GF');
INSERT INTO countrycode VALUES (76,'French Polynesia','PF');
INSERT INTO countrycode VALUES (77,'French Southern Territories','TF');
INSERT INTO countrycode VALUES (78,'Gabon','GA');
INSERT INTO countrycode VALUES (79,'Gambia','GM');
INSERT INTO countrycode VALUES (80,'Georgia','GE');
INSERT INTO countrycode VALUES (81,'Germany','DE');
INSERT INTO countrycode VALUES (82,'Ghana','GH');
INSERT INTO countrycode VALUES (83,'Gibraltar','GI');
INSERT INTO countrycode VALUES (84,'Greece','GR');
INSERT INTO countrycode VALUES (85,'Greenland','GL');
INSERT INTO countrycode VALUES (86,'Grenada','GD');
INSERT INTO countrycode VALUES (87,'Guadeloupe','GP');
INSERT INTO countrycode VALUES (88,'Guam','GU');
INSERT INTO countrycode VALUES (89,'Guatemala','GT');
INSERT INTO countrycode VALUES (90,'Guinea','GN');
INSERT INTO countrycode VALUES (91,'Guinea-Bissau','GW');
INSERT INTO countrycode VALUES (92,'Guyana','GY');
INSERT INTO countrycode VALUES (93,'Haiti','HT');
INSERT INTO countrycode VALUES (94,'Heard Island and McDonald Islands','HM');
INSERT INTO countrycode VALUES (95,'Honduras','HN');
INSERT INTO countrycode VALUES (96,'Hong Kong','HK');
INSERT INTO countrycode VALUES (97,'Hungary','HU');
INSERT INTO countrycode VALUES (98,'Iceland','IS');
INSERT INTO countrycode VALUES (99,'India','IN');
INSERT INTO countrycode VALUES (100,'Indonesia','ID');
INSERT INTO countrycode VALUES (101,'Iran, Islamic Republic of','IR');
INSERT INTO countrycode VALUES (102,'Iraq','IQ');
INSERT INTO countrycode VALUES (103,'Ireland','IE');
INSERT INTO countrycode VALUES (104,'Israel','IL');
INSERT INTO countrycode VALUES (105,'Italy','IT');
INSERT INTO countrycode VALUES (106,'Jamaica','JM');
INSERT INTO countrycode VALUES (107,'Japan','JP');
INSERT INTO countrycode VALUES (108,'Jordan','JO');
INSERT INTO countrycode VALUES (109,'Kazakhstan','KZ');
INSERT INTO countrycode VALUES (110,'Kenya','KE');
INSERT INTO countrycode VALUES (111,'Kiribati','KI');
INSERT INTO countrycode VALUES (112,'Korea, Democratic People\'s Republic of','KP');
INSERT INTO countrycode VALUES (113,'Korea, Republic of','KR');
INSERT INTO countrycode VALUES (114,'Kuwait','KW');
INSERT INTO countrycode VALUES (115,'Kyrgyzstan','KG');
INSERT INTO countrycode VALUES (116,'Lao People\'s Democratic Republic','LA');
INSERT INTO countrycode VALUES (117,'Latvia','LV');
INSERT INTO countrycode VALUES (118,'Lebanon','LB');
INSERT INTO countrycode VALUES (119,'Lesotho','LS');
INSERT INTO countrycode VALUES (120,'Liberia','LR');
INSERT INTO countrycode VALUES (121,'Libyan Arab Jamahiriya','LY');
INSERT INTO countrycode VALUES (122,'Liechtenstein','LI');
INSERT INTO countrycode VALUES (123,'Lithuania','LT');
INSERT INTO countrycode VALUES (124,'Luxembourg','LU');
INSERT INTO countrycode VALUES (125,'Macao','MO');
INSERT INTO countrycode VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK');
INSERT INTO countrycode VALUES (127,'Madagascar','MG');
INSERT INTO countrycode VALUES (128,'Malawi','MW');
INSERT INTO countrycode VALUES (129,'Malaysia','MY');
INSERT INTO countrycode VALUES (130,'Maldives','MV');
INSERT INTO countrycode VALUES (131,'Mali','ML');
INSERT INTO countrycode VALUES (132,'Malta','MT');
INSERT INTO countrycode VALUES (133,'Marshall Islands','MH');
INSERT INTO countrycode VALUES (134,'Martinique','MQ');
INSERT INTO countrycode VALUES (135,'Mauritania','MR');
INSERT INTO countrycode VALUES (136,'Mauritius','MU');
INSERT INTO countrycode VALUES (137,'Mayotte','YT');
INSERT INTO countrycode VALUES (138,'Mexico','MX');
INSERT INTO countrycode VALUES (139,'Micronesia, Federated States of','FM');
INSERT INTO countrycode VALUES (140,'Moldova, Republic of','MD');
INSERT INTO countrycode VALUES (141,'Monaco','MC');
INSERT INTO countrycode VALUES (142,'Mongolia','MN');
INSERT INTO countrycode VALUES (143,'Montserrat','MS');
INSERT INTO countrycode VALUES (144,'Morocco','MA');
INSERT INTO countrycode VALUES (145,'Mozambique','MZ');
INSERT INTO countrycode VALUES (146,'Myanmar','MM');
INSERT INTO countrycode VALUES (147,'Namibia','NA');
INSERT INTO countrycode VALUES (148,'Nauru','NR');
INSERT INTO countrycode VALUES (149,'Nepal','NP');
INSERT INTO countrycode VALUES (150,'Netherlands','NL');
INSERT INTO countrycode VALUES (151,'Netherlands Antilles','AN');
INSERT INTO countrycode VALUES (152,'New Caledonia','NC');
INSERT INTO countrycode VALUES (153,'New Zealand','NZ');
INSERT INTO countrycode VALUES (154,'Nicaragua','NI');
INSERT INTO countrycode VALUES (155,'Niger','NE');
INSERT INTO countrycode VALUES (156,'Nigeria','NG');
INSERT INTO countrycode VALUES (157,'Niue','NU');
INSERT INTO countrycode VALUES (158,'Norfolk Island','NF');
INSERT INTO countrycode VALUES (159,'Northern Mariana Islands','MP');
INSERT INTO countrycode VALUES (160,'Norway','NO');
INSERT INTO countrycode VALUES (161,'Oman','OM');
INSERT INTO countrycode VALUES (162,'Pakistan','PK');
INSERT INTO countrycode VALUES (163,'Palau','PW');
INSERT INTO countrycode VALUES (164,'Palestinian Territory, Occupied','PS');
INSERT INTO countrycode VALUES (165,'Panama','PA');
INSERT INTO countrycode VALUES (166,'Papua New Guinea','PG');
INSERT INTO countrycode VALUES (167,'Paraguay','PY');
INSERT INTO countrycode VALUES (168,'Peru','PE');
INSERT INTO countrycode VALUES (169,'Philippines','PH');
INSERT INTO countrycode VALUES (170,'Pitcairn','PN');
INSERT INTO countrycode VALUES (171,'Poland','PL');
INSERT INTO countrycode VALUES (172,'Portugal','PT');
INSERT INTO countrycode VALUES (173,'Puerto Rico','PR');
INSERT INTO countrycode VALUES (174,'Qatar','QA');
INSERT INTO countrycode VALUES (175,'Réunion','RE');
INSERT INTO countrycode VALUES (176,'Romania','RO');
INSERT INTO countrycode VALUES (177,'Russian Federation','RU');
INSERT INTO countrycode VALUES (178,'Rwanda','RW');
INSERT INTO countrycode VALUES (179,'Saint Helena','SH');
INSERT INTO countrycode VALUES (180,'Saint Kitts and Nevis','KN');
INSERT INTO countrycode VALUES (181,'Saint Lucia','LC');
INSERT INTO countrycode VALUES (182,'Saint-Pierre and Miquelon','PM');
INSERT INTO countrycode VALUES (183,'Saint Vincent and the Grenadines','VC');
INSERT INTO countrycode VALUES (184,'Samoa','WS');
INSERT INTO countrycode VALUES (185,'San Marino','SM');
INSERT INTO countrycode VALUES (186,'São Tomé and Príncipe','ST');
INSERT INTO countrycode VALUES (187,'Saudi Arabia','SA');
INSERT INTO countrycode VALUES (188,'Senegal','SN');
INSERT INTO countrycode VALUES (189,'Serbia and Montenegro','CS');
INSERT INTO countrycode VALUES (190,'Seychelles','SC');
INSERT INTO countrycode VALUES (191,'Sierra Leone','SL');
INSERT INTO countrycode VALUES (192,'Singapore','SG');
INSERT INTO countrycode VALUES (193,'Slovakia','SK');
INSERT INTO countrycode VALUES (194,'Slovenia','SI');
INSERT INTO countrycode VALUES (195,'Solomon Islands','SB');
INSERT INTO countrycode VALUES (196,'Somalia','SO');
INSERT INTO countrycode VALUES (197,'South Africa','ZA');
INSERT INTO countrycode VALUES (198,'South Georgia and the South Sandwich Islands','GS');
INSERT INTO countrycode VALUES (199,'Spain','ES');
INSERT INTO countrycode VALUES (200,'Sri Lanka','LK');
INSERT INTO countrycode VALUES (201,'Sudan','SD');
INSERT INTO countrycode VALUES (202,'Suriname','SR');
INSERT INTO countrycode VALUES (203,'Svalbard and Jan Mayen','SJ');
INSERT INTO countrycode VALUES (204,'Swaziland','SZ');
INSERT INTO countrycode VALUES (205,'Sweden','SE');
INSERT INTO countrycode VALUES (206,'Switzerland','CH');
INSERT INTO countrycode VALUES (207,'Syrian Arab Republic','SY');
INSERT INTO countrycode VALUES (208,'Taiwan (Republic of China)','TW');
INSERT INTO countrycode VALUES (209,'Tajikistan','TJ');
INSERT INTO countrycode VALUES (210,'Tanzania, United Republic Of','TZ');
INSERT INTO countrycode VALUES (211,'Thailand','TH');
INSERT INTO countrycode VALUES (212,'Timor-Leste','TL');
INSERT INTO countrycode VALUES (213,'Togo','TG');
INSERT INTO countrycode VALUES (214,'Tokelau','TK');
INSERT INTO countrycode VALUES (215,'Tonga','TO');
INSERT INTO countrycode VALUES (216,'Trinidad and Tobago','TT');
INSERT INTO countrycode VALUES (217,'Tunisia','TN');
INSERT INTO countrycode VALUES (218,'Turkey','TR');
INSERT INTO countrycode VALUES (219,'Turkmenistan','TM');
INSERT INTO countrycode VALUES (220,'Turks and Caicos Islands','TC');
INSERT INTO countrycode VALUES (221,'Tuvalu','TV');
INSERT INTO countrycode VALUES (222,'Uganda','UG');
INSERT INTO countrycode VALUES (223,'Ukraine','UA');
INSERT INTO countrycode VALUES (224,'United Arab Emirates','AE');
INSERT INTO countrycode VALUES (225,'United Kingdom','GB');
INSERT INTO countrycode VALUES (226,'United States','US');
INSERT INTO countrycode VALUES (227,'United States Minor Outlying Islands','UM');
INSERT INTO countrycode VALUES (228,'Uruguay','UY');
INSERT INTO countrycode VALUES (229,'Uzbekistan','UZ');
INSERT INTO countrycode VALUES (230,'Vanuatu','VU');
INSERT INTO countrycode VALUES (231,'Vatican City State','VA');
INSERT INTO countrycode VALUES (232,'Venezuela','VE');
INSERT INTO countrycode VALUES (233,'Viet Nam','VN');
INSERT INTO countrycode VALUES (234,'Virgin Islands, British','VG');
INSERT INTO countrycode VALUES (235,'Virgin Islands, U.S.','VI');
INSERT INTO countrycode VALUES (236,'Wallis and Futuna','WF');
INSERT INTO countrycode VALUES (237,'Western Sahara','EH');
INSERT INTO countrycode VALUES (238,'Yemen','YE');
INSERT INTO countrycode VALUES (239,'Zambia','ZM');
INSERT INTO countrycode VALUES (240,'Zimbabwe','ZW');

hehe, sådan.... Tnx
drop et svar...

/13

kommer her