arkadaslar elımde script var yanlız sql sorgusunda hata verıo bı bakarmısınız

Durum
Üzgünüz bu konu cevaplar için kapatılmıştır...
AqUaRiS

AqUaRiS

New member
Katılım
13 Eki 2006
Mesajlar
88
Reaction score
0
Puanları
0
Konum
кıγamєt qєLSєdє кσpSaк
Kod: 
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Ç');
arkadaslar script guzel yanlız sql sorgusu hata verıo anlayan arkadaslardan rıcam bı bakabılırlerse super oluır




link : http://rapidshare.com/files/198391937/sql.sql.html
 
devamı


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');
#---------------------------------------------------------------------------------

yardımcı olmadıgınız ıcın tesekkurler sorunu cozdum
 
Durum
Üzgünüz bu konu cevaplar için kapatılmıştır...
Geri
Üst