Türkiye İl İlçe Veritabanı 2017

2017 yılı en güncel bilgilere göre Türkiyede şuan tam 81 tane il ve 957 tane ilçesi var. 2017 yılı itibari ile en güncel il ilçe isimlerinin veritabanı oluşturma kodu ve veritabanı ekleme sorgularını kopyalayıp kullanabilirsiniz. 2017 İl İlçe Veritabanı Listesi

Güncel 2018 il ilçe veritabanı için tıklayın

Desteklenen Veritabanı

1. MySql İl ilçe veritabanı
2. SQL Server İl ilçe veritabanı
3. Orable İl ilçe veritabanı
4. MS Access İl ilçe veritabanı

MySQL / SQL Server / Oracle / MS Access

İller Tablosu

CREATE TABLE iller(
il_no int NOT NULL,
isim VARCHAR(50),
PRIMARY KEY (il_no)
);

İlçeler Tablosu

CREATE TABLE ilceler(
ilce_no int NOT NULL,
isim VARCHAR(50),
il_no int NOT NULL,
CONSTRAINT fk_il_no FOREIGN KEY (il_no)
REFERENCES iller(il_no)
);

İller Ekleme Sorgusu

INSERT INTO iller VALUES
(1, 'Adana'),
(2, 'Adıyaman'),
(3, 'Afyonkarahisar'),
(4, 'Ağrı'),
(5, 'Amasya'),
(6, 'Ankara'),
(7, 'Antalya'),
(8, 'Artvin'),
(9, 'Aydın'),
(10, 'Balıkesir'),
(11, 'Bilecik'),
(12, 'Bingöl'),
(13, 'Bitlis'),
(14, 'Bolu'),
(15, 'Burdur'),
(16, 'Bursa'),
(17, 'Çanakkale'),
(18, 'Çankırı'),
(19, 'Çorum'),
(20, 'Denizli'),
(21, 'Diyarbakır'),
(22, 'Edirne'),
(23, 'Elâzığ'),
(24, 'Erzincan'),
(25, 'Erzurum'),
(26, 'Eskişehir'),
(27, 'Gaziantep'),
(28, 'Giresun'),
(29, 'Gümüşhane'),
(30, 'Hakkâri'),
(31, 'Hatay'),
(32, 'Isparta'),
(33, 'Mersin'),
(34, 'İstanbul'),
(35, 'İzmir'),
(36, 'Kars'),
(37, 'Kastamonu'),
(38, 'Kayseri'),
(39, 'Kırklareli'),
(40, 'Kırş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, 'Tunceli'),
(63, 'Şanlıurfa'),
(64, 'Uşak'),
(65, 'Van'),
(66, 'Yozgat'),
(67, 'Zonguldak'),
(68, 'Aksaray'),
(69, 'Bayburt'),
(70, 'Karaman'),
(71, 'Kırıkkale'),
(72, 'Batman'),
(73, 'Şırnak'),
(74, 'Bartın'),
(75, 'Ardahan'),
(76, 'Iğdır'),
(77, 'Yalova'),
(78, 'Karabük'),
(79, 'Kilis'),
(80, 'Osmaniye'),
(81, 'Düzce');

İlçeler Ekleme Sorgusu

INSERT INTO ilceler VALUES
(1,'Abana',37),
(2,'Acıgöl',50),
(3,'Acıpayam',20),
(4,'Adaklı',12),
(5,'Adalar',34),
(6,'Adapazarı',54),
(7,'Adıyaman',2),
(8,'Adilcevaz',13),
(9,'Afşin',46),
(10,'Afyonkarahisar',3),
(11,'Ağaçören',68),
(12,'Ağın',23),
(13,'Ağlasun',15),
(14,'Ağlı',37),
(15,'Ağrı',4),
(16,'Ahırlı',42),
(17,'Ahlat',13),
(18,'Ahmetli',45),
(19,'Akçaabat',61),
(20,'Akçadağ',44),
(21,'Akçakale',63),
(22,'Akçakent',40),
(23,'Akçakoca',81),
(24,'Akdağmadeni',66),
(25,'Akdeniz',33),
(26,'Akhisar',45),
(27,'Akıncılar',58),
(28,'Akkışla',38),
(29,'Akkuş',52),
(30,'Akören',42),
(31,'Akpınar',40),
(32,'Aksaray',68),
(33,'Akseki',7),
(34,'Aksu',7),
(35,'Aksu',32),
(36,'Akşehir',42),
(37,'Akyaka',36),
(38,'Akyazı',54),
(39,'Akyurt',6),
(40,'Alaca',19),
(41,'Alacakaya',23),
(42,'Alaçam',55),
(43,'Aladağ',1),
(44,'Alanya',7),
(45,'Alaplı',67),
(46,'Alaşehir',45),
(47,'Aliağa',35),
(48,'Almus',60),
(49,'Alpu',26),
(50,'Altıeylül',10),
(51,'Altındağ',6),
(52,'Altınekin',42),
(53,'Altınordu',52),
(54,'Altınova',77),
(55,'Altınözü',31),
(56,'Altıntaş',43),
(57,'Altınyayla',15),
(58,'Altınyayla',58),
(59,'Altunhisar',51),
(60,'Alucra',28),
(61,'Amasra',74),
(62,'Amasya',5),
(63,'Anamur',33),
(64,'Andırın',46),
(65,'Antakya',31),
(66,'Araban',27),
(67,'Araç',37),
(68,'Araklı',61),
(69,'Aralık',76),
(70,'Arapgir',44),
(71,'Ardahan',75),
(72,'Ardanuç',8),
(73,'Ardeşen',53),
(74,'Arguvan',44),
(75,'Arhavi',8),
(76,'Arıcak',23),
(77,'Arifiye',54),
(78,'Armutlu',77),
(79,'Arnavutköy',34),
(80,'Arpaçay',36),
(81,'Arsin',61),
(82,'Arsuz',31),
(83,'Artova',60),
(84,'Artuklu',47),
(85,'Artvin',8),
(86,'Asarcık',55),
(87,'Aslanapa',43),
(88,'Aşkale',25),
(89,'Atabey',32),
(90,'Atakum',55),
(91,'Ataşehir',34),
(92,'Atkaracalar',18),
(93,'Avanos',50),
(94,'Avcılar',34),
(95,'Ayancık',57),
(96,'Ayaş',6),
(97,'Aybastı',52),
(98,'Aydıncık',33),
(99,'Aydıncık',66),
(100,'Aydıntepe',69);

INSERT INTO ilceler VALUES
(101,'Ayrancı',70),
(102,'Ayvacık',17),
(103,'Ayvacık',55),
(104,'Ayvalık',10),
(105,'Azdavay',37),
(106,'Aziziye',25),
(107,'Babadağ',20),
(108,'Babaeski',39),
(109,'Bafra',55),
(110,'Bağcılar',34),
(111,'Bağlar',21),
(112,'Bahçe',80),
(113,'Bahçelievler',34),
(114,'Bahçesaray',65),
(115,'Bahşili',71),
(116,'Bakırköy',34),
(117,'Baklan',20),
(118,'Bala',6),
(119,'Balçova',35),
(120,'Balışeyh',71),
(121,'Balya',10),
(122,'Banaz',64),
(123,'Bandırma',10),
(124,'Bartın',74),
(125,'Baskil',23),
(126,'Başakşehir',34),
(127,'Başçiftlik',60),
(128,'Başiskele',41),
(129,'Başkale',65),
(130,'Başmakçı',3),
(131,'Başyayla',70),
(132,'Batman',72),
(133,'Battalgazi',44),
(134,'Bayat',3),
(135,'Bayat',19),
(136,'Bayburt',69),
(137,'Bayındır',35),
(138,'Baykan',56),
(139,'Bayraklı',35),
(140,'Bayramiç',17),
(141,'Bayramören',18),
(142,'Bayrampaşa',34),
(143,'Bekilli',20),
(144,'Belen',31),
(145,'Bergama',35),
(146,'Besni',2),
(147,'Beşikdüzü',61),
(148,'Beşiktaş',34),
(149,'Beşiri',72),
(150,'Beyağaç',20),
(151,'Beydağ',35),
(152,'Beykoz',34),
(153,'Beylikdüzü',34),
(154,'Beylikova',26),
(155,'Beyoğlu',34),
(156,'Beypazarı',6),
(157,'Beyşehir',42),
(158,'Beytüşşebap',73),
(159,'Biga',17),
(160,'Bigadiç',10),
(161,'Bilecik',11),
(162,'Bingöl',12),
(163,'Birecik',63),
(164,'Bismil',21),
(165,'Bitlis',13),
(166,'Bodrum',48),
(167,'Boğazkale',19),
(168,'Boğazlıyan',66),
(169,'Bolu',14),
(170,'Bolvadin',3),
(171,'Bor',51),
(172,'Borçka',8),
(173,'Bornova',35),
(174,'Boyabat',57),
(175,'Bozcaada',17),
(176,'Bozdoğan',9),
(177,'Bozkır',42),
(178,'Bozkurt',20),
(179,'Bozkurt',37),
(180,'Bozova',63),
(181,'Boztepe',40),
(182,'Bozüyük',11),
(183,'Bozyazı',33),
(184,'Buca',35),
(185,'Bucak',15),
(186,'Buharkent',9),
(187,'Bulancak',28),
(188,'Bulanık',49),
(189,'Buldan',20),
(190,'Burdur',15),
(191,'Burhaniye',10),
(192,'Bünyan',38),
(193,'Büyükçekmece',34),
(194,'Büyükorhan',16),
(195,'Canik',55),
(196,'Ceyhan',1),
(197,'Ceylanpınar',63),
(198,'Cide',37),
(199,'Cihanbeyli',42),
(200,'Cizre',73);

INSERT INTO ilceler VALUES
(201,'Cumayeri',81),
(202,'Çağlayancerit',46),
(203,'Çal',20),
(204,'Çaldıran',65),
(205,'Çamardı',51),
(206,'Çamaş',52),
(207,'Çameli',20),
(208,'Çamlıdere',6),
(209,'Çamlıhemşin',53),
(210,'Çamlıyayla',33),
(211,'Çamoluk',28),
(212,'Çan',17),
(213,'Çanakçı',28),
(214,'Çanakkale',17),
(215,'Çandır',66),
(216,'Çankaya',6),
(217,'Çankırı',18),
(218,'Çardak',20),
(219,'Çarşamba',55),
(220,'Çarşıbaşı',61),
(221,'Çat',25),
(222,'Çatak',65),
(223,'Çatalca',34),
(224,'Çatalpınar',52),
(225,'Çatalzeytin',37),
(226,'Çavdarhisar',43),
(227,'Çavdır',15),
(228,'Çay',3),
(229,'Çaybaşı',52),
(230,'Çaycuma',67),
(231,'Çayeli',53),
(232,'Çayıralan',66),
(233,'Çayırlı',24),
(234,'Çayırova',41),
(235,'Çaykara',61),
(236,'Çekerek',66),
(237,'Çekmeköy',34),
(238,'Çelebi',71),
(239,'Çelikhan',2),
(240,'Çeltik',42),
(241,'Çeltikçi',15),
(242,'Çemişgezek',62),
(243,'Çerkeş',18),
(244,'Çerkezköy',59),
(245,'Çermik',21),
(246,'Çeşme',35),
(247,'Çıldır',75),
(248,'Çınar',21),
(249,'Çınarcık',77),
(250,'Çiçekdağı',40),
(251,'Çifteler',26),
(252,'Çiftlik',51),
(253,'Çiftlikköy',77),
(254,'Çiğli',35),
(255,'Çilimli',81),
(256,'Çine',9),
(257,'Çivril',20),
(258,'Çobanlar',3),
(259,'Çorlu',59),
(260,'Çorum',19),
(261,'Çubuk',6),
(262,'Çukurca',30),
(263,'Çukurova',1),
(264,'Çumra',42),
(265,'Çüngüş',21),
(266,'Daday',37),
(267,'Dalaman',48),
(268,'Damal',75),
(269,'Darende',44),
(270,'Dargeçit',47),
(271,'Darıca',41),
(272,'Datça',48),
(273,'Dazkırı',3),
(274,'Defne',31),
(275,'Delice',71),
(276,'Demirci',45),
(277,'Demirköy',39),
(278,'Demirözü',69),
(279,'Demre',7),
(280,'Derbent',42),
(281,'Derebucak',42),
(282,'Dereli',28),
(283,'Derepazarı',53),
(284,'Derik',47),
(285,'Derince',41),
(286,'Derinkuyu',50),
(287,'Dernekpazarı',61),
(288,'Develi',38),
(289,'Devrek',67),
(290,'Devrekani',37),
(291,'Dicle',21),
(292,'Didim',9),
(293,'Digor',36),
(294,'Dikili',35),
(295,'Dikmen',57),
(296,'Dilovası',41),
(297,'Dinar',3),
(298,'Divriği',58),
(299,'Diyadin',4),
(300,'Dodurga',19);

INSERT INTO ilceler VALUES
(301,'Doğanhisar',42),
(302,'Doğankent',28),
(303,'Doğanşar',58),
(304,'Doğanşehir',44),
(305,'Doğanyol',44),
(306,'Doğanyurt',37),
(307,'Doğubayazıt',4),
(308,'Domaniç',43),
(309,'Dörtdivan',14),
(310,'Dörtyol',31),
(311,'Döşemealtı',7),
(312,'Dulkadiroğlu',46),
(313,'Dumlupınar',43),
(314,'Durağan',57),
(315,'Dursunbey',10),
(316,'Düzce',81),
(317,'Düziçi',80),
(318,'Düzköy',61),
(319,'Eceabat',17),
(320,'Edirne',22),
(321,'Edremit',10),
(322,'Edremit',65),
(323,'Efeler',9),
(324,'Eflani',78),
(325,'Eğil',21),
(326,'Eğirdir',32),
(327,'Ekinözü',46),
(328,'Elazığ',23),
(329,'Elbeyli',79),
(330,'Elbistan',46),
(331,'Eldivan',18),
(332,'Eleşkirt',4),
(333,'Elmadağ',6),
(334,'Elmalı',7),
(335,'Emet',43),
(336,'Emirdağ',3),
(337,'Emirgazi',42),
(338,'Enez',22),
(339,'Erbaa',60),
(340,'Erciş',65),
(341,'Erdek',10),
(342,'Erdemli',33),
(343,'Ereğli',42),
(344,'Ereğli',67),
(345,'Erenler',54),
(346,'Erfelek',57),
(347,'Ergani',21),
(348,'Ergene',59),
(349,'Ermenek',70),
(350,'Eruh',56),
(351,'Erzin',31),
(352,'Erzincan',24),
(353,'Esenler',34),
(354,'Esenyurt',34),
(355,'Eskil',68),
(356,'Eskipazar',78),
(357,'Espiye',28),
(358,'Eşme',64),
(359,'Etimesgut',6),
(360,'Evciler',3),
(361,'Evren',6),
(362,'Eynesil',28),
(363,'Eyüp',34),
(364,'Eyyübiye',63),
(365,'Ezine',17),
(366,'Fatih',34),
(367,'Fatsa',52),
(368,'Feke',1),
(369,'Felahiye',38),
(370,'Ferizli',54),
(371,'Fethiye',48),
(372,'Fındıklı',53),
(373,'Finike',7),
(374,'Foça',35),
(375,'Gaziemir',35),
(376,'Gaziosmanpaşa',34),
(377,'Gazipaşa',7),
(378,'Gebze',41),
(379,'Gediz',43),
(380,'Gelendost',32),
(381,'Gelibolu',17),
(382,'Gemerek',58),
(383,'Gemlik',16),
(384,'Genç',12),
(385,'Gercüş',72),
(386,'Gerede',14),
(387,'Gerger',2),
(388,'Germencik',9),
(389,'Gerze',57),
(390,'Gevaş',65),
(391,'Geyve',54),
(392,'Giresun',28),
(393,'Gökçeada',17),
(394,'Gökçebey',67),
(395,'Göksun',46),
(396,'Gölbaşı',2),
(397,'Gölbaşı',6),
(398,'Gölcük',41),
(399,'Göle',75),
(400,'Gölhisar',15);

INSERT INTO ilceler VALUES
(401,'Gölköy',52),
(402,'Gölmarmara',45),
(403,'Gölova',58),
(404,'Gölpazarı',11),
(405,'Gölyaka',81),
(406,'Gömeç',10),
(407,'Gönen',10),
(408,'Gönen',32),
(409,'Gördes',45),
(410,'Görele',28),
(411,'Göynücek',5),
(412,'Göynük',14),
(413,'Güce',28),
(414,'Güçlükonak',73),
(415,'Güdül',6),
(416,'Gülağaç',68),
(417,'Gülnar',33),
(418,'Gülşehir',50),
(419,'Gülyalı',52),
(420,'Gümüşhacıköy',5),
(421,'Gümüşhane',29),
(422,'Gümüşova',81),
(423,'Gündoğmuş',7),
(424,'Güney',20),
(425,'Güneysınır',42),
(426,'Güneysu',53),
(427,'Güngören',34),
(428,'Günyüzü',26),
(429,'Gürgentepe',52),
(430,'Güroymak',13),
(431,'Gürpınar',65),
(432,'Gürsu',16),
(433,'Gürün',58),
(434,'Güzelbahçe',35),
(435,'Güzelyurt',68),
(436,'Hacıbektaş',50),
(437,'Hacılar',38),
(438,'Hadim',42),
(439,'Hafik',58),
(440,'Hakkâri',30),
(441,'Halfeti',63),
(442,'Haliliye',63),
(443,'Halkapınar',42),
(444,'Hamamözü',5),
(445,'Hamur',4),
(446,'Han',26),
(447,'Hanak',75),
(448,'Hani',21),
(449,'Hanönü',37),
(450,'Harmancık',16),
(451,'Harran',63),
(452,'Hasanbeyli',80),
(453,'Hasankeyf',72),
(454,'Hasköy',49),
(455,'Hassa',31),
(456,'Havran',10),
(457,'Havsa',22),
(458,'Havza',55),
(459,'Haymana',6),
(460,'Hayrabolu',59),
(461,'Hayrat',61),
(462,'Hazro',21),
(463,'Hekimhan',44),
(464,'Hemşin',53),
(465,'Hendek',54),
(466,'Hınıs',25),
(467,'Hilvan',63),
(468,'Hisarcık',43),
(469,'Hizan',13),
(470,'Hocalar',3),
(471,'Honaz',20),
(472,'Hopa',8),
(473,'Horasan',25),
(474,'Hozat',62),
(475,'Hüyük',42),
(476,'Iğdır',76),
(477,'Ilgaz',18),
(478,'Ilgın',42),
(479,'Isparta',32),
(480,'İbradı',7),
(481,'İdil',73),
(482,'İhsangazi',37),
(483,'İhsaniye',3),
(484,'İkizce',52),
(485,'İkizdere',53),
(486,'İliç',24),
(487,'İlkadım',55),
(488,'İmamoğlu',1),
(489,'İmranlı',58),
(490,'İncesu',38),
(491,'İncirliova',9),
(492,'İnebolu',37),
(493,'İnegöl',16),
(494,'İnhisar',11),
(495,'İnönü',26),
(496,'İpekyolu',65),
(497,'İpsala',22),
(498,'İscehisar',3),
(499,'İskenderun',31),
(500,'İskilip',19);

INSERT INTO ilceler VALUES
(501,'İslahiye',27),
(502,'İspir',25),
(503,'İvrindi',10),
(504,'İyidere',53),
(505,'İzmit',41),
(506,'İznik',16),
(507,'Kabadüz',52),
(508,'Kabataş',52),
(509,'Kadıköy',34),
(510,'Kadınhanı',42),
(511,'Kadışehri',66),
(512,'Kadirli',80),
(513,'Kağıthane',34),
(514,'Kağızman',36),
(515,'Kahta',2),
(516,'Kale',20),
(517,'Kale',44),
(518,'Kalecik',6),
(519,'Kalkandere',53),
(520,'Kaman',40),
(521,'Kandıra',41),
(522,'Kangal',58),
(523,'Kapaklı',59),
(524,'Karabağlar',35),
(525,'Karaburun',35),
(526,'Karabük',78),
(527,'Karacabey',16),
(528,'Karacasu',9),
(529,'Karaçoban',25),
(530,'Karahallı',64),
(531,'Karaisalı',1),
(532,'Karakeçili',71),
(533,'Karakoçan',23),
(534,'Karakoyunlu',76),
(535,'Karaköprü',63),
(536,'Karaman',70),
(537,'Karamanlı',15),
(538,'Karamürsel',41),
(539,'Karapınar',42),
(540,'Karapürçek',54),
(541,'Karasu',54),
(542,'Karataş',1),
(543,'Karatay',42),
(544,'Karayazı',25),
(545,'Karesi',10),
(546,'Kargı',19),
(547,'Karkamış',27),
(548,'Karlıova',12),
(549,'Karpuzlu',9),
(550,'Kars',36),
(551,'Karşıyaka',35),
(552,'Kartal',34),
(553,'Kartepe',41),
(554,'Kastamonu',37),
(555,'Kaş',7),
(556,'Kavak',55),
(557,'Kavaklıdere',48),
(558,'Kayapınar',21),
(559,'Kaynarca',54),
(560,'Kaynaşlı',81),
(561,'Kazan',6),
(562,'Kazımkarabekir',70),
(563,'Keban',23),
(564,'Keçiborlu',32),
(565,'Keçiören',6),
(566,'Keles',16),
(567,'Kelkit',29),
(568,'Kemah',24),
(569,'Kemaliye',24),
(570,'Kemalpaşa',35),
(571,'Kemer',7),
(572,'Kemer',15),
(573,'Kepez',7),
(574,'Kepsut',10),
(575,'Keskin',71),
(576,'Kestel',16),
(577,'Keşan',22),
(578,'Keşap',28),
(579,'Kıbrıscık',14),
(580,'Kınık',35),
(581,'Kırıkhan',31),
(582,'Kırıkkale',71),
(583,'Kırkağaç',45),
(584,'Kırklareli',39),
(585,'Kırşehir',40),
(586,'Kızılcahamam',6),
(587,'Kızılırmak',18),
(588,'Kızılören',3),
(589,'Kızıltepe',47),
(590,'Kiğı',12),
(591,'Kilimli',67),
(592,'Kilis',79),
(593,'Kiraz',35),
(594,'Kocaali',54),
(595,'Kocaköy',21),
(596,'Kocasinan',38),
(597,'Koçarlı',9),
(598,'Kofçaz',39),
(599,'Konak',35),
(600,'Konyaaltı',7);

INSERT INTO ilceler VALUES
(601,'Korgan',52),
(602,'Korgun',18),
(603,'Korkut',49),
(604,'Korkuteli',7),
(605,'Kovancılar',23),
(606,'Koyulhisar',58),
(607,'Kozaklı',50),
(608,'Kozan',1),
(609,'Kozlu',67),
(610,'Kozluk',72),
(611,'Köprübaşı',45),
(612,'Köprübaşı',61),
(613,'Köprüköy',25),
(614,'Körfez',41),
(615,'Köse',29),
(616,'Köşk',9),
(617,'Köyceğiz',48),
(618,'Kula',45),
(619,'Kulp',21),
(620,'Kulu',42),
(621,'Kuluncak',44),
(622,'Kumlu',31),
(623,'Kumluca',7),
(624,'Kumru',52),
(625,'Kurşunlu',18),
(626,'Kurtalan',56),
(627,'Kurucaşile',74),
(628,'Kuşadası',9),
(629,'Kuyucak',9),
(630,'Küçükçekmece',34),
(631,'Küre',37),
(632,'Kürtün',29),
(633,'Kütahya',43),
(634,'Laçin',19),
(635,'Ladik',55),
(636,'Lalapaşa',22),
(637,'Lapseki',17),
(638,'Lice',21),
(639,'Lüleburgaz',39),
(640,'Maçka',61),
(641,'Maden',23),
(642,'Mahmudiye',26),
(643,'Malazgirt',49),
(644,'Malkara',59),
(645,'Maltepe',34),
(646,'Mamak',6),
(647,'Manavgat',7),
(648,'Manyas',10),
(649,'Marmara',10),
(650,'Marmaraereğlisi',59),
(651,'Marmaris',48),
(652,'Mazgirt',62),
(653,'Mazıdağı',47),
(654,'Mecitözü',19),
(655,'Melikgazi',38),
(656,'Menderes',35),
(657,'Menemen',35),
(658,'Mengen',14),
(659,'Menteşe',48),
(660,'Meram',42),
(661,'Meriç',22),
(662,'Merkezefendi',20),
(663,'Merzifon',5),
(664,'Mesudiye',52),
(665,'Mezitli',33),
(666,'Midyat',47),
(667,'Mihalgazi',26),
(668,'Mihalıççık',26),
(669,'Milas',48),
(670,'Mucur',40),
(671,'Mudanya',16),
(672,'Mudurnu',14),
(673,'Muradiye',65),
(674,'Muratlı',59),
(675,'Muratpaşa',7),
(676,'Murgul',8),
(677,'Musabeyli',79),
(678,'Mustafakemalpaşa',16),
(679,'Muş',49),
(680,'Mut',33),
(681,'Mutki',13),
(682,'Nallıhan',6),
(683,'Narlıdere',35),
(684,'Narman',25),
(685,'Nazımiye',62),
(686,'Nazilli',9),
(687,'Nevşehir',50),
(688,'Niğde',51),
(689,'Niksar',60),
(690,'Nilüfer',16),
(691,'Nizip',27),
(692,'Nurdağı',27),
(693,'Nurhak',46),
(694,'Nusaybin',47),
(695,'Odunpazarı',26),
(696,'Of',61),
(697,'Oğuzeli',27),
(698,'Oğuzlar',19),
(699,'Oltu',25),
(700,'Olur',25);

INSERT INTO ilceler VALUES
(701,'Ondokuzmayıs',55),
(702,'Onikişubat',46),
(703,'Orhaneli',16),
(704,'Orhangazi',16),
(705,'Orta',18),
(706,'Ortaca',48),
(707,'Ortahisar',61),
(708,'Ortaköy',68),
(709,'Ortaköy',19),
(710,'Osmancık',19),
(711,'Osmaneli',11),
(712,'Osmangazi',16),
(713,'Osmaniye',80),
(714,'Otlukbeli',24),
(715,'Ovacık',78),
(716,'Ovacık',62),
(717,'Ödemiş',35),
(718,'Ömerli',47),
(719,'Özalp',65),
(720,'Özvatan',38),
(721,'Palandöken',25),
(722,'Palu',23),
(723,'Pamukkale',20),
(724,'Pamukova',54),
(725,'Pasinler',25),
(726,'Patnos',4),
(727,'Payas',31),
(728,'Pazar',53),
(729,'Pazar',60),
(730,'Pazarcık',46),
(731,'Pazarlar',43),
(732,'Pazaryeri',11),
(733,'Pazaryolu',25),
(734,'Pehlivanköy',39),
(735,'Pendik',34),
(736,'Perşembe',52),
(737,'Pertek',62),
(738,'Pervari',56),
(739,'Pınarbaşı',37),
(740,'Pınarbaşı',38),
(741,'Pınarhisar',39),
(742,'Piraziz',28),
(743,'Polateli',79),
(744,'Polatlı',6),
(745,'Posof',75),
(746,'Pozantı',1),
(747,'Pursaklar',6),
(748,'Pülümür',62),
(749,'Pütürge',44),
(750,'Refahiye',24),
(751,'Reşadiye',60),
(752,'Reyhanlı',31),
(753,'Rize',53),
(754,'Safranbolu',78),
(755,'Saimbeyli',1),
(756,'Salıpazarı',55),
(757,'Salihli',45),
(758,'Samandağ',31),
(759,'Samsat',2),
(760,'Sancaktepe',34),
(761,'Sandıklı',3),
(762,'Sapanca',54),
(763,'Saray',59),
(764,'Saray',65),
(765,'Saraydüzü',57),
(766,'Saraykent',66),
(767,'Sarayköy',20),
(768,'Sarayönü',42),
(769,'Sarıcakaya',26),
(770,'Sarıçam',1),
(771,'Sarıgöl',45),
(772,'Sarıkamış',36),
(773,'Sarıkaya',66),
(774,'Sarıoğlan',38),
(775,'Sarıveliler',70),
(776,'Sarıyahşi',68),
(777,'Sarıyer',34),
(778,'Sarız',38),
(779,'Saruhanlı',45),
(780,'Sason',72),
(781,'Savaştepe',10),
(782,'Savur',47),
(783,'Seben',14),
(784,'Seferihisar',35),
(785,'Selçuk',35),
(786,'Selçuklu',42),
(787,'Selendi',45),
(788,'Selim',36),
(789,'Senirkent',32),
(790,'Serdivan',54),
(791,'Serik',7),
(792,'Serinhisar',20),
(793,'Seydikemer',48),
(794,'Seydiler',37),
(795,'Seydişehir',42),
(796,'Seyhan',1),
(797,'Seyitgazi',26),
(798,'Sındırgı',10),
(799,'Siirt',56),
(800,'Silifke',33);

INSERT INTO ilceler VALUES
(801,'Silivri',34),
(802,'Silopi',73),
(803,'Silvan',21),
(804,'Simav',43),
(805,'Sinanpaşa',3),
(806,'Sincan',6),
(807,'Sincik',2),
(808,'Sinop',57),
(809,'Sivas',58),
(810,'Sivaslı',64),
(811,'Siverek',63),
(812,'Sivrice',23),
(813,'Sivrihisar',26),
(814,'Solhan',12),
(815,'Soma',45),
(816,'Sorgun',66),
(817,'Söğüt',11),
(818,'Söğütlü',54),
(819,'Söke',9),
(820,'Sulakyurt',71),
(821,'Sultanbeyli',34),
(822,'Sultandağı',3),
(823,'Sultangazi',34),
(824,'Sultanhisar',9),
(825,'Suluova',5),
(826,'Sulusaray',60),
(827,'Sumbas',80),
(828,'Sungurlu',19),
(829,'Sur',21),
(830,'Suruç',63),
(831,'Susurluk',10),
(832,'Susuz',36),
(833,'Suşehri',58),
(834,'Süleymanpaşa',59),
(835,'Süloğlu',22),
(836,'Sürmene',61),
(837,'Sütçüler',32),
(838,'Şabanözü',18),
(839,'Şahinbey',27),
(840,'Şalpazarı',61),
(841,'Şaphane',43),
(842,'Şarkışla',58),
(843,'Şarkikaraağaç',32),
(844,'Şarköy',59),
(845,'Şavşat',8),
(846,'Şebinkarahisar',28),
(847,'Şefaatli',66),
(848,'Şehitkamil',27),
(849,'Şehzadeler',45),
(850,'Şemdinli',30),
(851,'Şenkaya',25),
(852,'Şenpazar',37),
(853,'Şereflikoçhisar',6),
(854,'Şırnak',73),
(855,'Şile',34),
(856,'Şiran',29),
(857,'Şirvan',56),
(858,'Şişli',34),
(859,'Şuhut',3),
(860,'Talas',38),
(861,'Taraklı',54),
(862,'Tarsus',33),
(863,'Taşkent',42),
(864,'Taşköprü',37),
(865,'Taşlıçay',4),
(866,'Taşova',5),
(867,'Tatvan',13),
(868,'Tavas',20),
(869,'Tavşanlı',43),
(870,'Tefenni',15),
(871,'Tekkeköy',55),
(872,'Tekman',25),
(873,'Tepebaşı',26),
(874,'Tercan',24),
(875,'Termal',77),
(876,'Terme',55),
(877,'Tillo',56),
(878,'Tire',35),
(879,'Tirebolu',28),
(880,'Tokat',60),
(881,'Tomarza',38),
(882,'Tonya',61),
(883,'Toprakkale',80),
(884,'Torbalı',35),
(885,'Toroslar',33),
(886,'Tortum',25),
(887,'Torul',29),
(888,'Tosya',37),
(889,'Tufanbeyli',1),
(890,'Tunceli',62),
(891,'Turgutlu',45),
(892,'Turhal',60),
(893,'Tuşba',65),
(894,'Tut',2),
(895,'Tutak',4),
(896,'Tuzla',34),
(897,'Tuzluca',76),
(898,'Tuzlukçu',42),
(899,'Türkeli',57),
(900,'Türkoğlu',46);

INSERT INTO ilceler VALUES
(901,'Uğurludağ',19),
(902,'Ula',48),
(903,'Ulaş',58),
(904,'Ulubey',52),
(905,'Ulubey',64),
(906,'Uluborlu',32),
(907,'Uludere',73),
(908,'Ulukışla',51),
(909,'Ulus',74),
(910,'Urla',35),
(911,'Uşak',64),
(912,'Uzundere',25),
(913,'Uzunköprü',22),
(914,'Ümraniye',34),
(915,'Ünye',52),
(916,'Ürgüp',50),
(917,'Üsküdar',34),
(918,'Üzümlü',24),
(919,'Vakfıkebir',61),
(920,'Varto',49),
(921,'Vezirköprü',55),
(922,'Viranşehir',63),
(923,'Vize',39),
(924,'Yağlıdere',28),
(925,'Yahşihan',71),
(926,'Yahyalı',38),
(927,'Yakakent',55),
(928,'Yakutiye',25),
(929,'Yalıhüyük',42),
(930,'Yalova',77),
(931,'Yalvaç',32),
(932,'Yapraklı',18),
(933,'Yatağan',48),
(934,'Yavuzeli',27),
(935,'Yayladağı',31),
(936,'Yayladere',12),
(937,'Yazıhan',44),
(938,'Yedisu',12),
(939,'Yenice',17),
(940,'Yenice',78),
(941,'Yeniçağa',14),
(942,'Yenifakılı',66),
(943,'Yenimahalle',6),
(944,'Yenipazar',9),
(945,'Yenipazar',11),
(946,'Yenişarbademli',32),
(947,'Yenişehir',16),
(948,'Yenişehir',21),
(949,'Yenişehir',33),
(950,'Yerköy',66),
(951,'Yeşilhisar',38),
(952,'Yeşilli',47),
(953,'Yeşilova',15),
(954,'Yeşilyurt',44),
(955,'Yeşilyurt',60),
(956,'Yığılca',81),
(957,'Yıldırım',16),
(958,'Yıldızeli',58),
(959,'Yomra',61),
(960,'Yozgat',66),
(961,'Yumurtalık',1),
(962,'Yunak',42),
(963,'Yunusemre',45),
(964,'Yusufeli',8),
(965,'Yüksekova',30),
(966,'Yüreğir',1),
(967,'Zara',58),
(968,'Zeytinburnu',34),
(969,'Zile',60),
(970,'Zonguldak',67);

INSERT INTO `ilceler` (`ilce_no`, `isim`, `il_no`) VALUES 
('971', 'Kemalpaşa', '8'),
('972', 'Sultanhanı', '68');