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

AqUaRiS · 15 Şub 2009

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

AqUaRiS · 15 Şub 2009

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

Silverday · 16 Şub 2009

kodların yanı sıra gelen mysql çıktısı hatasını da yazmalısın.
ayrıca hemen yardım gelmedi diye de kuruntu yapmamanı tavsiye ederim (!)
locked

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

AqUaRiS

New member

AqUaRiS

New member

Silverday

Altın Üye