Mine

STEP 1)

CREATE TABLE IF NOT EXISTS `countries` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) character set latin1 collate latin1_general_ci default NULL,
  `flagpic` varchar(50) character set latin1 collate latin1_general_ci default NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `name` (`name`,`flagpic`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=244 ;


STEP 2)


INSERT INTO `countries` (`id`, `name`, `flagpic`) VALUES
(1, 'Afghanistan', 'Afghanistan.png'),
(2, 'Albania', 'Albania.png'),
(3, 'Alderney', 'Alderney.png'),
(4, 'Algeria', 'Algeria.png'),
(5, 'Andorra', 'Andorra.png'),
(6, 'Angola', 'Angola.png'),
(7, 'Antarctica', 'Antarctica.png'),
(8, 'Antigua and Barbuda', 'AntiguaandBarbuda.png'),
(9, 'Argentina', 'Argentina.png'),
(10, 'Armenia', 'Armenia.png'),
(11, 'Aruba', 'Aruba.png'),
(12, 'Australia', 'Australia.png'),
(13, 'Austria', 'Austria.png'),
(14, 'Azerbaijan', 'Azerbaijan.png'),
(15, 'Bahrain', 'Bahrain.png'),
(16, 'Bangladesh', 'Bangladesh.png'),
(17, 'Barbados', 'Barbados.png'),
(18, 'Belarus', 'Belarus.png'),
(19, 'Belgium', 'Belgium.png'),
(20, 'Belize', 'Belize.png'),
(21, 'Benin', 'Benin.png'),
(22, 'Bermuda', 'Bermuda.png'),
(23, 'Bhutan', 'Bhutan.png'),
(24, 'Bolivia', 'Bolivia.png'),
(25, 'Bosnia & Herzegovina', 'Bosnia&Herzegovina.png'),
(26, 'Botswana', 'Botswana.png'),
(27, 'Brazil', 'Brazil.png'),
(28, 'British Antarctic Territory', 'BritishAntarcticTerritory.png'),
(29, 'British Indian Ocean Territory', 'BritishIndianOceanTerritory.png'),
(30, 'British Virgin Islands', 'BritishVirginIslands.png'),
(31, 'Brunei', 'Brunei.png'),
(32, 'Bulgaria', 'Bulgaria.png'),
(33, 'Burkina Faso', 'BurkinaFaso.png'),
(34, 'Burundi', 'Burundi.png'),
(35, 'Cambodia', 'Cambodia.png'),
(36, 'Cameroon', 'Cameroon.png'),
(37, 'Canada', 'Canada.png'),
(38, 'Cape Verde', 'CapeVerde.png'),
(39, 'Cayman Islands', 'CaymanIslands.png'),
(40, 'Central African Republic', 'CentralAfricanRepublic.png'),
(41, 'Chad', 'Chad.png'),
(42, 'Chile', 'Chile.png'),
(43, 'China', 'China.png'),
(44, 'Colombia', 'Colombia.png'),
(45, 'Comoros', 'Comoros.png'),
(46, 'Congo-Brazzaville', 'Congo-Brazzaville.png'),
(47, 'Congo-Kinshasa', 'Congo-Kinshasa.png'),
(48, 'Cook Islands', 'CookIslands.png'),
(49, 'Costa Rica', 'CostaRica.png'),
(50, 'Cote d''Ivoire', 'CotedIvoire.png'),
(51, 'Croatia', 'Croatia.png'),
(52, 'Cuba', 'Cuba.png'),
(53, 'Cyprus', 'Cyprus.png'),
(54, 'Czech Republic', 'CzechRepublic.png'),
(55, 'Denmark', 'Denmark.png'),
(56, 'Djibouti', 'Djibouti.png'),
(57, 'Dominica', 'Dominica.png'),
(58, 'Dominican Republic', 'DominicanRepublic.png'),
(59, 'EU', 'EU.png'),
(60, 'Ecuador', 'Ecuador.png'),
(61, 'Egypt', 'Egypt.png'),
(62, 'El Salvador', 'ElSalvador.png'),
(63, 'Equatorial Guinea', 'EquatorialGuinea.png'),
(64, 'Eritrea', 'Eritrea.png'),
(65, 'Estonia', 'Estonia.png'),
(66, 'Ethiopia', 'Ethiopia.png'),
(67, 'Falkland Islands', 'FalklandIslands.png'),
(68, 'Fiji', 'Fiji.png'),
(69, 'Finland', 'Finland.png'),
(70, 'France', 'France.png'),
(71, 'French Guiana', 'FrenchGuiana.png'),
(72, 'French Polynesia', 'FrenchPolynesia.png'),
(73, 'French Southern & Antarctic Lands', 'FrenchSouthern&AntarcticLands.png'),
(74, 'Gabon', 'Gabon.png'),
(75, 'Gambia', 'Gambia.png'),
(76, 'Georgia', 'Georgia.png'),
(77, 'Germany', 'Germany.png'),
(78, 'Ghana', 'Ghana.png'),
(79, 'Gibraltar', 'Gibraltar.png'),
(80, 'Greece', 'Greece.png'),
(81, 'Greenland', 'Greenland.png'),
(82, 'Grenada', 'Grenada.png'),
(83, 'Guam', 'Guam.png'),
(84, 'Guatemala', 'Guatemala.png'),
(85, 'Guernsey', 'Guernsey.png'),
(86, 'Guinea-Bissau', 'Guinea-Bissau.png'),
(87, 'Guinea', 'Guinea.png'),
(88, 'Guyana', 'Guyana.png'),
(89, 'Haiti', 'Haiti.png'),
(90, 'Honduras', 'Honduras.png'),
(91, 'Hong Kong', 'HongKong.png'),
(92, 'Hungary', 'Hungary.png'),
(93, 'Iceland', 'Iceland.png'),
(94, 'India', 'India.png'),
(95, 'Indonesia', 'Indonesia.png'),
(96, 'Iran', 'Iran.png'),
(97, 'Iraq', 'Iraq.png'),
(98, 'Ireland', 'Ireland.png'),
(99, 'Isle of Man', 'IsleofMan.png'),
(100, 'Israel', 'Israel.png'),
(101, 'Italy', 'Italy.png'),
(102, 'Jamaica', 'Jamaica.png'),
(103, 'Japan', 'Japan.png'),
(104, 'Jersey', 'Jersey.png'),
(105, 'Jordan', 'Jordan.png'),
(106, 'Kazakhstan', 'Kazakhstan.png'),
(107, 'Kenya', 'Kenya.png'),
(108, 'Kiribati', 'Kiribati.png'),
(109, 'Kuwait', 'Kuwait.png'),
(110, 'Kyrgyzstan', 'Kyrgyzstan.png'),
(111, 'Laos', 'Laos.png'),
(112, 'Latvia', 'Latvia.png'),
(113, 'Lebanon', 'Lebanon.png'),
(114, 'Lesotho', 'Lesotho.png'),
(115, 'Liberia', 'Liberia.png'),
(116, 'Libya', 'Libya.png'),
(117, 'Liechtenstein', 'Liechtenstein.png'),
(118, 'Lithuania', 'Lithuania.png'),
(119, 'Luxembourg', 'Luxembourg.png'),
(120, 'Macao', 'Macao.png'),
(121, 'Macedonia', 'Macedonia.png'),
(122, 'Madagascar', 'Madagascar.png'),
(123, 'Malawi', 'Malawi.png'),
(124, 'Malaysia', 'Malaysia.png'),
(125, 'Maldives', 'Maldives.png'),
(126, 'Mali', 'Mali.png'),
(127, 'Malta', 'Malta.png'),
(128, 'Marshall Islands', 'MarshallIslands.png'),
(129, 'Martinique', 'Martinique.png'),
(130, 'Mauritania', 'Mauritania.png'),
(131, 'Mauritius', 'Mauritius.png'),
(132, 'Mayotte', 'Mayotte.png'),
(133, 'Mexico', 'Mexico.png'),
(134, 'Micronesia', 'Micronesia.png'),
(135, 'Midway Islands', 'MidwayIslands.png'),
(136, 'Moldova', 'Moldova.png'),
(137, 'Monaco', 'Monaco.png'),
(138, 'Mongolia', 'Mongolia.png'),
(139, 'Montserrat', 'Montserrat.png'),
(140, 'Morocco', 'Morocco.png'),
(141, 'Mozambique', 'Mozambique.png'),
(142, 'Myanmar', 'Myanmar.png'),
(143, 'Namibia', 'Namibia.png'),
(144, 'Nauru', 'Nauru.png'),
(145, 'Nepal', 'Nepal.png'),
(146, 'Netherlands Antilles', 'NetherlandsAntilles.png'),
(147, 'Netherlands', 'Netherlands.png'),
(148, 'New Caledonia', 'NewCaledonia.png'),
(149, 'New Zealand', 'NewZealand.png'),
(150, 'Nicaragua', 'Nicaragua.png'),
(151, 'Niger', 'Niger.png'),
(152, 'Nigeria', 'Nigeria.png'),
(153, 'Niue', 'Niue.png'),
(154, 'North Korea', 'NorthKorea.png'),
(155, 'Northern Cyprus', 'NorthernCyprus.png'),
(156, 'Northern Marianas', 'NorthernMarianas.png'),
(157, 'Norway', 'Norway.png'),
(158, 'Oman', 'Oman.png'),
(159, 'Pakistan', 'Pakistan.png'),
(160, 'Palau', 'Palau.png'),
(161, 'Palestine', 'Palestine.png'),
(162, 'Panama', 'Panama.png'),
(163, 'Papua New Guinea', 'PapuaNewGuinea.png'),
(164, 'Paraguay', 'Paraguay.png'),
(165, 'Peru', 'Peru.png'),
(166, 'Philippines', 'Philippines.png'),
(167, 'Pitcairn Islands', 'PitcairnIslands.png'),
(168, 'Poland', 'Poland.png'),
(169, 'Portugal', 'Portugal.png'),
(170, 'Puerto Rico', 'PuertoRico.png'),
(171, 'Qatar', 'Qatar.png'),
(172, 'Reunion', 'Reunion.png'),
(173, 'Romania', 'Romania.png'),
(174, 'Russian Fed', 'RussianFed.png'),
(175, 'Rwanda', 'Rwanda.png'),
(176, 'Saint Lucia', 'SaintLucia.png'),
(177, 'Samoa', 'Samoa.png'),
(178, 'San Marino', 'SanMarino.png'),
(179, 'Sao Tome & Principe', 'SaoTome&Principe.png'),
(180, 'Sark', 'Sark.png'),
(181, 'Saudi Arabia', 'SaudiArabia.png'),
(182, 'Seborga', 'Seborga.png'),
(183, 'Senegal', 'Senegal.png'),
(184, 'Serbia & Montenegro', 'Serbia&Montenegro.png'),
(185, 'Seychelles', 'Seychelles.png'),
(186, 'Sierra Leone', 'SierraLeone.png'),
(187, 'Singapore', 'Singapore.png'),
(188, 'Slovakia', 'Slovakia.png'),
(189, 'Slovenia', 'Slovenia.png'),
(190, 'Solomon Islands', 'SolomonIslands.png'),
(191, 'Somalia', 'Somalia.png'),
(192, 'Somaliland', 'Somaliland.png'),
(193, 'South Africa', 'SouthAfrica.png'),
(194, 'South Georgia & South Sandwich Islands', 'SouthGeorgia&SouthSandwichIslands.png'),
(195, 'South Korea', 'SouthKorea.png'),
(196, 'Spain', 'Spain.png'),
(197, 'Sri Lanka', 'SriLanka.png'),
(198, 'St Helena & Dependencies', 'StHelena&Dependencies.png'),
(199, 'St Kitts & Nevis', 'StKitts&Nevis.png'),
(200, 'St Pierre & Miquelon', 'StPierre&Miquelon.png'),
(201, 'St Vincent & the Grenadines', 'StVincent&theGrenadines.png'),
(202, 'Suriname', 'Suriname.png'),
(203, 'Swaziland', 'Swaziland.png'),
(204, 'Sweden', 'Sweden.png'),
(205, 'Switzerland', 'Switzerland.png'),
(206, 'Syria', 'Syria.png'),
(207, 'Taiwan', 'Taiwan.png'),
(208, 'Tajikistan', 'Tajikistan.png'),
(209, 'Tanzania', 'Tanzania.png'),
(210, 'Thailand', 'Thailand.png'),
(211, 'The Bahamas', 'TheBahamas.png'),
(212, 'The Faroes', 'TheFaroes.png'),
(213, 'The Sudan', 'TheSudan.png'),
(215, 'Tibet', 'Tibet.png'),
(216, 'Timor-Leste', 'Timor-Leste.png'),
(217, 'Togo', 'Togo.png'),
(218, 'Tonga', 'Tonga.png'),
(219, 'Trinidad & Tobago', 'Trinidad&Tobago.png'),
(220, 'Tristan da Cunha', 'TristandaCunha.png'),
(221, 'Tunisia', 'Tunisia.png'),
(222, 'Turkey', 'Turkey.png'),
(223, 'Turkmenistan', 'Turkmenistan.png'),
(224, 'Turks & Caicos Islands', 'Turks&CaicosIslands.png'),
(225, 'Tuvalu', 'Tuvalu.png'),
(226, 'UAE', 'UAE.png'),
(227, 'UK', 'UK.png'),
(228, 'United States', 'UnitedStates.png'),
(229, 'Uganda', 'Uganda.png'),
(230, 'Ukraine', 'Ukraine.png'),
(231, 'Uruguay', 'Uruguay.png'),
(232, 'Uzbekistan', 'Uzbekistan.png'),
(233, 'Vanuatu', 'Vanuatu.png'),
(234, 'Vatican City', 'VaticanCity.png'),
(235, 'Venezuela', 'Venezuela.png'),
(236, 'Vietnam', 'Vietnam.png'),
(237, 'Virgin Islands', 'VirginIslands.png'),
(238, 'Wake Island', 'WakeIsland.png'),
(239, 'Wallis & Futuna', 'Wallis&Futuna.png'),
(240, 'Western Sahara', 'WesternSahara.png'),
(241, 'Yemen', 'Yemen.png'),
(242, 'Zambia', 'Zambia.png'),
(243, 'Zimbabwe', 'Zimbabwe.png');