dansk lande liste

Mon ikke det nemmeste er at tage listen fra denne side:
http://da.wikipedia.org/wiki/Verdens_lande

paste den i notepad og så redigere en lille smule i den...

(tip.. hvis du kopierer fra et print preview, er der næsten ikke noget støj med..)

Joh, men et sql script ville nu spare en del tid :)

Nå, så lavede jeg et baseret på den liste du fandt:
---------------------------------------------------
--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=197 ;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`) VALUES (1, 'Afghanistan');
INSERT INTO `countries` (`id`, `name`) VALUES (2, 'Albanien');
INSERT INTO `countries` (`id`, `name`) VALUES (3, 'Algeriet');
INSERT INTO `countries` (`id`, `name`) VALUES (4, 'Andorra');
INSERT INTO `countries` (`id`, `name`) VALUES (5, 'Angola');
INSERT INTO `countries` (`id`, `name`) VALUES (6, 'Antigua og Barbuda');
INSERT INTO `countries` (`id`, `name`) VALUES (7, 'Argentina');
INSERT INTO `countries` (`id`, `name`) VALUES (8, 'Armenien');
INSERT INTO `countries` (`id`, `name`) VALUES (9, 'Aserbajdsjan');
INSERT INTO `countries` (`id`, `name`) VALUES (10, 'Australien');
INSERT INTO `countries` (`id`, `name`) VALUES (11, 'Bahamas');
INSERT INTO `countries` (`id`, `name`) VALUES (12, 'Bahrain');
INSERT INTO `countries` (`id`, `name`) VALUES (13, 'Bangladesh');
INSERT INTO `countries` (`id`, `name`) VALUES (14, 'Barbados');
INSERT INTO `countries` (`id`, `name`) VALUES (15, 'Belgien');
INSERT INTO `countries` (`id`, `name`) VALUES (16, 'Belize');
INSERT INTO `countries` (`id`, `name`) VALUES (17, 'Benin');
INSERT INTO `countries` (`id`, `name`) VALUES (18, 'Bermuda');
INSERT INTO `countries` (`id`, `name`) VALUES (19, 'Bhutan');
INSERT INTO `countries` (`id`, `name`) VALUES (20, 'Bolivia');
INSERT INTO `countries` (`id`, `name`) VALUES (21, 'Bosnien-Herzegovina');
INSERT INTO `countries` (`id`, `name`) VALUES (22, 'Botswana');
INSERT INTO `countries` (`id`, `name`) VALUES (23, 'Brasilien');
INSERT INTO `countries` (`id`, `name`) VALUES (24, 'Brunei');
INSERT INTO `countries` (`id`, `name`) VALUES (25, 'Bulgarien');
INSERT INTO `countries` (`id`, `name`) VALUES (26, 'Burkina Faso');
INSERT INTO `countries` (`id`, `name`) VALUES (27, 'Burundi');
INSERT INTO `countries` (`id`, `name`) VALUES (28, 'Cambodja');
INSERT INTO `countries` (`id`, `name`) VALUES (29, 'Cameroun');
INSERT INTO `countries` (`id`, `name`) VALUES (30, 'Canada');
INSERT INTO `countries` (`id`, `name`) VALUES (31, 'Chile');
INSERT INTO `countries` (`id`, `name`) VALUES (32, 'Colombia');
INSERT INTO `countries` (`id`, `name`) VALUES (33, 'Comorerne');
INSERT INTO `countries` (`id`, `name`) VALUES (34, 'Congo');
INSERT INTO `countries` (`id`, `name`) VALUES (35, 'Costa Rica');
INSERT INTO `countries` (`id`, `name`) VALUES (36, 'Cuba');
INSERT INTO `countries` (`id`, `name`) VALUES (37, 'Cypern');
INSERT INTO `countries` (`id`, `name`) VALUES (38, 'Danmark');
INSERT INTO `countries` (`id`, `name`) VALUES (39, 'Djibouti');
INSERT INTO `countries` (`id`, `name`) VALUES (40, 'Dominica');
INSERT INTO `countries` (`id`, `name`) VALUES (41, 'Den Dominikanske Republik');
INSERT INTO `countries` (`id`, `name`) VALUES (42, 'Ecuador');
INSERT INTO `countries` (`id`, `name`) VALUES (43, 'Egypten');
INSERT INTO `countries` (`id`, `name`) VALUES (44, 'El Salvador');
INSERT INTO `countries` (`id`, `name`) VALUES (45, 'Elfenbenskysten');
INSERT INTO `countries` (`id`, `name`) VALUES (46, 'Eritrea');
INSERT INTO `countries` (`id`, `name`) VALUES (47, 'Estland');
INSERT INTO `countries` (`id`, `name`) VALUES (48, 'Etiopien');
INSERT INTO `countries` (`id`, `name`) VALUES (49, 'Fiji');
INSERT INTO `countries` (`id`, `name`) VALUES (50, 'Filippinerne');
INSERT INTO `countries` (`id`, `name`) VALUES (51, 'Finland');
INSERT INTO `countries` (`id`, `name`) VALUES (52, 'Forenede Arabiske Emirater');
INSERT INTO `countries` (`id`, `name`) VALUES (53, 'Frankrig');
INSERT INTO `countries` (`id`, `name`) VALUES (54, 'Gabon');
INSERT INTO `countries` (`id`, `name`) VALUES (55, 'Gambia');
INSERT INTO `countries` (`id`, `name`) VALUES (56, 'Georgien');
INSERT INTO `countries` (`id`, `name`) VALUES (57, 'Ghana');
INSERT INTO `countries` (`id`, `name`) VALUES (58, 'Grenada');
INSERT INTO `countries` (`id`, `name`) VALUES (59, 'Grækenland');
INSERT INTO `countries` (`id`, `name`) VALUES (60, 'Guatemala');
INSERT INTO `countries` (`id`, `name`) VALUES (61, 'Guinea');
INSERT INTO `countries` (`id`, `name`) VALUES (62, 'Haiti');
INSERT INTO `countries` (`id`, `name`) VALUES (63, 'Holland');
INSERT INTO `countries` (`id`, `name`) VALUES (64, 'Honduras');
INSERT INTO `countries` (`id`, `name`) VALUES (65, 'Hviderusland');
INSERT INTO `countries` (`id`, `name`) VALUES (66, 'Indien');
INSERT INTO `countries` (`id`, `name`) VALUES (67, 'Indonesien');
INSERT INTO `countries` (`id`, `name`) VALUES (68, 'Irakn');
INSERT INTO `countries` (`id`, `name`) VALUES (69, 'Iran');
INSERT INTO `countries` (`id`, `name`) VALUES (70, 'Irland');
INSERT INTO `countries` (`id`, `name`) VALUES (71, 'Island');
INSERT INTO `countries` (`id`, `name`) VALUES (72, 'Israel');
INSERT INTO `countries` (`id`, `name`) VALUES (73, 'Italien');
INSERT INTO `countries` (`id`, `name`) VALUES (74, 'Jamaica');
INSERT INTO `countries` (`id`, `name`) VALUES (75, 'Japan');
INSERT INTO `countries` (`id`, `name`) VALUES (76, 'Jordan');
INSERT INTO `countries` (`id`, `name`) VALUES (77, 'Kap Verde');
INSERT INTO `countries` (`id`, `name`) VALUES (78, 'Kasakhstan');
INSERT INTO `countries` (`id`, `name`) VALUES (79, 'Kenya');
INSERT INTO `countries` (`id`, `name`) VALUES (80, 'Kina');
INSERT INTO `countries` (`id`, `name`) VALUES (81, 'Kirgisistan');
INSERT INTO `countries` (`id`, `name`) VALUES (82, 'Kiribati');
INSERT INTO `countries` (`id`, `name`) VALUES (83, 'Kroatien');
INSERT INTO `countries` (`id`, `name`) VALUES (84, 'Kuwait');
INSERT INTO `countries` (`id`, `name`) VALUES (85, 'Laos');
INSERT INTO `countries` (`id`, `name`) VALUES (86, 'Lesotho');
INSERT INTO `countries` (`id`, `name`) VALUES (87, 'Letland');
INSERT INTO `countries` (`id`, `name`) VALUES (88, 'Libanon');
INSERT INTO `countries` (`id`, `name`) VALUES (89, 'Liberia');
INSERT INTO `countries` (`id`, `name`) VALUES (90, 'Libyen');
INSERT INTO `countries` (`id`, `name`) VALUES (91, 'Liechtenstein');
INSERT INTO `countries` (`id`, `name`) VALUES (92, 'Litauen');
INSERT INTO `countries` (`id`, `name`) VALUES (93, 'Luxembourg');
INSERT INTO `countries` (`id`, `name`) VALUES (94, 'Madagaskar');
INSERT INTO `countries` (`id`, `name`) VALUES (95, 'Makedonien');
INSERT INTO `countries` (`id`, `name`) VALUES (96, 'Malawi');
INSERT INTO `countries` (`id`, `name`) VALUES (97, 'Malaysia');
INSERT INTO `countries` (`id`, `name`) VALUES (98, 'Maldiverne');
INSERT INTO `countries` (`id`, `name`) VALUES (99, 'Mali');
INSERT INTO `countries` (`id`, `name`) VALUES (100, 'Malta');
INSERT INTO `countries` (`id`, `name`) VALUES (101, 'Marokko');
INSERT INTO `countries` (`id`, `name`) VALUES (102, 'Marshalløerne');
INSERT INTO `countries` (`id`, `name`) VALUES (103, 'Mauretanien');
INSERT INTO `countries` (`id`, `name`) VALUES (104, 'Mauritius');
INSERT INTO `countries` (`id`, `name`) VALUES (105, 'Mexico');
INSERT INTO `countries` (`id`, `name`) VALUES (106, 'Mikronesien');
INSERT INTO `countries` (`id`, `name`) VALUES (107, 'Moldova');
INSERT INTO `countries` (`id`, `name`) VALUES (108, 'Monaco');
INSERT INTO `countries` (`id`, `name`) VALUES (109, 'Mongoliet');
INSERT INTO `countries` (`id`, `name`) VALUES (110, 'Montenegro');
INSERT INTO `countries` (`id`, `name`) VALUES (111, 'Mozambique');
INSERT INTO `countries` (`id`, `name`) VALUES (112, 'Myanmar - tidligere Burma');
INSERT INTO `countries` (`id`, `name`) VALUES (113, 'Namibia');
INSERT INTO `countries` (`id`, `name`) VALUES (114, 'Nauru');
INSERT INTO `countries` (`id`, `name`) VALUES (115, 'Nepal');
INSERT INTO `countries` (`id`, `name`) VALUES (116, 'New Zealand');
INSERT INTO `countries` (`id`, `name`) VALUES (117, 'Nicaragua');
INSERT INTO `countries` (`id`, `name`) VALUES (118, 'Niger');
INSERT INTO `countries` (`id`, `name`) VALUES (119, 'Nigeria');
INSERT INTO `countries` (`id`, `name`) VALUES (120, 'Niue');
INSERT INTO `countries` (`id`, `name`) VALUES (121, 'Nordkorea');
INSERT INTO `countries` (`id`, `name`) VALUES (122, 'Norge');
INSERT INTO `countries` (`id`, `name`) VALUES (123, 'Oman');
INSERT INTO `countries` (`id`, `name`) VALUES (124, 'Pakistan');
INSERT INTO `countries` (`id`, `name`) VALUES (125, 'Palau');
INSERT INTO `countries` (`id`, `name`) VALUES (126, 'De Palæstinensiske Selvstyreområder');
INSERT INTO `countries` (`id`, `name`) VALUES (127, 'Panama');
INSERT INTO `countries` (`id`, `name`) VALUES (128, 'Papua Ny Guinea');
INSERT INTO `countries` (`id`, `name`) VALUES (129, 'Paraguay');
INSERT INTO `countries` (`id`, `name`) VALUES (130, 'Peru');
INSERT INTO `countries` (`id`, `name`) VALUES (131, 'Pitcairn');
INSERT INTO `countries` (`id`, `name`) VALUES (132, 'Polen');
INSERT INTO `countries` (`id`, `name`) VALUES (133, 'Portugal');
INSERT INTO `countries` (`id`, `name`) VALUES (134, 'Puerto Rico');
INSERT INTO `countries` (`id`, `name`) VALUES (135, 'Qatar');
INSERT INTO `countries` (`id`, `name`) VALUES (136, 'Rumænien');
INSERT INTO `countries` (`id`, `name`) VALUES (137, 'Rusland');
INSERT INTO `countries` (`id`, `name`) VALUES (138, 'Saint Kitts og Nevis');
INSERT INTO `countries` (`id`, `name`) VALUES (139, 'Saint Lucia');
INSERT INTO `countries` (`id`, `name`) VALUES (140, 'Saint Vincent og Grenadinerne');
INSERT INTO `countries` (`id`, `name`) VALUES (141, 'Salomonøerne');
INSERT INTO `countries` (`id`, `name`) VALUES (142, 'Samoa');
INSERT INTO `countries` (`id`, `name`) VALUES (143, 'San Marino');
INSERT INTO `countries` (`id`, `name`) VALUES (144, 'Sao TomÈ og Principe');
INSERT INTO `countries` (`id`, `name`) VALUES (145, 'Saudi-Arabien');
INSERT INTO `countries` (`id`, `name`) VALUES (146, 'Schweiz');
INSERT INTO `countries` (`id`, `name`) VALUES (147, 'Senegal');
INSERT INTO `countries` (`id`, `name`) VALUES (148, 'Serbien-Montenegro');
INSERT INTO `countries` (`id`, `name`) VALUES (149, 'Seychellerne');
INSERT INTO `countries` (`id`, `name`) VALUES (150, 'Sierra Leone');
INSERT INTO `countries` (`id`, `name`) VALUES (151, 'Singapore');
INSERT INTO `countries` (`id`, `name`) VALUES (152, 'Slovakiet');
INSERT INTO `countries` (`id`, `name`) VALUES (153, 'Slovenien');
INSERT INTO `countries` (`id`, `name`) VALUES (154, 'Somalia');
INSERT INTO `countries` (`id`, `name`) VALUES (155, 'Spanien');
INSERT INTO `countries` (`id`, `name`) VALUES (156, 'Sri Lanka');
INSERT INTO `countries` (`id`, `name`) VALUES (157, 'Storbritannien');
INSERT INTO `countries` (`id`, `name`) VALUES (158, 'Sudan');
INSERT INTO `countries` (`id`, `name`) VALUES (159, 'Surinam');
INSERT INTO `countries` (`id`, `name`) VALUES (160, 'Sverige');
INSERT INTO `countries` (`id`, `name`) VALUES (161, 'Swaziland');
INSERT INTO `countries` (`id`, `name`) VALUES (162, 'Sydafrika');
INSERT INTO `countries` (`id`, `name`) VALUES (163, 'Sydkorea');
INSERT INTO `countries` (`id`, `name`) VALUES (164, 'Syrien');
INSERT INTO `countries` (`id`, `name`) VALUES (165, 'Tadsjikistan');
INSERT INTO `countries` (`id`, `name`) VALUES (166, 'Taiwan');
INSERT INTO `countries` (`id`, `name`) VALUES (167, 'Tanzania');
INSERT INTO `countries` (`id`, `name`) VALUES (168, 'Tchad');
INSERT INTO `countries` (`id`, `name`) VALUES (169, 'Thailand');
INSERT INTO `countries` (`id`, `name`) VALUES (170, 'Tjekkiet');
INSERT INTO `countries` (`id`, `name`) VALUES (171, 'Togo');
INSERT INTO `countries` (`id`, `name`) VALUES (172, 'Tonga');
INSERT INTO `countries` (`id`, `name`) VALUES (173, 'Trinidad og Tobago');
INSERT INTO `countries` (`id`, `name`) VALUES (174, 'Tunesien');
INSERT INTO `countries` (`id`, `name`) VALUES (175, 'Turkmenistan');
INSERT INTO `countries` (`id`, `name`) VALUES (176, 'Tuvalu');
INSERT INTO `countries` (`id`, `name`) VALUES (177, 'Tyrkiet');
INSERT INTO `countries` (`id`, `name`) VALUES (178, 'Tyskland');
INSERT INTO `countries` (`id`, `name`) VALUES (179, 'Uganda');
INSERT INTO `countries` (`id`, `name`) VALUES (180, 'Ukraine');
INSERT INTO `countries` (`id`, `name`) VALUES (181, 'Ungarn');
INSERT INTO `countries` (`id`, `name`) VALUES (182, 'Uruguay');
INSERT INTO `countries` (`id`, `name`) VALUES (183, 'USA');
INSERT INTO `countries` (`id`, `name`) VALUES (184, 'Usbekistan');
INSERT INTO `countries` (`id`, `name`) VALUES (185, 'Vanuatu');
INSERT INTO `countries` (`id`, `name`) VALUES (186, 'Vatikanstaten');
INSERT INTO `countries` (`id`, `name`) VALUES (187, 'Venezuela');
INSERT INTO `countries` (`id`, `name`) VALUES (188, 'Vest-Samoa');
INSERT INTO `countries` (`id`, `name`) VALUES (189, 'Vestsahara');
INSERT INTO `countries` (`id`, `name`) VALUES (190, 'Vietnam');
INSERT INTO `countries` (`id`, `name`) VALUES (191, 'Yemen');
INSERT INTO `countries` (`id`, `name`) VALUES (192, 'Zambia');
INSERT INTO `countries` (`id`, `name`) VALUES (193, 'Zimbabwe');
INSERT INTO `countries` (`id`, `name`) VALUES (194, 'Ækvatorialguinea');
INSERT INTO `countries` (`id`, `name`) VALUES (195, 'Østrig');
INSERT INTO `countries` (`id`, `name`) VALUES (196, 'Østtimor');
-------------------------------------------------------

Skal vi splitte pointene?

for min skyld ingen alarm

Så gør vi det...