Posted By

sensimevanidus on 06/18/09

Tagged

mysql
list

Versions (?)

Last Edited at 06/18/09 04:42pm

Statistics

Viewed 1026 times

Favorited by 0 user(s)

Related snippets

MySQL Table - list of all country names (in Turkish)

/ Published in: MySQL

This will create and then populate a MySQL table with a list of the names for countries in existence. Country names are in Turkish language.

Highlighted TextExpand

-- phpMyAdmin SQL Dump
-- version 3.1.2deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 18, 2009 at 11:31 PM
-- Server version: 5.0.75
-- PHP Version: 5.2.6-3ubuntu4.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Table structure for table `countries_list`
--

CREATE TABLE IF NOT EXISTS `countries_list` (
  `country_id` tinyint(3) unsigned NOT NULL auto_increment,
  `country_name` varchar(30) collate utf8_turkish_ci NOT NULL,
  PRIMARY KEY  (`country_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=207 ;

--
-- Dumping data for table `countries_list`
--

INSERT INTO `countries_list` (`country_id`, `country_name`) VALUES
(1, 'Abhazya'),
(2, 'Afganistan'),
(3, 'Almanya'),
(4, 'Amerika BirleÅŸik Devletleri'),
(5, 'Andorra'),
(6, 'Angola'),
(7, 'Antigua ve Barbuda'),
(8, 'Arjantin'),
(9, 'Arnavutluk'),
(10, 'Avustralya'),
(11, 'Avusturya'),
(12, 'Azerbaycan'),
(13, 'Bahamalar'),
(14, 'Bahreyn'),
(15, 'BangladeÅŸ'),
(16, 'Barbados'),
(17, 'BatÄ± Sahra'),
(18, 'Belarus'),
(19, 'BelÃ§ika'),
(20, 'Belize'),
(21, 'Benin'),
(22, 'Bhutan'),
(23, 'BirleÅŸik Arap Emirlikleri'),
(24, 'Bolivya'),
(25, 'Bosna Hersek'),
(26, 'Botsvana'),
(27, 'Brezilya'),
(28, 'Brunei'),
(29, 'Bulgaristan'),
(30, 'Burkina Faso'),
(31, 'Burundi'),
(32, 'Cezayir'),
(33, 'Cibuti Cumhuriyeti'),
(34, 'Ã‡ad'),
(35, 'Ã‡ek Cumhuriyeti'),
(36, 'Ã‡in Halk Cumhuriyeti'),
(37, 'DaÄŸlÄ±k KarabaÄŸ Cumhuriyeti'),
(38, 'Danimarka'),
(39, 'DoÄŸu Timor'),
(40, 'Dominik Cumhuriyeti'),
(41, 'Dominika'),
(42, 'Ekvador'),
(43, 'Ekvator Ginesi'),
(44, 'El Salvador'),
(45, 'Endonezya'),
(46, 'Eritre'),
(47, 'Ermenistan'),
(48, 'Estonya'),
(49, 'Etiyopya'),
(50, 'Fas'),
(51, 'Fiji'),
(52, 'FildiÅŸi Sahilleri'),
(53, 'Filipinler'),
(54, 'Filistin'),
(55, 'Finlandiya'),
(56, 'Fransa'),
(57, 'Gabon'),
(58, 'Gambiya'),
(59, 'Gana'),
(60, 'Gine Bissau'),
(61, 'Gine'),
(62, 'Grenada'),
(63, 'Guyana'),
(64, 'Guatemala'),
(65, 'GÃ¼ney Afrika Cumhuriyeti'),
(66, 'GÃ¼ney Kore'),
(67, 'GÃ¼ney Osetya'),
(68, 'GÃ¼rcistan'),
(69, 'Haiti'),
(70, 'HÄ±rvatistan'),
(71, 'Hindistan'),
(72, 'Hollanda'),
(73, 'Honduras'),
(74, 'Irak'),
(75, 'Ä°ngiltere'),
(76, 'Ä°ran'),
(77, 'Ä°rlanda'),
(78, 'Ä°spanya'),
(79, 'Ä°srail'),
(80, 'Ä°sveÃ§'),
(81, 'Ä°sviÃ§re'),
(82, 'Ä°talya'),
(83, 'Ä°zlanda'),
(84, 'Jamaika'),
(85, 'Japonya'),
(86, 'KamboÃ§ya'),
(87, 'Kamerun'),
(88, 'Kanada'),
(89, 'KaradaÄŸ'),
(90, 'Katar'),
(91, 'Kazakistan'),
(92, 'Kenya'),
(93, 'KÄ±rgÄ±zistan'),
(94, 'KÄ±brÄ±s Cumhuriyeti'),
(95, 'Kiribati'),
(96, 'Kolombiya'),
(97, 'Komorlar'),
(98, 'Kongo'),
(99, 'Kongo Demokratik Cumhuriyeti'),
(100, 'Kosova'),
(101, 'Kosta Rika'),
(102, 'Kuveyt'),
(103, 'Kuzey KÄ±brÄ±s TÃ¼rk Cumhuriyeti'),
(104, 'Kuzey Kore'),
(105, 'KÃ¼ba'),
(106, 'Lakota Cumhuriyeti'),
(107, 'Laos'),
(108, 'Lesotho'),
(109, 'Letonya'),
(110, 'Liberya'),
(111, 'Libya'),
(112, 'Liechtenstein'),
(113, 'Litvanya'),
(114, 'LÃ¼bnan'),
(115, 'LÃ¼ksemburg'),
(116, 'Macaristan'),
(117, 'Madagaskar'),
(118, 'Makedonya Cumhuriyeti'),
(119, 'Malavi'),
(120, 'Maldivler'),
(121, 'Malezya'),
(122, 'Mali'),
(123, 'Malta'),
(124, 'Marshall AdalarÄ±'),
(125, 'Meksika'),
(126, 'MÄ±sÄ±r'),
(127, 'Mikronezya'),
(128, 'MoÄŸolistan'),
(129, 'Moldova'),
(130, 'Monako'),
(131, 'Moritanya'),
(132, 'Moritus'),
(133, 'Mozambik'),
(134, 'Myanmar'),
(135, 'Namibya'),
(136, 'Nauru'),
(137, 'Nepal'),
(138, 'Nikaragua'),
(139, 'Nijer'),
(140, 'Nijerya'),
(141, 'NorveÃ§'),
(142, 'Orta Afrika Cumhuriyeti'),
(143, 'Ã–zbekistan'),
(144, 'Pakistan'),
(145, 'Palau'),
(146, 'Panama'),
(147, 'Papua Yeni Gine'),
(148, 'Paraguay'),
(149, 'Peru'),
(150, 'Polonya'),
(151, 'Portekiz'),
(152, 'Romanya'),
(153, 'Ruanda'),
(154, 'Rusya Federasyonu'),
(155, 'Saint Kitts ve Nevis'),
(156, 'Saint Lucia'),
(157, 'Saint Vincent ve Grenadinler'),
(158, 'Samoa'),
(159, 'San Marino'),
(160, 'Sao Tome ve Principe'),
(161, 'Sealand'),
(162, 'Senegal'),
(163, 'SeyÅŸeller'),
(164, 'SÄ±rbistan'),
(165, 'Sierra Leone'),
(166, 'Singapur'),
(167, 'Slovakya'),
(168, 'Slovenya'),
(169, 'Solomon AdalarÄ±'),
(170, 'Somali'),
(171, 'Somaliland'),
(172, 'Sri Lanka'),
(173, 'Sudan'),
(174, 'Surinam'),
(175, 'Suudi Arabistan'),
(176, 'Suriye'),
(177, 'Svaziland'),
(178, 'Åžili'),
(179, 'Tacikistan'),
(180, 'Tamil Eelam'),
(181, 'Tanzanya'),
(182, 'Tayland'),
(183, 'Tayvan'),
(184, 'Togo'),
(185, 'Tonga'),
(186, 'Transdinyester'),
(187, 'Trinidad ve Tobago'),
(188, 'Tunus'),
(189, 'Tuvalu'),
(190, 'TÃ¼rkiye'),
(191, 'TÃ¼rkmenistan'),
(192, 'Uganda'),
(193, 'Ukrayna'),
(194, 'Umman'),
(195, 'Uruguay'),
(196, 'ÃœrdÃ¼n'),
(197, 'Vanuatu'),
(198, 'Vatikan'),
(199, 'Venezuela'),
(200, 'Vietnam'),
(201, 'Yemen'),
(202, 'Yeni Zelanda'),
(203, 'YeÅŸil Burun'),
(204, 'Yunanistan'),
(205, 'Zambiya'),
(206, 'Zimbabve');

Report this snippet Tweet