İl ve İlçe Sql Script

Şehir ve İlçelerimizin Sql Scripti.

İlk Kısım İl Tablosu ve Verileri

--
-- Tablo için tablo yapısı: `il`
--

CREATE TABLE IF NOT EXISTS `il` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ADI` varchar(20) COLLATE utf8_turkish_ci NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=82 ;

--
-- Tablo döküm verisi `il`
--

INSERT INTO `il` (`ID`, `ADI`) VALUES
(1, 'Adana'),
(2, 'Adiyaman'),
(3, 'Afyon'),
(4, 'Ağri'),
(5, 'Amasya'),
(6, 'Ankara'),
(7, 'Antalya'),
(8, 'Artvin'),
(9, 'Aydin'),
(10, 'Balikesir'),
(11, 'Bilecik'),
(12, 'Bingöl'),
(13, 'Bitlis'),
(14, 'Bolu'),
(15, 'Burdur'),
(16, 'Bursa'),
(17, 'Çanakkale'),
(18, 'Çankiri'),
(19, 'Çorum'),
(20, 'Denizlİ'),
(21, 'Diyarbakir'),
(22, 'Edirne'),
(23, 'Elaziğ'),
(24, 'Erzincan'),
(25, 'Erzurum'),
(26, 'Eskişehir'),
(27, 'Gaziantep'),
(28, 'Giresun'),
(29, 'Gümüşhane'),
(30, 'Hakkari'),
(31, 'Hatay'),
(32, 'Isparta'),
(33, 'İçel'),
(34, 'İstanbul'),
(35, 'İzmir'),
(36, 'Kars'),
(37, 'Kastamonu'),
(38, 'Kayserİ'),
(39, 'Kirklareli'),
(40, 'Kirşehir'),
(41, 'Kocaeli'),
(42, 'Konya'),
(43, 'Kütahya'),
(44, 'Malatya'),
(45, 'Manisa'),
(46, 'Kahramanmaraş'),
(47, 'Mardin'),
(48, 'Muğla'),
(49, 'Muş'),
(50, 'Nevşehir'),
(51, 'Niğde'),
(52, 'Ordu'),
(53, 'Rize'),
(54, 'Sakarya'),
(55, 'Samsun'),
(56, 'Siirt'),
(57, 'Sinop'),
(58, 'Sivas'),
(59, 'Tekirdağ'),
(60, 'Tokat'),
(61, 'Trabzon'),
(62, 'Tuncelİ'),
(63, 'Şanliurfa'),
(64, 'Uşak'),
(65, 'Van'),
(66, 'Yozgat'),
(67, 'Zonguldak'),
(68, 'Aksaray'),
(69, 'Bayburt'),
(70, 'Karaman'),
(71, 'Kirikkale'),
(72, 'Batman'),
(73, 'Şirnak'),
(74, 'Bartin'),
(75, 'Ardahan'),
(76, 'Iğdir'),
(77, 'Yalova'),
(78, 'Karabük'),
(79, 'Kilis'),
(80, 'Osmaniye'),
(81, 'Düzce');

{reklam}

İkinci kısım ilçe tablosu ve verileri

--
-- Tablo için tablo yapısı: `ilce`
--

CREATE TABLE IF NOT EXISTS `ilce` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `IL_ID` int(11) NOT NULL,
  `ADI` varchar(25) COLLATE utf8_turkish_ci NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=940 ;

--
-- Tablo döküm verisi `ilce`
--

INSERT INTO `ilce` (`ID`, `IL_ID`, `ADI`) VALUES
(1, 1, 'Merkez'),
(2, 1, 'Aladag'),
(3, 1, 'Ceyhan'),
(4, 1, 'Feke'),
(5, 1, 'Imamoglu'),
(6, 1, 'Karaisali'),
(7, 1, 'Karatas'),
(8, 1, 'Kozan'),
(9, 1, 'Pozanti'),
(10, 1, 'Saimbeyli'),
(11, 1, 'Seyhan'),
(12, 1, 'Tufanbeyli'),
(13, 1, 'Yumurtalik'),
(14, 1, 'Yüregir'),
(15, 2, 'Merkez'),
(16, 2, 'Besni'),
(17, 2, 'Çelikhan'),
(18, 2, 'Gerger'),
(19, 2, 'Gölbasi'),
(20, 2, 'Kahta'),
(21, 2, 'Samsat'),
(22, 2, 'Sincik'),
(23, 2, 'Tut'),
(24, 3, 'Merkez'),
(25, 3, 'Basmakçi'),
(26, 3, 'Bayat'),
(27, 3, 'Bolvadin'),
(28, 3, 'Çobanlar'),
(29, 3, 'Çay'),
(30, 3, 'Dazkiri'),
(31, 3, 'Dinar'),
(32, 3, 'Emirdag'),
(33, 3, 'Evciler'),
(34, 3, 'Hocalar'),
(35, 3, 'Ihsaniye'),
(36, 3, 'Iscehisar'),
(37, 3, 'Kizilören'),
(38, 3, 'Sandikli'),
(39, 3, 'Sincanli'),
(40, 3, 'Sultandagi'),
(41, 3, 'Suhut'),
(42, 4, 'Merkez'),
(43, 4, 'Diyadin'),
(44, 4, 'Dogubeyazit'),
(45, 4, 'Eleskirt'),
(46, 4, 'Hamur'),
(47, 4, 'Patnos'),
(48, 4, 'Tasliçay'),
(49, 4, 'Tutak'),
(50, 5, 'Merkez'),
(51, 5, 'Göynücek'),
(52, 5, 'Gümüshacikö'),
(53, 5, 'Hamamözü'),
(54, 5, 'Merzifon'),
(55, 5, 'Suluova'),
(56, 5, 'Tasova'),
(57, 6, 'Merkez'),
(58, 6, 'Akyurt'),
(59, 6, 'Altindag'),
(60, 6, 'Ayas'),
(61, 6, 'Bala'),
(62, 6, 'Beypazari'),
(63, 6, 'Çamlidere'),
(64, 6, 'Çankaya'),
(65, 6, 'Çubuk'),
(66, 6, 'Elmadag'),
(67, 6, 'Etimesgut'),
(68, 6, 'Evren'),
(69, 6, 'Gölbasi'),
(70, 6, 'Güdül'),
(71, 6, 'Haymana'),
(72, 6, 'Kalecik'),
(73, 6, 'Kazan'),
(74, 6, 'Keçiören'),
(75, 6, 'Kizilcahama'),
(76, 6, 'Mamak'),
(77, 6, 'Nallihan'),
(78, 6, 'Polatli'),
(79, 6, 'Sincan'),
(80, 6, 'Sereflikoçh'),
(81, 6, 'Yenimahalle'),
(82, 7, 'Merkez'),
(83, 7, 'Akseki'),
(84, 7, 'Alanya'),
(85, 7, 'Demre'),
(86, 7, 'Elmali'),
(87, 7, 'Finike'),
(88, 7, 'Gazipasa'),
(89, 7, 'Gündogmus'),
(90, 7, 'Ibradi'),
(91, 7, 'Kale'),
(92, 7, 'Kas'),
(93, 7, 'Kemer'),
(94, 7, 'Korkuteli'),
(95, 7, 'Kumluca'),
(96, 7, 'Manavgat'),
(97, 7, 'Serik'),
(98, 8, 'Merkez'),
(99, 8, 'Ardanuç'),
(100, 8, 'Arhavi'),
(101, 8, 'Borçka'),
(102, 8, 'Hopa'),
(103, 8, 'Murgul'),
(104, 8, 'Savsat'),
(105, 8, 'Yusufeli'),
(106, 9, 'Merkez'),
(107, 9, 'Bozdogan'),
(108, 9, 'Buharkent'),
(109, 9, 'Çine'),
(110, 9, 'Germencik'),
(111, 9, 'Incirliova'),
(112, 9, 'Karacasu'),
(113, 9, 'Karpuzlu'),
(114, 9, 'Koçarli'),
(115, 9, 'Kösk'),
(116, 9, 'Kusadasi'),
(117, 9, 'Kuyucak'),
(118, 9, 'Nazilli'),
(119, 9, 'Söke'),
(120, 9, 'Sultanhisar'),
(121, 9, 'Yenihisar'),
(122, 9, 'Yenipazar'),
(123, 10, 'Merkez'),
(124, 10, 'Ayvalik'),
(125, 10, 'Akçay'),
(126, 10, 'Balya'),
(127, 10, 'Bandirma'),
(128, 10, 'Bigadiç'),
(129, 10, 'Burhaniye'),
(130, 10, 'Dursunbey'),
(131, 10, 'Edremit'),
(132, 10, 'Erdek'),
(133, 10, 'Gönen'),
(134, 10, 'Gömeç'),
(135, 10, 'Havran'),
(136, 10, 'Ivrindi'),
(137, 10, 'Kepsut'),
(138, 10, 'Manyas'),
(139, 10, 'Marmara'),
(140, 10, 'Savastepe'),
(141, 10, 'Sindirgi'),
(142, 10, 'Susurluk'),
(143, 11, 'Merkez'),
(144, 11, 'Bozöyük'),
(145, 11, 'Gölpazari'),
(146, 11, 'Inhisar'),
(147, 11, 'Osmaneli'),
(148, 11, 'Pazaryeri'),
(149, 11, 'Sögüt'),
(150, 11, 'Yenipazar'),
(151, 12, 'Merkez'),
(152, 12, 'Adakli'),
(153, 12, 'Genç'),
(154, 12, 'Karliova'),
(155, 12, 'Kigi'),
(156, 12, 'Solhan'),
(157, 12, 'Yayladere'),
(158, 12, 'Yedisu'),
(159, 13, 'Merkez'),
(160, 13, 'Adilcevaz'),
(161, 13, 'Ahlat'),
(162, 13, 'Güroymak'),
(163, 13, 'Hizan'),
(164, 13, 'Mutki'),
(165, 13, 'Tatvan'),
(166, 14, 'Merkez'),
(167, 14, 'Dörtdivan'),
(168, 14, 'Gerede'),
(169, 14, 'Göynük'),
(170, 14, 'Kibriscik'),
(171, 14, 'Mengen'),
(172, 14, 'Mudurnu'),
(173, 14, 'Seben'),
(174, 14, 'Yeniçaga'),
(175, 15, 'Merkez'),
(176, 15, 'Altinyayla'),
(177, 15, 'Aglasun'),
(178, 15, 'Bucak'),
(179, 15, 'Çavdir'),
(180, 15, 'Çeltikçi'),
(181, 15, 'Gölhisar'),
(182, 15, 'Karamanli'),
(183, 15, 'Kemer'),
(184, 15, 'Tefenni'),
(185, 15, 'Yesilova'),
(186, 16, 'Merkez'),
(187, 16, 'Büyükorhan'),
(188, 16, 'Gemlik'),
(189, 16, 'Gürsu'),
(190, 16, 'Harmancik'),
(191, 16, 'Inegöl'),
(192, 16, 'Iznik'),
(193, 16, 'Karacabey'),
(194, 16, 'Keles'),
(195, 16, 'Kestel'),
(196, 16, 'Mudanya'),
(197, 16, 'Mustafakema'),
(198, 16, 'Nilüfer'),
(199, 16, 'Orhaneli'),
(200, 16, 'Orhangazi'),
(201, 16, 'Osmangazi'),
(202, 16, 'Yenisehir'),
(203, 16, 'Yildirim'),
(204, 17, 'Merkez'),
(205, 17, 'Ayvacik'),
(206, 17, 'Bayramiç'),
(207, 17, 'Bozcaada'),
(208, 17, 'Biga'),
(209, 17, 'Çan'),
(210, 17, 'Eceabat'),
(211, 17, 'Ezine'),
(212, 17, 'Gelibolu'),
(213, 17, 'Gökçeada'),
(214, 17, 'Lapseki'),
(215, 17, 'Yenice'),
(216, 18, 'Merkez'),
(217, 18, 'Atkaracalar'),
(218, 18, 'Bayramören'),
(219, 18, 'Çerkes'),
(220, 18, 'Eldivan'),
(221, 18, 'Ilgaz'),
(222, 18, 'Kizilirmak'),
(223, 18, 'Korgun'),
(224, 18, 'Kursunlu'),
(225, 18, 'Orta'),
(226, 18, 'Ovacik'),
(227, 18, 'Sabanözü'),
(228, 18, 'Yaprakli'),
(229, 19, 'Merkez'),
(230, 19, 'Alaca'),
(231, 19, 'Bayat'),
(232, 19, 'Bogazkale'),
(233, 19, 'Dodurga'),
(234, 19, 'Iskilip'),
(235, 19, 'Kargi'),
(236, 19, 'Laçin'),
(237, 19, 'Mecitözü'),
(238, 19, 'Oguzlar'),
(239, 19, 'Ortaköy'),
(240, 19, 'Osmancik'),
(241, 19, 'Sungurlu'),
(242, 19, 'Ugurludag'),
(243, 20, 'Merkez'),
(244, 20, 'Acipayam'),
(245, 20, 'Akköy'),
(246, 20, 'Babadag'),
(247, 20, 'Baklan'),
(248, 20, 'Bekilli'),
(249, 20, 'Beyagaç'),
(250, 20, 'Buldan'),
(251, 20, 'Bozkurt'),
(252, 20, 'Çal'),
(253, 20, 'Çameli'),
(254, 20, 'Çardak'),
(255, 20, 'Çivril'),
(256, 20, 'Güney'),
(257, 20, 'Honaz'),
(258, 20, 'Kale'),
(259, 20, 'Sarayköy'),
(260, 20, 'Serinhisar'),
(261, 20, 'Tavas'),
(262, 21, 'Merkez'),
(263, 21, 'Bismil'),
(264, 21, 'Çermik'),
(265, 21, 'Çinar'),
(266, 21, 'Çüngüs'),
(267, 21, 'Dicle'),
(268, 21, 'Egil'),
(269, 21, 'Ergani'),
(270, 21, 'Hani'),
(271, 21, 'Hazro'),
(272, 21, 'Kocaköy'),
(273, 21, 'Kulp'),
(274, 21, 'Lice'),
(275, 21, 'Silvan'),
(276, 22, 'Merkez'),
(277, 22, 'Enez'),
(278, 22, 'Havsa'),
(279, 22, 'Ipsala'),
(280, 22, 'Kesan'),
(281, 22, 'Lalapasa'),
(282, 22, 'Meriç'),
(283, 22, 'Süloglu'),
(284, 22, 'Uzunköprü'),
(285, 23, 'Merkez'),
(286, 23, 'Agin'),
(287, 23, 'Alacakaya'),
(288, 23, 'Aricak'),
(289, 23, 'Baskil'),
(290, 23, 'Karakoçan'),
(291, 23, 'Keban'),
(292, 23, 'Kovancilar'),
(293, 23, 'Maden'),
(294, 23, 'Palu'),
(295, 23, 'Sivrice'),
(296, 24, 'Merkez'),
(297, 24, 'Çayirli'),
(298, 24, 'Iliç'),
(299, 24, 'Kemah'),
(300, 24, 'Kemaliye'),
(301, 24, 'Otlukbeli'),
(302, 24, 'Refahiye'),
(303, 24, 'Tercan'),
(304, 24, 'Üzümlü'),
(305, 25, 'Merkez'),
(306, 25, 'Askale'),
(307, 25, 'Çat'),
(308, 25, 'Hinis'),
(309, 25, 'Horasan'),
(310, 25, 'Ilica'),
(311, 25, 'Ispir'),
(312, 25, 'Karaçoban'),
(313, 25, 'Karayazi'),
(314, 25, 'Köprüköy'),
(315, 25, 'Narman'),
(316, 25, 'Oltu'),
(317, 25, 'Olur'),
(318, 25, 'Pasinler'),
(319, 25, 'Pazaryolu'),
(320, 25, 'Senkaya'),
(321, 25, 'Tekman'),
(322, 25, 'Tortum'),
(323, 25, 'Uzundere'),
(324, 26, 'Merkez'),
(325, 26, 'Alpu'),
(326, 26, 'Beylikova'),
(327, 26, 'Çifteler'),
(328, 26, 'Günyüzü'),
(329, 26, 'Han'),
(330, 26, 'Inönü'),
(331, 26, 'Mahmudiye'),
(332, 26, 'Mihalgazi'),
(333, 26, 'Mihaliççik'),
(334, 26, 'Saricakaya'),
(335, 26, 'Seyitgazi'),
(336, 26, 'Sivrihisar'),
(337, 27, 'Merkez'),
(338, 27, 'Araban'),
(339, 27, 'Islahiye'),
(340, 27, 'Kilis'),
(341, 27, 'Kargamis'),
(342, 27, 'Nizip'),
(343, 27, 'Nurdagi'),
(344, 27, 'Oguzeli'),
(345, 27, 'Sahinbey'),
(346, 27, 'Sehitkamil'),
(347, 27, 'Yavuzeli'),
(348, 28, 'Merkez'),
(349, 28, 'Alucra'),
(350, 28, 'Bulancak'),
(351, 28, 'Çamoluk'),
(352, 28, 'Çanakçi'),
(353, 28, 'Dereli'),
(354, 28, 'Dogankent'),
(355, 28, 'Espiye'),
(356, 28, 'Eynesil'),
(357, 28, 'Görele'),
(358, 28, 'Güce'),
(359, 28, 'Kesap'),
(360, 28, 'Piraziz'),
(361, 28, 'Sebinkarahisar'),
(362, 28, 'Tirebolu'),
(363, 28, 'Yaglidere'),
(364, 29, 'Merkez'),
(365, 29, 'Kelkit'),
(366, 29, 'Köse'),
(367, 29, 'Kürtün'),
(368, 29, 'Siran'),
(369, 29, 'Torul'),
(370, 30, 'Merkez'),
(371, 30, 'Çukurca'),
(372, 30, 'Semdinli'),
(373, 30, 'Yüksekova'),
(374, 31, 'Merkez'),
(375, 31, 'Altinözü'),
(376, 31, 'Belen'),
(377, 31, 'Dörtyol'),
(378, 31, 'Erzin'),
(379, 31, 'Hassa'),
(380, 31, 'Iskenderun'),
(381, 31, 'Kirikhan'),
(382, 31, 'Kumlu'),
(383, 31, 'Reyhanli'),
(384, 31, 'Samandagi'),
(385, 31, 'Yayladagi'),
(386, 32, 'Merkez'),
(387, 32, 'Aksu'),
(388, 32, 'Atabey'),
(389, 32, 'Egirdir'),
(390, 32, 'Gelendost'),
(391, 32, 'Gönen'),
(392, 32, 'Keçiborlu'),
(393, 32, 'Senirkent'),
(394, 32, 'Sütçüler'),
(395, 32, 'Sarkikaraag'),
(396, 32, 'Uluborlu'),
(397, 32, 'Yenisarbade'),
(398, 32, 'Yalvaç'),
(399, 33, 'Merkez'),
(400, 33, 'Anamur'),
(401, 33, 'Aydincik'),
(402, 33, 'Bozyazi'),
(403, 33, 'Çamliyayla'),
(404, 33, 'Erdemli'),
(405, 33, 'Gülnar'),
(406, 33, 'Mut'),
(407, 33, 'Silifke'),
(408, 33, 'Tarsus'),
(409, 34, 'Merkez'),
(410, 34, 'Adalar'),
(411, 34, 'Avcilar'),
(412, 34, 'Bagcilar'),
(413, 34, 'Bakirköy'),
(414, 34, 'Bahçelievle'),
(415, 34, 'Bayrampasa'),
(416, 34, 'Besiktas'),
(417, 34, 'Beykoz'),
(418, 34, 'Beyoglu'),
(419, 34, 'Büyükçekmece'),
(420, 34, 'Çatalca'),
(421, 34, 'Eminönü'),
(422, 34, 'Eyüp'),
(423, 34, 'Esenler'),
(424, 34, 'Fatih'),
(425, 34, 'Gaziosmanpasa'),
(426, 34, 'Güngören'),
(427, 34, 'Kadiköy'),
(428, 34, 'Kagithane'),
(429, 34, 'Kartal'),
(430, 34, 'Küçükçekmece'),
(431, 34, 'Maltepe'),
(432, 34, 'Pendik'),
(433, 34, 'Sariyer'),
(434, 34, 'Silivri'),
(435, 34, 'Sultanbeyli'),
(436, 34, 'Sile'),
(437, 34, 'Sisli'),
(438, 34, 'Tuzla'),
(439, 34, 'Ümraniye'),
(440, 34, 'Üsküdar'),
(441, 34, 'Yalova'),
(442, 34, 'Zeytinburnu'),
(443, 35, 'Merkez'),
(444, 35, 'Aliaga'),
(445, 35, 'Bayindir'),
(446, 35, 'Balçova'),
(447, 35, 'Bergama'),
(448, 35, 'Beydag'),
(449, 35, 'Bornova'),
(450, 35, 'Buca'),
(451, 35, 'Çesme'),
(452, 35, 'Çigli'),
(453, 35, 'Dikili'),
(454, 35, 'Foça'),
(455, 35, 'Gaziemir'),
(456, 35, 'Güzelbahçe'),
(457, 35, 'Karaburun'),
(458, 35, 'Karsiyaka'),
(459, 35, 'Kemalpasa'),
(460, 35, 'Kinik'),
(461, 35, 'Kiraz'),
(462, 35, 'Konak'),
(463, 35, 'Menderes'),
(464, 35, 'Menemen'),
(465, 35, 'Narlidere'),
(466, 35, 'Ödemis'),
(467, 35, 'Seferihisar'),
(468, 35, 'Selçuk'),
(469, 35, 'Tire'),
(470, 35, 'Torbali'),
(471, 35, 'Urla'),
(472, 36, 'Merkez'),
(473, 36, 'Akyaka'),
(474, 36, 'Arpaçay'),
(475, 36, 'Digor'),
(476, 36, 'Kagizman'),
(477, 36, 'Sarikamis'),
(478, 36, 'Selim'),
(479, 36, 'Susuz'),
(480, 37, 'Merkez'),
(481, 37, 'Abana'),
(482, 37, 'Agli'),
(483, 37, 'Araç'),
(484, 37, 'Azdavay'),
(485, 37, 'Bozkurt'),
(486, 37, 'Cide'),
(487, 37, 'Çatalzeytin'),
(488, 37, 'Daday'),
(489, 37, 'Devrekani'),
(490, 37, 'Doganyurt'),
(491, 37, 'Hanönü'),
(492, 37, 'Ihsangazi'),
(493, 37, 'Inebolu'),
(494, 37, 'Küre'),
(495, 37, 'Pinarbasi'),
(496, 37, 'Seydiler'),
(497, 37, 'Senpazar'),
(498, 37, 'Tasköprü'),
(499, 37, 'Tosya'),
(500, 38, 'Merkez'),
(501, 38, 'Akkisla'),
(502, 38, 'Bünyan'),
(503, 38, 'Develi'),
(504, 38, 'Felahiye'),
(505, 38, 'Hacilar'),
(506, 38, 'Incesu'),
(507, 38, 'Kocasinan'),
(508, 38, 'Melikgazi'),
(509, 38, 'Özvatan'),
(510, 38, 'Pinarbasi'),
(511, 38, 'Sarioglan'),
(512, 38, 'Sariz'),
(513, 38, 'Talas'),
(514, 38, 'Tomarza'),
(515, 38, 'Yahyali'),
(516, 38, 'Yesilhisar'),
(517, 39, 'Merkez'),
(518, 39, 'Babaeski'),
(519, 39, 'Demirköy'),
(520, 39, 'Kofçaz'),
(521, 39, 'Lüleburgaz'),
(522, 39, 'Pehlivanköy'),
(523, 39, 'Pinarhisar'),
(524, 39, 'Vize'),
(525, 40, 'Merkez'),
(526, 40, 'Akçakent'),
(527, 40, 'Akpinar'),
(528, 40, 'Boztepe'),
(529, 40, 'Çiçekdagi'),
(530, 40, 'Kaman'),
(531, 40, 'Mucur'),
(532, 41, 'Merkez'),
(533, 41, 'Darica'),
(534, 41, 'Gebze'),
(535, 41, 'Gölcük'),
(536, 41, 'Kandira'),
(537, 41, 'Karamürsel'),
(538, 41, 'Körfez'),
(539, 42, 'Merkez'),
(540, 42, 'Ahirli'),
(541, 42, 'Akören'),
(542, 42, 'Aksehir'),
(543, 42, 'Altinekin'),
(544, 42, 'Beysehir'),
(545, 42, 'Bozkir'),
(546, 42, 'Derebucak'),
(547, 42, 'Cihanbeyli'),
(548, 42, 'Çumra'),
(549, 42, 'Çeltik'),
(550, 42, 'Derbent'),
(551, 42, 'Doganhisar'),
(552, 42, 'Emirgazi'),
(553, 42, 'Eregli'),
(554, 42, 'Güneysinir'),
(555, 42, 'Halkapinar'),
(556, 42, 'Hadim'),
(557, 42, 'Hüyük'),
(558, 42, 'Ilgin'),
(559, 42, 'Kadinhani'),
(560, 42, 'Karapinar'),
(561, 42, 'Karatay'),
(562, 42, 'Kulu'),
(563, 42, 'Meram'),
(564, 42, 'Sarayönü'),
(565, 42, 'Selçuklu'),
(566, 42, 'Seydisehir'),
(567, 42, 'Taskent'),
(568, 42, 'Tuzlukçu'),
(569, 42, 'Yalihöyük'),
(570, 42, 'Yunak'),
(571, 43, 'Merkez'),
(572, 43, 'Altintas'),
(573, 43, 'Aslanapa'),
(574, 43, 'Cavdarhisar'),
(575, 43, 'Domaniç'),
(576, 43, 'Dumlupinar'),
(577, 43, 'Emet'),
(578, 43, 'Gediz'),
(579, 43, 'Hisarcik'),
(580, 43, 'Pazarlar'),
(581, 43, 'Simav'),
(582, 43, 'Saphane'),
(583, 43, 'Tavsanli'),
(584, 44, 'Merkez'),
(585, 44, 'Akçadag'),
(586, 44, 'Arapgir'),
(587, 44, 'Arguvan'),
(588, 44, 'Battalgazi'),
(589, 44, 'Darende'),
(590, 44, 'Dogansehir'),
(591, 44, 'Doganyol'),
(592, 44, 'Hekimhan'),
(593, 44, 'Kale'),
(594, 44, 'Kuluncak'),
(595, 44, 'Pötürge'),
(596, 44, 'Yazihan'),
(597, 44, 'Yesilyurt'),
(598, 45, 'Merkez'),
(599, 45, 'Ahmetli'),
(600, 45, 'Akhisar'),
(601, 45, 'Alasehir'),
(602, 45, 'Demirci'),
(603, 45, 'Gölmarmara'),
(604, 45, 'Gördes'),
(605, 45, 'Kirkagaç'),
(606, 45, 'Köprübasi'),
(607, 45, 'Kula'),
(608, 45, 'Salihli'),
(609, 45, 'Sarigöl'),
(610, 45, 'Saruhanli'),
(611, 45, 'Selendi'),
(612, 45, 'Soma'),
(613, 45, 'Turgutlu'),
(614, 46, 'Merkez'),
(615, 46, 'Afsin'),
(616, 46, 'Andirin'),
(617, 46, 'Çaglayancer'),
(618, 46, 'Ekinözü'),
(619, 46, 'Elbistan'),
(620, 46, 'Göksun'),
(621, 46, 'Nurhak'),
(622, 46, 'Pazarcik'),
(623, 46, 'Türkoglu'),
(624, 47, 'Merkez'),
(625, 47, 'Dargeçit'),
(626, 47, 'Derik'),
(627, 47, 'Kiziltepe'),
(628, 47, 'Mazidagi'),
(629, 47, 'Midyat'),
(630, 47, 'Nusaybin'),
(631, 47, 'Ömerli'),
(632, 47, 'Savur'),
(633, 47, 'Yesilli'),
(634, 48, 'Merkez'),
(635, 48, 'Bodrum'),
(636, 48, 'Dalaman'),
(637, 48, 'Datça'),
(638, 48, 'Fethiye'),
(639, 48, 'Kavaklidere'),
(640, 48, 'Köycegiz'),
(641, 48, 'Marmaris'),
(642, 48, 'Milas'),
(643, 48, 'Ortaca'),
(644, 48, 'Ula'),
(645, 48, 'Yatagan'),
(646, 49, 'Merkez'),
(647, 49, 'Bulanik'),
(648, 49, 'Hasköy'),
(649, 49, 'Korkut'),
(650, 49, 'Malazgirt'),
(651, 49, 'Varto'),
(652, 50, 'Merkez'),
(653, 50, 'Acigöl'),
(654, 50, 'Avanos'),
(655, 50, 'Derinkuyu'),
(656, 50, 'Gülsehir'),
(657, 50, 'Hacibektas'),
(658, 50, 'Kozakli'),
(659, 50, 'Ürgüp'),
(660, 51, 'Merkez'),
(661, 51, 'Altunhisar'),
(662, 51, 'Bor'),
(663, 51, 'Çamardi'),
(664, 51, 'Çiftlik'),
(665, 51, 'Ulukisla'),
(666, 52, 'Merkez'),
(667, 52, 'Akkus'),
(668, 52, 'Aybasti'),
(669, 52, 'Çamas'),
(670, 52, 'Çatalpinar'),
(671, 52, 'Çaybasi'),
(672, 52, 'Fatsa'),
(673, 52, 'Gölköy'),
(674, 52, 'Gölyali'),
(675, 52, 'Gürgentepe'),
(676, 52, 'Ikizce'),
(677, 52, 'Korgan'),
(678, 52, 'Kabadüz'),
(679, 52, 'Kabatas'),
(680, 52, 'Kumru'),
(681, 52, 'Mesudiye'),
(682, 52, 'Persembe'),
(683, 52, 'Ulubey'),
(684, 52, 'Ünye'),
(685, 53, 'Merkez'),
(686, 53, 'Ardesen'),
(687, 53, 'Çamlihemsin'),
(688, 53, 'Çayeli'),
(689, 53, 'Derepazari'),
(690, 53, 'Findikli'),
(691, 53, 'Güneysu'),
(692, 53, 'Hemsin'),
(693, 53, 'Ikizdere'),
(694, 53, 'Iyidere'),
(695, 53, 'Kalkandere'),
(696, 53, 'Pazar'),
(697, 54, 'Merkez'),
(698, 54, 'Akyazi'),
(699, 54, 'Ferizli'),
(700, 54, 'Geyve'),
(701, 54, 'Hendek'),
(702, 54, 'Karapürçek'),
(703, 54, 'Karasu'),
(704, 54, 'Kaynarca'),
(705, 54, 'Kocaali'),
(706, 54, 'Pamukova'),
(707, 54, 'Sapanca'),
(708, 54, 'Sögütlü'),
(709, 54, 'Tarakli'),
(710, 55, 'Merkez'),
(711, 55, 'Alaçam'),
(712, 55, 'Asarcik'),
(713, 55, 'Ayvacik'),
(714, 55, 'Bafra'),
(715, 55, 'Çarsamba'),
(716, 55, 'Havza'),
(717, 55, 'Kavak'),
(718, 55, 'Ladik'),
(719, 55, '19mayis'),
(720, 55, 'Salipazari'),
(721, 55, 'Tekkeköy'),
(722, 55, 'Terme'),
(723, 55, 'Vezirköprü'),
(724, 55, 'Yakakent'),
(725, 56, 'Merkez'),
(726, 56, 'Aydinlar'),
(727, 56, 'Baykan'),
(728, 56, 'Eruh'),
(729, 56, 'Kozluk'),
(730, 56, 'Kurtalan'),
(731, 56, 'Pervari'),
(732, 56, 'Sirvan'),
(733, 57, 'Merkez'),
(734, 57, 'Ayancik'),
(735, 57, 'Boyabat'),
(736, 57, 'Dikmen'),
(737, 57, 'Duragan'),
(738, 57, 'Erfelek'),
(739, 57, 'Gerze'),
(740, 57, 'Saraydüzü'),
(741, 57, 'Türkeli'),
(742, 58, 'Merkez'),
(743, 58, 'Akincilar'),
(744, 58, 'Altinyayla'),
(745, 58, 'Divrigi'),
(746, 58, 'Dogansar'),
(747, 58, 'Gemerek'),
(748, 58, 'Gölova'),
(749, 58, 'Gürün'),
(750, 58, 'Hafik'),
(751, 58, 'Imranli'),
(752, 58, 'Kangal'),
(753, 58, 'Koyulhisar'),
(754, 58, 'Susehri'),
(755, 58, 'Sarkisla'),
(756, 58, 'Ulas'),
(757, 58, 'Yildizeli'),
(758, 58, 'Zara'),
(759, 59, 'Merkez'),
(760, 59, 'Çerkezköy'),
(761, 59, 'Çorlu'),
(762, 59, 'Hayrabolu'),
(763, 59, 'Malkara'),
(764, 59, 'Marmaraeregli'),
(765, 59, 'Muratli'),
(766, 59, 'Saray'),
(767, 59, 'Sarköy'),
(768, 60, 'Merkez'),
(769, 60, 'Almus'),
(770, 60, 'Artova'),
(771, 60, 'Basçiftlik'),
(772, 60, 'Erbaa'),
(773, 60, 'Niksar'),
(774, 60, 'Pazar'),
(775, 60, 'Resadiye'),
(776, 60, 'Sulusaray'),
(777, 60, 'Turhal'),
(778, 60, 'Yesilyurt'),
(779, 60, 'Zile'),
(780, 61, 'Merkez'),
(781, 61, 'Akçaabat'),
(782, 61, 'Arakli'),
(783, 61, 'Arsin'),
(784, 61, 'Besikdüzü'),
(785, 61, 'Çarsibasi'),
(786, 61, 'Çaykara'),
(787, 61, 'Dernekpazar'),
(788, 61, 'Düzköy'),
(789, 61, 'Hayrat'),
(790, 61, 'Köprübasi'),
(791, 61, 'Maçka'),
(792, 61, 'Of'),
(793, 61, 'Sürmene'),
(794, 61, 'Salpazari'),
(795, 61, 'Tonya'),
(796, 61, 'Vakfikebir'),
(797, 61, 'Yomra'),
(798, 62, 'Merkez'),
(799, 62, 'Çemisgezek'),
(800, 62, 'Hozat'),
(801, 62, 'Mazgirt'),
(802, 62, 'Nazimiye'),
(803, 62, 'Ovacik'),
(804, 62, 'Pertek'),
(805, 62, 'Pülümür'),
(806, 63, 'Merkez'),
(807, 63, 'Akçakale'),
(808, 63, 'Birecik'),
(809, 63, 'Bozova'),
(810, 63, 'Ceylanpinar'),
(811, 63, 'Halfeti'),
(812, 63, 'Harran'),
(813, 63, 'Hilvan'),
(814, 63, 'Siverek'),
(815, 63, 'Suruç'),
(816, 63, 'Viransehir'),
(817, 64, 'Merkez'),
(818, 64, 'Banaz'),
(819, 64, 'Esme'),
(820, 64, 'Karahalli'),
(821, 64, 'Sivasli'),
(822, 64, 'Ulubey'),
(823, 65, 'Merkez'),
(824, 65, 'Bahçesaray'),
(825, 65, 'Baskale'),
(826, 65, 'Çaldiran'),
(827, 65, 'Çatak'),
(828, 65, 'Edremit'),
(829, 65, 'Ercis'),
(830, 65, 'Gevas'),
(831, 65, 'Gürpinar'),
(832, 65, 'Muradiye'),
(833, 65, 'Özalp'),
(834, 65, 'Saray'),
(835, 66, 'Merkez'),
(836, 66, 'Akdagmadeni'),
(837, 66, 'Aydincik'),
(838, 66, 'Bogazliyan'),
(839, 66, 'Çandir'),
(840, 66, 'Çayiralan'),
(841, 66, 'Çekerek'),
(842, 66, 'Kadisehri'),
(843, 66, 'Sarikaya'),
(844, 66, 'Saraykent'),
(845, 66, 'Sorgun'),
(846, 66, 'Sefaatli'),
(847, 66, 'Yenifakili'),
(848, 66, 'Yerköy'),
(849, 67, 'Merkez'),
(850, 67, 'Alapli'),
(851, 67, 'Çamoluk'),
(852, 67, 'Çaycuma'),
(853, 67, 'Devrek'),
(854, 67, 'Eflani'),
(855, 67, 'Eregli'),
(856, 67, 'Gökçebey'),
(857, 68, 'Merkez'),
(858, 68, 'Agaçören'),
(859, 68, 'Eskil'),
(860, 68, 'Gülagaç'),
(861, 68, 'Güzelyurt'),
(862, 68, 'Ortaköy'),
(863, 68, 'Sariyahsi'),
(864, 69, 'Merkez'),
(865, 69, 'Aydintepe'),
(866, 69, 'Demirözü'),
(867, 70, 'Merkez'),
(868, 70, 'Ayranci'),
(869, 70, 'Basyayla'),
(870, 70, 'Ermenek'),
(871, 70, 'Kazimkarabekir'),
(872, 70, 'Sariveliler'),
(873, 71, 'Merkez'),
(874, 71, 'Bahsili'),
(875, 71, 'Bagliseyh'),
(876, 71, 'Çelebi'),
(877, 71, 'Delice'),
(878, 71, 'Karakeçili'),
(879, 71, 'Keskin'),
(880, 71, 'Sulakyurt'),
(881, 71, 'Yahsihan'),
(882, 72, 'Merkez'),
(883, 72, 'Gercüs'),
(884, 72, 'Hasankeyf'),
(885, 72, 'Besiri'),
(886, 72, 'Kozluk'),
(887, 72, 'Sason'),
(888, 73, 'Merkez'),
(889, 73, 'Beytüsseba'),
(890, 73, 'Uludere'),
(891, 73, 'Cizre'),
(892, 73, 'Idil'),
(893, 73, 'Silopi'),
(894, 73, 'Güçlükonak'),
(895, 74, 'Merkez'),
(896, 74, 'Amasra'),
(897, 74, 'Kurucasile'),
(898, 74, 'Ulus'),
(899, 75, 'Merkez'),
(900, 75, 'Çildir'),
(901, 75, 'Damal'),
(902, 75, 'Göle'),
(903, 75, 'Hanak'),
(904, 75, 'Posof'),
(905, 76, 'Merkez'),
(906, 76, 'Aralik'),
(907, 76, 'Karakoyunlu'),
(908, 76, 'Tuzluca'),
(909, 77, 'Merkez'),
(910, 77, 'Altinova'),
(911, 77, 'Armutlu'),
(912, 77, 'Cinarcik'),
(913, 77, 'Ciftlikkoy'),
(914, 77, 'Termal'),
(915, 78, 'Merkez'),
(916, 78, 'Eflani'),
(917, 78, 'Eskipazar'),
(918, 78, 'Ovacik'),
(919, 78, 'Safranbolu'),
(920, 78, 'Yenice'),
(921, 79, 'Merkez'),
(922, 79, 'Elbeyli'),
(923, 79, 'Musabeyli'),
(924, 79, 'Polateli'),
(925, 80, 'Merkez'),
(926, 80, 'Bahçe'),
(927, 80, 'Hasanbeyli'),
(928, 80, 'Düziçi'),
(929, 80, 'Kadirli'),
(930, 80, 'Sunbas'),
(931, 80, 'Toprakkale'),
(932, 81, 'Merkez'),
(933, 81, 'Akçakoca'),
(934, 81, 'Cumayeri'),
(935, 81, 'Çilimli'),
(936, 81, 'Gölyaka'),
(937, 81, 'Gümüsova'),
(938, 81, 'Kaynasli'),
(939, 81, 'Yigilca');

Yapılan Aramalar

• iller ilçeler sql
  
• il ilçe sql script
  
• il ilçe mysql