SQL səhvi
Aşağıdakı SQL sənədi myadminə yüklədiyim zaman sənəddə səhv olduğunu göstərir. Başı çıxan varsa kömək etsin.
SQL
[code]DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`pwd` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
INSERT INTO `admin`(`id`, `name`, `pwd`) VALUES ('1', 'celal', 'asd987c');
INSERT INTO `admin`(`id`, `name`, `pwd`) VALUES ('2', 'cihan', '530571');
INSERT INTO `admin`(`id`, `name`, `pwd`) VALUES ('4', 'fatih', 'gurbet');
DROP TABLE IF EXISTS `adres_bilgileri`;
CREATE TABLE `adres_bilgileri` (
`Id` int(11) NOT NULL auto_increment,
`Emlak_id` int(11) NOT NULL default '0',
`Sehir_id` int(11) NOT NULL default '0',
`Ilce_id` int(11) NOT NULL default '0',
`Adres` text NOT NULL,
`Bina_adi` varchar(100) NOT NULL default '',
`Kat` int(11) NOT NULL default '0',
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=235 DEFAULT CHARSET=latin1;
INSERT INTO `adres_bilgileri`(`Id`, `Emlak_id`, `Sehir_id`, `Ilce_id`, `Adres`, `Bina_adi`, `Kat`) VALUES ('227', '255', '1', '31', '', '', '0');
DROP TABLE IF EXISTS `emlak`;
CREATE TABLE `emlak` (
`Id` int(11) NOT NULL auto_increment,
`Emlak_No` int(11) NOT NULL default '0',
`Fiyat` varchar(255) NOT NULL default '0',
`Fiyat_Tipi` int(11) NOT NULL default '0',
`Depozito` varchar(50) NOT NULL default '',
`Notlar` text NOT NULL,
`Hit` int(11) NOT NULL default '0',
`Tarih` date NOT NULL default '0000-00-00',
`Lang` char(2) NOT NULL default '',
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=263 DEFAULT CHARSET=latin1;
INSERT INTO `emlak`(`Id`, `Emlak_No`, `Fiyat`, `Fiyat_Tipi`, `Depozito`, `Notlar`, `Hit`, `Tarih`, `Lang`) VALUES ('57', '103', '132', '1', '', '102', '0', '2006-02-14', '');
DROP TABLE IF EXISTS `emlak_ayrinti`;
CREATE TABLE `emlak_ayrinti` (
`Id` int(11) NOT NULL auto_increment,
`Emlak_Id` int(11) NOT NULL default '0',
`Emlak_tipi` int(11) NOT NULL default '0',
`Emlak_durum` varchar(100) NOT NULL default '',
`Oda_sayisi` varchar(100) NOT NULL default '0',
`Salon_sayisi` varchar(100) NOT NULL default '0',
`Banyo_sayisi` varchar(11) NOT NULL default '0',
`Metre_kare` float NOT NULL default '0',
`Emlak_ozellikler` varchar(255) NOT NULL default '',
`Manzara` tinytext NOT NULL,
`Isitma` varchar(100) NOT NULL default '',
`Bina_yasi` varchar(255) NOT NULL default '0',
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=234 DEFAULT CHARSET=latin1;
INSERT INTO `emlak_ayrinti`(`Id`, `Emlak_Id`, `Emlak_tipi`, `Emlak_durum`, `Oda_sayisi`, `Salon_sayisi`, `Banyo_sayisi`, `Metre_kare`, `Emlak_ozellikler`, `Manzara`, `Isitma`, `Bina_yasi`) VALUES ('226', '255', '2', '1', '3+1', '', '0', '100', '', '', '', '0');
DROP TABLE IF EXISTS `emlak_ozellikleri`;
CREATE TABLE `emlak_ozellikleri` (
`id` int(11) NOT NULL auto_increment,
`adi` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('21', 'Hidrofor');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('17', 'Asansцr');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('18', 'Deniz Manzarasэ');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('19', 'Tenis Kortu');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('20', 'Зelik Kapэ');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('26', 'Boрaz Manzarasэ');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('25', 'Otopark');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('24', 'Balkon');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('23', 'Teras');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('22', 'Doрa Manzarasэ');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('27', 'Su Deposu');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('28', 'Parke Zemin');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('29', 'Mobilya');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('30', 'Bahзe');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('31', 'Jeneratцr');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('32', 'Jakuzi');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('33', 'Beyaz Eюya');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('34', 'Oyun Parkэ');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('35', 'Юцmine');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('36', 'Uydu');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('37', 'Doрalgaz');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('38', 'Site Эзerisinde');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('39', 'Kapэcэ');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('40', 'Kablo TV');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('41', 'Dubleks');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('42', 'Yьzme Havuzu');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('43', 'Alarm');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('45', 'Tripleks');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('46', 'Kapalэ Garaj');
INSERT INTO `emlak_ozellikleri`(`id`, `adi`) VALUES ('47', 'Gьvenlik');
DROP TABLE IF EXISTS `emlak_resim`;
CREATE TABLE `emlak_resim` (
`id` int(11) NOT NULL auto_increment,
`emlak_id` int(11) default NULL,
`name` varchar(255) default NULL,
`buyuk_resim` longblob,
`kucuk_resim` longblob,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=314 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `emlak_tipleri`;
CREATE TABLE `emlak_tipleri` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
INSERT INTO `emlak_tipleri`(`id`, `name`) VALUES ('3', 'Ofis');
INSERT INTO `emlak_tipleri`(`id`, `name`) VALUES ('2', 'Daire');
INSERT INTO `emlak_tipleri`(`id`, `name`) VALUES ('4', 'Bina');
INSERT INTO `emlak_tipleri`(`id`, `name`) VALUES ('6', 'Arsa');
INSERT INTO `emlak_tipleri`(`id`, `name`) VALUES ('8', 'Dьkkan');
INSERT INTO `emlak_tipleri`(`id`, `name`) VALUES ('9', 'Villa');
INSERT INTO `emlak_tipleri`(`id`, `name`) VALUES ('10', 'Эюyeri');
INSERT INTO `emlak_tipleri`(`id`, `name`) VALUES ('11', 'Dubleks');
INSERT INTO `emlak_tipleri`(`id`, `name`) VALUES ('12', 'TARLA');
INSERT INTO `emlak_tipleri`(`id`, `name`) VALUES ('14', 'devren');
DROP TABLE IF EXISTS `ilce`;
CREATE TABLE `ilce` (
`Id` int(11) NOT NULL auto_increment,
`Sehir_id` int(11) NOT NULL default '0',
`adi` varchar(100) NOT NULL default '',
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=892 DEFAULT CHARSET=latin1;
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('2', '1', 'ISTANBUL-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('3', '1', 'AVCILAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('4', '1', 'BAHЗELIEVLER');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('5', '1', 'BAYRAMPASA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('6', '1', 'BEYKOZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('7', '1', 'BESIKTAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('8', '1', 'BЬYЬKЗEKMECE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('9', '1', 'EYЬP');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('10', '1', 'GAZIOSMANPASA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('11', '1', 'KADIKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('12', '1', 'KARTAL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('13', '1', 'KЬЗЬKЗEKMECE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('14', '1', 'PENDIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('15', '1', 'SARIYER');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('16', '1', 'SILIVRI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('17', '1', 'TUZLA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('18', '1', 'YALOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('19', '1', 'ZEYTINBURNU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('20', '1', 'ЗATALCA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('21', '1', 'ЬMRANIYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('22', '1', 'ЬSKЬDAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('23', '1', 'ЮILE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('24', '1', 'ЮIЮLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('25', '1', 'ADALAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('26', '1', 'BAKIRKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('27', '1', ' BAGCILAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('28', '1', ' BEYOGLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('29', '1', ' EMINЦNЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('30', '1', ' FATIH');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('31', '1', 'GЬNGЦREN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('32', '1', ' KAGITHANE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('33', '1', ' MALTEPE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('34', '1', ' SULTANBEYLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('35', '1', ' ЬSKЬDAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('37', '8', ' ADIYAMAN-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('38', '8', ' BESNI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('39', '8', ' GERGER');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('40', '8', ' ADIYAMAN GЦLBASI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('41', '8', ' KAHTA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('42', '8', ' SAMSAT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('43', '8', ' SINCIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('44', '8', ' TUT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('45', '8', ' ЗELIKHAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('47', '9', ' AFYON-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('48', '9', ' AFYON BAYAT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('49', '9', ' BASMAKЗI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('50', '9', ' BOLVADIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('51', '9', ' DAZKIRI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('52', '9', ' DINAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('53', '9', ' EMIRDAG');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('54', '9', ' EVCILER');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('55', '9', ' HOCALAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('56', '9', ' KIZILЦREN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('57', '9', ' SANDIKLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('58', '9', ' SULTANDAGI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('59', '9', ' SINCANLIS.PASA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('60', '9', ' ЗAY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('61', '9', ' ЗOBANLAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('62', '9', ' IHSANIYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('63', '9', ' ISCEHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('64', '9', ' SUHUT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('66', '12', ' AGRI-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('67', '12', ' DOGUBEYAZIT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('68', '12', ' DIYADIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('69', '12', ' ELESKIRT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('70', '12', ' HAMUR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('71', '12', ' PATNOS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('72', '12', ' TASLIЗAY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('73', '12', ' TUTAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('75', '14', ' AMASYA-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('76', '14', ' GЦYNЬCEK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('77', '14', ' GЬMЬSHACIKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('78', '14', ' HAMAMЦZЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('79', '14', ' MERZIFON');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('80', '14', ' SULUOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('81', '14', ' TASOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('83', '3', ' ANKARA-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('84', '3', ' AKYURT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('85', '3', ' ALTINDAG');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('86', '3', ' AYAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('87', '3', ' BALA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('88', '3', ' BEYPAZARI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('89', '3', ' ELMADAG');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('90', '3', ' ETIMESGUT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('91', '3', ' EVREN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('92', '3', ' ANKARA GЦLBASI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('93', '3', ' GЬDЬL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('94', '3', ' HAYMANA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('95', '3', ' KALECIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('96', '3', ' KAZAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('97', '3', ' KEЗIЦREN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('98', '3', ' KIZILCAHAMAM');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('99', '3', ' MAMAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('100', '3', ' NALLIHAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('101', '3', ' POLATLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('102', '3', ' SINCAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('103', '3', ' YENIMAHALLE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('104', '3', ' ЗAMLIDERE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('105', '3', ' ЗANKAYA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('106', '3', ' ЗUBUK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('107', '3', ' SEREFLIKOЗHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('109', '7', ' ANTALYA-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('110', '7', ' AKSEKI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('111', '7', ' ALANYA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('112', '7', ' ELMALI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('113', '7', ' FINIKE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('114', '7', ' GAZIPASA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('115', '7', ' GЬNDOGMUS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('116', '7', ' ANTALYA KALE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('117', '7', ' KAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('118', '7', ' ANTALYA KEMER');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('119', '7', ' KORKUTELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('120', '7', ' KUMLUCA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('121', '7', ' MANAVGAT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('122', '7', ' SERIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('123', '7', ' IBRADI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('125', '16', ' ARTVIN-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('126', '16', ' ARDANUЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('127', '16', ' ARHAVI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('128', '16', ' BORЗKA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('129', '16', ' HOPA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('130', '16', ' MURGUL(GЦK)');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('131', '16', ' YUSUFELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('132', '16', ' SAVSAT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('134', '17', ' AYDIN-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('135', '17', ' BOZDOGAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('136', '17', ' BUHARKENT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('137', '17', ' GERMENCIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('138', '17', ' KARACASU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('139', '17', ' KARPUZLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('140', '17', ' KOЗARLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('141', '17', ' KUYUCAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('142', '17', ' KUSADASI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('143', '17', ' KЦSK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('144', '17', ' NAZILLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('145', '17', ' SULTANHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('146', '17', ' SЦKE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('147', '17', ' DIDIM');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('148', '17', ' AYDIN YENIPAZAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('149', '17', ' ЗINE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('150', '17', ' INCIRLIOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('152', '10', ' BALIKESIR-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('153', '10', ' AYVALIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('154', '10', ' BALYA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('155', '10', ' BANDIRMA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('156', '10', ' BURHANIYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('157', '10', ' BIGADIЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('158', '10', ' DURSUNBEY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('159', '10', ' BALIKESIR EDREMI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('160', '10', ' ERDEK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('161', '10', ' GЦMEЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('162', '10', ' BALIKESIR GЦNEN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('163', '10', ' HAVRAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('164', '10', ' KEPSUT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('165', '10', ' MANYAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('166', '10', ' MARMARA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('167', '10', ' SAVASTEPE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('168', '10', ' SINDIRGI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('169', '10', ' SUSURLUK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('170', '10', ' IVRINDI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('172', '21', ' BILECIK-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('173', '21', ' BOZЬYЬK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('174', '21', ' GЦLPAZARI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('175', '21', ' OSMANELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('176', '21', ' PAZARYERI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('177', '21', ' SЦGЬT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('178', '21', ' BILECIK YENIPAZA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('179', '21', ' INHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('181', '22', ' BINGЦL-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('182', '22', ' ADAKLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('183', '22', ' GENЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('184', '22', ' KARLIOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('185', '22', ' KIGI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('186', '22', ' SOLHAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('187', '22', ' YAYLADERE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('188', '22', ' YEDISU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('190', '23', ' BITLIS-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('191', '23', ' ADILCEVAZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('192', '23', ' AHLAT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('193', '23', ' GЬROYMAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('194', '23', ' HIZAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('195', '23', ' MUTKI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('196', '23', ' TATVAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('198', '24', ' BOLU-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('199', '24', ' AKЗAKOCA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('200', '24', ' CUMAOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('201', '24', ' DЦRTDIVAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('202', '24', ' DЬZCE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('203', '24', ' GEREDE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('204', '24', ' GЦLYAKA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('205', '24', ' GЦYNЬK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('206', '24', ' KIBRISCIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('207', '24', ' MENGEN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('208', '24', ' MUDURNU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('209', '24', ' SEBEN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('210', '24', ' YENIЗAGA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('211', '24', ' YIGILCA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('212', '24', ' ЗILIMLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('213', '24', ' CUMAYERI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('215', '25', ' BURDUR-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('216', '25', ' BURDUR ALTINYAYL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('217', '25', ' AGLASUN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('218', '25', ' BUCAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('219', '25', ' GЦLHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('220', '25', ' KARAMANLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('221', '25', ' BURDUR KEMER');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('222', '25', ' TEFENNI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('223', '25', ' YESILOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('224', '25', ' ЗAVDIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('225', '25', ' ЗELTIKЗI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('227', '11', ' BURSA-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('228', '11', ' BЬYЬKORHAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('229', '11', ' GEMLIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('230', '11', ' GЬRSU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('231', '11', ' HARMANCIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('232', '11', ' KARACABEY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('233', '11', ' KELES');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('234', '11', ' KESTEL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('235', '11', ' MUDANYA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('236', '11', ' MUSTAFAKEMALPAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('237', '11', ' NILЬFER');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('238', '11', ' ORHANELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('239', '11', ' ORHANGAZI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('240', '11', ' OSMANGAZI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('241', '11', ' YENISEHIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('242', '11', ' YILDIRIM');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('243', '11', ' INEGЦL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('244', '11', ' IZNIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('246', '26', ' ЗANAKKALE-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('247', '26', ' ЗANAKKALE AYVACI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('248', '26', ' BAYRAMIЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('249', '26', ' BOZCAADA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('250', '26', ' BIGA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('251', '26', ' ECEABAT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('252', '26', ' EZINE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('253', '26', ' GELIBOLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('254', '26', ' GЦKЗEADA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('255', '26', ' LAPSEKI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('256', '26', ' ЗANAKKALE YENICE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('257', '26', ' ЗAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('259', '27', ' ЗANKIRI-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('260', '27', ' ATKARACALAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('261', '27', ' BAYRAMЦREN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('262', '27', ' ELDIVAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('263', '27', ' ILGAZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('264', '27', ' KIZILIRMAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('265', '27', ' KORGUN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('266', '27', ' KURSUNLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('267', '27', ' ORTA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('268', '27', ' YAPRAKLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('269', '27', ' ЗERKES');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('270', '27', ' SABANЦZЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('271', '27', ' ЗANKIRI OVACIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('273', '28', ' ЗORUM-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('274', '28', ' ЗORUM BAYAT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('275', '28', ' BAYAT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('276', '28', ' BOGAZKALE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('277', '28', ' DODURGA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('278', '28', ' KARGI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('279', '28', ' LAЗIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('280', '28', ' MECITЦZЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('281', '28', ' ЗORUM ORTAKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('282', '28', ' OSMANCIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('283', '28', ' OGUZLAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('284', '28', ' SUNGURLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('285', '28', ' UGURLUDAG');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('286', '28', ' ISKILIP');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('288', '29', ' DENIZLI-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('289', '29', ' ACIPAYAM');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('290', '29', ' AKKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('291', '29', ' BABADAG');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('292', '29', ' BAKLAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('293', '29', ' BEKILLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('294', '29', ' BEYAGAЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('295', '29', ' DENIZLI BOZKURT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('296', '29', ' BULDAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('297', '29', ' GЬNEY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('298', '29', ' HONAZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('299', '29', ' DENIZLI KALE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('300', '29', ' SARAYKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('301', '29', ' SERINHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('302', '29', ' TAVAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('303', '29', ' ЗAL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('304', '29', ' ЗAMELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('305', '29', ' ЗARDAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('306', '29', ' ЗIVRIL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('308', '30', ' DIYARBAKIR-MERKE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('309', '30', ' DICLE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('310', '30', ' EGIL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('311', '30', ' HAZRO');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('312', '30', ' KULP');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('313', '30', ' SILVAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('314', '30', ' ЗINAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('316', '32', ' EDIRNE-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('317', '32', ' ENEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('318', '32', ' HAVSA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('319', '32', ' KESAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('320', '32', ' LALAPASA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('321', '32', ' MERIЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('322', '32', ' SЬLEOGLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('323', '32', ' UZUNKЦPRЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('324', '32', ' IPSALA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('326', '33', ' ELAZIG-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('327', '33', ' ALACAKAYA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('328', '33', ' ARICAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('329', '33', ' AGIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('330', '33', ' BASKIL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('331', '33', ' KARAKOЗAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('332', '33', ' KOVANCILAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('333', '33', ' MADEN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('334', '33', ' PALU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('335', '33', ' SIVRICE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('336', '33', ' KEBAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('338', '34', ' ERZINCAN-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('339', '34', ' KEMAH');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('340', '34', ' KEMALIYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('341', '34', ' OTLUKBELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('342', '34', ' REFAHIYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('343', '34', ' TERCAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('344', '34', ' ЗAYIRLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('345', '34', ' ЬZЬMLЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('346', '34', ' ILIЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('348', '35', ' ERZURUM-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('349', '35', ' ASKALE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('350', '35', ' HINIS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('351', '35', ' HORASAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('352', '35', ' ILICA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('353', '35', ' KARAYAZI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('354', '35', ' KЦPRЬKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('355', '35', ' NARMAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('356', '35', ' OLUR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('357', '35', ' PAZARYOLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('358', '35', ' TORTUM');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('359', '35', ' UZUNDERE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('360', '35', ' ISPIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('362', '36', ' ESKISEHIR-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('363', '36', ' BEYLIKOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('364', '36', ' GЬNYЬZЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('365', '36', ' HAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('366', '36', ' MAHMUDIYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('367', '36', ' MIHALGAZI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('368', '36', ' MIHALIЗЗIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('369', '36', ' SARICAKAYA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('370', '36', ' SEYITGAZI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('371', '36', ' SIVRIHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('372', '36', ' ЗIFTELER');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('373', '36', ' INЦNЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('374', '36', ' ALPU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('376', '37', ' GAZIANTEP-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('377', '37', ' ARABAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('378', '37', ' ISLAHIYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('379', '37', ' KILIS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('380', '37', ' NURDAGI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('381', '37', ' OGUZELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('382', '37', ' SAHINBEY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('384', '38', ' GIRESUN-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('385', '38', ' ALUCRA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('386', '38', ' DERELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('387', '38', ' DOGANKENT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('388', '38', ' EYNESIL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('389', '38', ' GЬCE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('390', '38', ' PIRAZIZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('391', '38', ' TIREBOLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('392', '38', ' ЗAMOLUK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('393', '38', ' ЗANAKЗI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('394', '38', ' SEBINKARAHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('396', '39', ' GЬMЬSHANE-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('397', '39', ' KELKIT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('398', '39', ' KЦSE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('399', '39', ' KЬRTЬN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('400', '39', ' TORUL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('401', '39', ' SIRAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('403', '40', ' HAKKARI-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('404', '40', ' YЬKSEKOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('405', '40', ' ЗUKURCA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('406', '40', ' SEMDINLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('408', '41', ' HATAY-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('409', '41', ' ALTINЦZЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('410', '41', ' BELEN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('411', '41', ' DЦRTYOL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('412', '41', ' ERZIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('413', '41', ' HASSA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('414', '41', ' KIRIKHAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('415', '41', ' KUMLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('416', '41', ' REYHANLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('417', '41', ' SAMANDAGI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('418', '41', ' YAYLADAGI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('419', '41', ' ISKENDERUN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('421', '43', ' ISPARTA-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('422', '43', ' AKSU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('423', '43', ' ATABEY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('424', '43', ' GELENDOST');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('425', '43', ' ISPARTA GЦNEN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('426', '43', ' SENIRKENT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('427', '43', ' SЬTЗЬLER');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('428', '43', ' YALVAЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('429', '43', ' SARKIKARAAGAЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('431', '86', ' IЗEL-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('432', '86', ' ANAMUR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('433', '86', ' IЗEL AYDINCIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('434', '86', ' ERDEMLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('435', '86', ' GЬLNAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('436', '86', ' SILIFKE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('437', '86', ' TARSUS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('439', '2', ' IZMIR-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('440', '2', ' ALIAGA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('441', '2', ' BALЗOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('442', '2', ' BAYINDIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('443', '2', ' BERGAMA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('444', '2', ' BEYDAG');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('445', '2', ' BORNOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('446', '2', ' BUCA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('447', '2', ' DIKILI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('448', '2', ' FOЗA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('449', '2', ' GAZIEMIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('450', '2', ' KARABURUN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('451', '2', ' KARSIYAKA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('452', '2', ' KEMALPASA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('453', '2', ' KINIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('454', '2', ' KONAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('455', '2', ' KIRAZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('456', '2', ' MENDERES');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('457', '2', ' MENEMEN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('458', '2', ' NARLIBAHЗE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('459', '2', ' SELЗUK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('460', '2', ' TORBALI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('461', '2', ' TIRE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('462', '2', ' ЗESME');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('463', '2', ' ЦDEMIS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('465', '49', ' KARS-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('466', '49', ' ARPAЗAY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('467', '49', ' DIGOR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('468', '49', ' KAGIZMAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('469', '49', ' SELIM');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('470', '49', ' SUSUZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('472', '50', ' KASTAMONU-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('473', '50', ' ABANA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('474', '50', ' ARAЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('475', '50', ' AGILI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('476', '50', ' CIDE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('477', '50', ' DADAY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('478', '50', ' DOGANYURT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('479', '50', ' HANЦNЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('480', '50', ' KASTAMONU PINARB');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('481', '50', ' TASKЦPRЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('482', '50', ' ЗATALZEYTIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('483', '50', ' INEBOLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('485', '51', ' KAYSERI-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('486', '51', ' AKKISLA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('487', '51', ' DEVELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('488', '51', ' FELAHIYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('489', '51', ' KOCASINAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('490', '51', ' KAYSERI PINARBAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('491', '51', ' SARIOGLAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('492', '51', ' TALAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('493', '51', ' TOMARZA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('494', '51', ' YAHYALI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('495', '51', ' YESILHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('496', '51', ' ЦZVATAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('497', '51', ' INCESU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('499', '52', ' KIRKLARELI-MERKE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('500', '52', ' BABAESKI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('501', '52', ' DEMIRKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('502', '52', ' KOFЗAZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('503', '52', ' LЬLEBURGAZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('504', '52', ' PEHLIVANKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('505', '52', ' PINARHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('506', '52', ' VIZE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('508', '54', ' KIRSEHIR-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('509', '54', ' AKPINAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('510', '54', ' AKЗAKENT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('511', '54', ' BOZTEPE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('512', '54', ' KAMAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('513', '54', ' MUCUR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('514', '54', ' ЗICEKDAGI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('516', '56', ' KOCAELI-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('517', '56', ' GЦLCЬK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('518', '56', ' KARAMЬRSEL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('519', '56', ' KЦRFEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('521', '57', ' KONYA-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('522', '57', ' AHIRLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('523', '57', ' AKЦREN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('524', '57', ' AKSEHIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('525', '57', ' ALTIEKIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('526', '57', ' BEYSEHIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('527', '57', ' BOZKIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('528', '57', ' CIHANBEYLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('529', '57', ' DERBENT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('530', '57', ' DEREBUCAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('531', '57', ' DOGANHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('532', '57', ' EMIRGAZI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('533', '57', ' KONYA EREGLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('534', '57', ' GЬNEYSINIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('535', '57', ' HADIM');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('536', '57', ' HALKAPINAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('537', '57', ' HЬYЬK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('538', '57', ' ILGIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('539', '57', ' KADINHANI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('540', '57', ' KARAPINAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('541', '57', ' KARATAY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('542', '57', ' KULU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('543', '57', ' MERAM');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('544', '57', ' SARAYЦNЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('545', '57', ' SELCUKLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('546', '57', ' SEYDISEHIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('547', '57', ' TASKENT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('548', '57', ' TUZLUKЗU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('549', '57', ' YALIHЦYЬK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('550', '57', ' YUNAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('551', '57', ' ЗELTIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('552', '57', ' ЗUMRA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('554', '58', ' KЬTAHYA-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('555', '58', ' ALTINTAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('556', '58', ' ASLANAPA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('557', '58', ' DOMANIЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('558', '58', ' DUMLUPINAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('559', '58', ' EMET');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('560', '58', ' GEDIZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('561', '58', ' HISARCIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('562', '58', ' PAZARLAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('563', '58', ' SIMAV');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('564', '58', ' TAVSANLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('565', '58', ' ЗAVDARHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('566', '58', ' SAPHANE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('568', '59', ' MALATYA-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('569', '59', ' AKЗADAG');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('570', '59', ' ARAPKIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('571', '59', ' ARGUVAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('572', '59', ' BATTALGAZI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('573', '59', ' DARENDE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('574', '59', ' DOGANYOL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('575', '59', ' DOGANSEHIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('576', '59', ' HEKIMHAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('577', '59', ' MALATYA KALE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('578', '59', ' KULUNCAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('579', '59', ' PЬTЬRGE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('580', '59', ' YAZIHAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('581', '59', ' MALATYA YESILYUR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('583', '60', ' MANISA-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('584', '60', ' AHMETLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('585', '60', ' AKHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('586', '60', ' ALASEHIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('587', '60', ' DEMIRCI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('588', '60', ' GЦLMARMARA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('589', '60', ' GЦRDES');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('590', '60', ' KIRKAGAЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('591', '60', ' KULA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('592', '60', ' MANISA KЦPRЬBASI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('593', '60', ' SALIHLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('594', '60', ' SARIGЦL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('595', '60', ' SARUHANLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('596', '60', ' SELENDI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('597', '60', ' TURGUTLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('599', '46', ' KAHRAMANMARAS-ME');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('600', '46', ' AFSIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('601', '46', ' ANDIRIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('602', '46', ' EKINЦZЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('603', '46', ' ELBISTAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('604', '46', ' GЦKSUN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('605', '46', ' NURHAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('606', '46', ' PAZARCIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('607', '46', ' TЬRKOGLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('608', '46', ' ЗAGLIYANCERIT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('610', '61', ' MARDIN-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('611', '61', ' DERIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('612', '61', ' KIZILTEPE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('613', '61', ' MIDYAT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('614', '61', ' NUSAYBIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('615', '61', ' YESILLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('617', '63', ' MUGLA-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('618', '63', ' BODRUM');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('619', '63', ' DATCA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('620', '63', ' FETHIYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('621', '63', ' KЦYCEGIZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('622', '63', ' MARMARIS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('623', '63', ' MILAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('624', '63', ' ULA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('626', '64', ' MUS-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('627', '64', ' BULANIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('628', '64', ' HASKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('629', '64', ' KORKUT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('630', '64', ' SUNGU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('631', '64', ' VARTO');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('633', '65', ' NEVSEHIR-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('634', '65', ' ACIGЦL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('635', '65', ' AVANOS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('636', '65', ' DERINKUYU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('637', '65', ' HACIBEKTAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('638', '65', ' KOZAKLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('639', '65', ' ЬRGЬP');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('641', '66', ' NIGDE-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('642', '66', ' ALTUNHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('643', '66', ' BOR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('644', '66', ' ULUKISLA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('645', '66', ' ЗAMARDI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('646', '66', ' ЗIFTLIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('648', '67', ' ORDU-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('649', '67', ' AKKUS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('650', '67', ' AYBASTI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('651', '67', ' FATSA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('652', '67', ' GЦLKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('653', '67', ' GЬLYALI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('654', '67', ' GЬRGENTEPE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('655', '67', ' KABADЬZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('656', '67', ' KABATAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('657', '67', ' KORGAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('658', '67', ' KUMRU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('659', '67', ' MESUDIYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('660', '67', ' PERSEMBE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('661', '67', ' ORDU ULUBEY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('662', '67', ' ЗAMAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('663', '67', ' ЗATALPINAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('664', '67', ' ЗAYBASI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('665', '67', ' ЬNYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('666', '67', ' IKIZCE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('668', '69', ' RIZE-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('669', '69', ' ARDESEN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('670', '69', ' DEREPAZARI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('671', '69', ' FINDIKLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('672', '69', ' GЬNEYSU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('673', '69', ' HEMSIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('674', '69', ' KALKANDERE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('675', '69', ' RIZE PAZAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('676', '69', ' ЗAMLIHEMSIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('677', '69', ' IKIZDERE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('678', '69', ' IYIDERE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('680', '70', ' SAKARYA-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('681', '70', ' AKPЬRЗEK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('682', '70', ' AKYAZI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('683', '70', ' FERIZLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('684', '70', ' HENDEK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('685', '70', ' KAYNARCA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('686', '70', ' PAMUKOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('687', '70', ' SAPANCA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('688', '70', ' TARAKLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('690', '71', ' SAMSUN-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('691', '71', ' ALAЗAM');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('692', '71', ' ASARCIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('693', '71', ' SAMSUN AYVACIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('694', '71', ' BAFRA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('695', '71', ' HAVZA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('696', '71', ' KAVAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('697', '71', ' LADIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('698', '71', ' ONDOKUZMAYIS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('699', '71', ' SALIPAZARI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('700', '71', ' TEKKEKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('701', '71', ' TERME');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('702', '71', ' VEZIRKЦPRЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('703', '71', ' YAKAKENT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('704', '71', ' ЗARSAMBA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('706', '72', ' SIIRT-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('707', '72', ' AYDINLAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('708', '72', ' BAYKAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('709', '72', ' ERUH');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('710', '72', ' PERVARI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('711', '72', ' SIRVAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('713', '73', ' SINOP-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('714', '73', ' AYANCIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('715', '73', ' BOYABAT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('716', '73', ' DURAGAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('717', '73', ' DIKMEN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('718', '73', ' ERFELEK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('719', '73', ' GERZE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('720', '73', ' SARAYDЬZЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('721', '73', ' TЬRKELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('723', '74', ' SIVAS-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('724', '74', ' AKINCILAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('725', '74', ' SIVAS ALTINYAYLA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('726', '74', ' DOGANSAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('727', '74', ' DIVRIGI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('728', '74', ' GEMEREK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('729', '74', ' GЦLOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('730', '74', ' GЬRЬN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('731', '74', ' HAFIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('732', '74', ' KANGAL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('733', '74', ' KOYULHISAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('734', '74', ' SUSEHRI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('735', '74', ' ULAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('736', '74', ' YILDIZELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('737', '74', ' ZARA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('738', '74', ' IMRANLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('739', '74', ' SARKISLA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('741', '77', 'TEKIRDAG-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('742', '77', ' HAYRABOLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('743', '77', ' MALKARA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('744', '77', ' MARMARAEREGLISI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('745', '77', ' TEKIRDAG SARAY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('746', '77', ' ЗERKEZKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('747', '77', ' SARKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('749', '78', ' TOKAT-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('750', '78', ' ARTOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('751', '78', ' BASЗIFTLIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('752', '78', ' NIKSAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('753', '78', ' RESADIYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('754', '78', ' SULUSARAY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('755', '78', ' TURHAL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('756', '78', ' ZILE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('758', '79', ' TRABZON-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('759', '79', ' AKЗAABAT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('760', '79', ' ARSIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('761', '79', ' DERNEKPAZARI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('762', '79', ' DЬZKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('763', '79', ' TRABZON KЦPRЬBAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('764', '79', ' OF');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('765', '79', ' TONYA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('766', '79', ' VAKFIKEBIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('767', '79', ' ЗARSIBASI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('768', '79', ' SALPAZARI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('770', '80', ' TUNCELI-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('771', '80', ' MAZGIRT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('772', '80', ' TUNCELI OVACIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('773', '80', ' PERTEK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('775', '75', ' SANLIURFA-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('776', '75', ' AKЗAKALE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('777', '75', ' BOZOVA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('778', '75', ' BIRECIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('779', '75', ' CEYLANPINAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('780', '75', ' HALFETI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('781', '75', ' HARRAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('782', '75', ' HILVAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('783', '75', ' SURUЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('784', '75', ' SIVEREK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('785', '75', ' VIRANSEHIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('787', '81', ' USAK-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('788', '81', ' BANAZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('789', '81', ' ESME');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('790', '81', ' KARAHALLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('791', '81', ' SIVASLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('792', '81', ' USAK ULUBEY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('794', '82', ' VAN-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('795', '82', ' BAHЗESARAY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('796', '82', ' BASKALE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('797', '82', ' VAN EDREMIT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('798', '82', ' ERCIS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('799', '82', ' GEVAS');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('800', '82', ' GЬRPINAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('801', '82', ' MURADIYE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('802', '82', ' VAN SARAY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('803', '82', ' ЗALDIRAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('804', '82', ' ЗATAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('805', '82', ' ЦZALP');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('807', '84', ' YOZGAT-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('808', '84', ' YOZGAT AYDINCIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('809', '84', ' BOGAZLIYAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('810', '84', ' SARAYKENT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('811', '84', ' SARIKAYA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('812', '84', ' YENIFAKILI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('813', '84', ' YERKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('814', '84', ' ЗAYIRALAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('815', '84', ' SEFAATLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('817', '85', ' ZONGULDAK-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('818', '85', ' ALAPLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('819', '85', ' DEVREK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('820', '85', ' ZONGULDAK EREGLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('821', '85', ' KARABЬK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('823', '13', ' AKSARAY-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('824', '13', ' ESKIL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('825', '13', ' GЬLAGAЗ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('826', '13', ' AKSARAY ORTAKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('827', '13', ' SARIYAHSI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('829', '13', ' BAYBURT-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('830', '13', ' AYDINTEPE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('831', '13', ' DEMIRЦZЬ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('833', '48', ' KARAMAN-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('834', '48', ' AYRANCI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('835', '48', ' BASYAYLA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('836', '48', ' ERMENEK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('837', '48', ' SARIVELILER');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('839', '53', ' KIRIKKALE-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('840', '53', ' BALISEYH');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('841', '53', ' KARAKEЗILI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('842', '53', ' KESKIN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('843', '53', ' SULAKYURT');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('844', '53', ' YAHSIHAN');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('846', '19', ' BATMAN-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('847', '19', ' BESIRI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('848', '19', ' HASANKEYF');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('849', '19', ' KOZLUK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('851', '76', ' SIRNAK-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('852', '76', ' CIZRE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('853', '76', ' GЬCLЬKONAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('854', '76', ' ULUDERE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('855', '76', ' IDIL');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('857', '18', ' BARTIN-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('858', '18', ' AMASRA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('859', '18', ' KURUCASILE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('861', '15', ' ARDAHAN-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('862', '15', ' GЦLE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('863', '15', ' HANAK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('864', '15', ' ЗILDIR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('866', '42', ' IGDIR-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('867', '42', ' ARALIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('868', '42', ' KARAKOYUNLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('869', '42', ' TUZLUCA');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('871', '47', ' KARABЬK-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('872', '47', ' KARABЬK OVACIK');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('873', '47', ' KARABЬK YENICE');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('874', '47', ' SAFRANBOLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('875', '47', ' ESKIPAZAR');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('877', '55', ' KILIS-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('878', '55', ' MUSABEYLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('879', '55', ' ELBEYLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('880', '55', ' POLATELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('882', '68', ' KILIS-MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('883', '68', ' MUSABEYLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('884', '68', ' ELBEYLI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('885', '68', ' POLATELI');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('887', '83', ' YALOVA- MERKEZ');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('888', '83', ' ARMUTLU');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('889', '1', 'KAVAKLIKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('890', '1', 'ARNAVUTKЦY');
INSERT INTO `ilce`(`Id`, `Sehir_id`, `adi`) VALUES ('891', '79', 'Sьrmene');
DROP TABLE IF EXISTS `iletisim`;
CREATE TABLE `iletisim` (
`Id` int(11) NOT NULL auto_increment,
`E_mail` varchar(255) NOT NULL default '',
`Adi` varchar(100) NOT NULL default '',
`Emlak_id` int(11) NOT NULL default '0',
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `insaat`;
CREATE TABLE `insaat` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`insaat_metin` text NOT NULL,
`ilgili_ilan` varchar(255) NOT NULL default '',
`devam` char(1) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;
INSERT INTO `insaat`(`id`, `name`, `insaat_metin`, `ilgili_ilan`, `devam`) VALUES ('32', 'BAHЗELİ EVLER/ SOĞANLI', '', '', '0');
INSERT INTO `insaat`(`id`, `name`, `insaat_metin`, `ilgili_ilan`, `devam`) VALUES ('33', 'GЬNGЦREN/AYVACIK SOKAK', '', '', '0');
INSERT INTO `insaat`(`id`, `name`, `insaat_metin`, `ilgili_ilan`, `devam`) VALUES ('34', 'BAHЗELİEVLER/CAMLIKAHVE', '', '', '');
INSERT INTO `insaat`(`id`, `name`, `insaat_metin`, `ilgili_ilan`, `devam`) VALUES ('31', 'GЬNGЦREN/ HUZUR SOKAK', '', '', '0');
INSERT INTO `insaat`(`id`, `name`, `insaat_metin`, `ilgili_ilan`, `devam`) VALUES ('30', 'GЬNGЦREN/ ЦZCAN CANİK SOKAK', '', '', '0');
INSERT INTO `insaat`(`id`, `name`, `insaat_metin`, `ilgili_ilan`, `devam`) VALUES ('35', 'BAŞAK SOKAK', '', '', '0');
DROP TABLE IF EXISTS `insaat_resim`;
CREATE TABLE `insaat_resim` (
`id` int(11) NOT NULL auto_increment,
`insaat_id` int(11) default NULL,
`name` varchar(255) default NULL,
`buyuk_resim` longblob,
`kucuk_resim` longblob,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `kisa_metinler`;
CREATE TABLE `kisa_metinler` (
`Id` int(11) NOT NULL auto_increment,
`Sayfa` varchar(100) NOT NULL default '',
`kisa_metin` mediumtext NOT NULL,
`tam_metin` text NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
INSERT INTO `kisa_metinler`(`Id`, `Sayfa`, `kisa_metin`, `tam_metin`) VALUES ('1', 'KURUMSAL', 'Uluslar arasэ mьюterilerine Gayrimenkul Danэюmanlэрэ veren юirketimiz Ganimet Emlak, alanэnda tecrьbeli, profesyonel, gьзlь kadrosu ve ileri teknolojik donanэmlarla 20 Yэllэk bir geзmiюe sahiptir. <br><br>Mьюterilerinin tavsiyesiyle geliюen ve bьyьyen bir юirkettir. Tek reklamэmэz sadece sayэn mьюterilerimizin iyi referansэdэr.', 'KURUMSAL BД°LGД°');
INSERT INTO `kisa_metinler`(`Id`, `Sayfa`, `kisa_metin`, `tam_metin`) VALUES ('2', 'EMLAK_KAYIT_EMAIL', '', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
DROP TABLE IF EXISTS `sehir`;
CREATE TABLE `sehir` (
`Id` int(11) NOT NULL auto_increment,
`sehir` varchar(100) NOT NULL default '',
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=88 DEFAULT CHARSET=latin1;
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('2', 'Izmir');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('3', 'Ankara');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('1', 'Istanbul');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('4', 'Adana');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('7', 'Antalya');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('8', 'Adiyaman');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('9', 'Afyon');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('10', 'Balikesir');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('11', 'Bursa');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('12', 'Agri');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('13', 'Aksaray');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('14', 'Amasya');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('15', 'Ardahan');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('16', 'Artvin');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('17', 'Aydin');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('18', 'Bartin');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('19', 'Batman');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('20', 'Bayburt');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('21', 'Bilecik');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('22', 'Bingцl');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('23', 'Bitlis');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('24', 'Bolu');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('25', 'Burdur');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('26', 'Зanakkale');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('27', 'Зankiri');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('28', 'Зorum');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('29', 'Denizli');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('30', 'Diyarbakir');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('31', 'Dьzce');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('32', 'Edirne');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('33', 'Elazig');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('34', 'Erzincan');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('35', 'Erzurum');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('36', 'Eskisehir');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('37', 'Gaziantep');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('38', 'Giresun');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('39', 'Gьmьshane');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('40', 'Hakkari');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('41', 'Hatay');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('42', 'Igdir');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('43', 'Isparta');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('46', 'Kahramanmaras');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('47', 'Karabьk');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('48', 'Karaman');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('49', 'Kars');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('50', 'Kastamonu');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('51', 'Kayseri');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('52', 'Kirklareli');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('53', 'Kirikkale');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('54', 'Kirsehir');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('55', 'Kilis');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('56', 'Kocaeli');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('57', 'Konya');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('58', 'Kьtahya');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('59', 'Malatya');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('60', 'Manisa');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('61', 'Mardin');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('62', 'Mersin');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('63', 'Mugla');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('64', 'Mus');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('65', 'Nevsehir');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('66', 'Nigde');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('67', 'Ordu');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('68', 'Osmaniye');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('69', 'Rize');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('70', 'Sakarya');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('71', 'Samsun');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('72', 'Siirt');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('73', 'Sinop');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('74', 'Sivas');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('75', 'Sanli urfa');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('76', 'Sirnak');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('77', 'Tekirdag');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('78', 'Tokat');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('79', 'Trabzon');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('80', 'Tunceli');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('81', 'Usak');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('82', 'Van');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('83', 'Yalova');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('84', 'Yozgat');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('85', 'Zonguldak');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('86', 'Iзel');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('87', 'TEKЭRDAР');
DROP TABLE IF EXISTS `vitrin`;
CREATE TABLE `vitrin` (
`id` int(11) NOT NULL auto_increment,
`emlak_no` int(11) NOT NULL default '0',
`tip` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
INSERT INTO `vitrin`(`id`, `emlak_no`, `tip`) VALUES ('1', '52', 'SATLIK');
INSERT INTO `vitrin`(`id`, `emlak_no`, `tip`) VALUES ('2', '29', 'KIRALIK');
INSERT INTO `vitrin`(`id`, `emlak_no`, `tip`) VALUES ('3', '15', 'ARAZI');
#---------------------------------------------------------------------------------
[/code]
Səhv mətni
[code]Hata
SQL sorgusu:
INSERT INTO `kisa_metinler`(`Id`, `Sayfa`, `kisa_metin`, `tam_metin`) VALUES ('2', 'EMLAK_KAYIT_EMAIL', '', '<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"> DROP TABLE IF EXISTS `sehir`; CREATE TABLE `sehir` ( `Id` int(11) NOT NULL auto_increment, `sehir` varchar(100) NOT NULL default '', PRIMARY KEY (`Id`) ) ENGINE=MyISAM AUTO_INCREMENT=88 DEFAULT CHARSET=latin1; INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('2', 'Izmir'); INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('3', 'Ankara'); INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('1', 'Istanbul'); INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('4', 'Adana'); INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('7', 'Antalya'); INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('8', 'Adiyaman'); INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('9', 'Afyon'); INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('10', 'Balikesir'); INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('11'[...]
MySQL çıktısı: Belgeler
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2', 'Izmir');
INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('3', 'Ankara');
INSER' at line 1 [/code]