SQL səhvi

Aşağıdakı SQL sənədi myadminə yüklədiyim zaman sənəddə səhv olduğunu göstərir. Başı çıxan varsa kömək etsin.

SQL

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

Səhv mətni

1Hata
2 
3SQL sorgusu:
4 
5INSERT 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'[...]
6 
7MySQL çıktısı: Belgeler
8#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2', 'Izmir');
9INSERT INTO `sehir`(`Id`, `sehir`) VALUES ('3', 'Ankara');
10INSER' at line 1

Yadda saxlama
Kateqoriya: Sual, Web skriptlər, kod həlləri . , , . Qısa keçid.

Verilmiş cavablar və yazılan şərhlər (5 cavab var)

(22:06, 06/11/2011 ) #4371

989-990-cı sətrə baxın, dırnaq açılıb, sonra bağlanmayıb.

Cavablamaq üçün sağ sütundan hesaba daxil olmaq lazımdır

    (22:42, 06/11/2011 ) #4373

    gözə yarı baxdım diqqət yetirmədin,şərhinizdən sonra baxdım,razıyam sizinlə.adice dırnaq işarəsinə görə böyük problemlər yaşanır…

    Cavablamaq üçün sağ sütundan hesaba daxil olmaq lazımdır

(22:08, 06/11/2011 ) #4372

Bu hər hansı web saytda baş verir ?

Cavablamaq üçün sağ sütundan hesaba daxil olmaq lazımdır

(16:10, 07/11/2011 ) #4388

Təşəkkürlər!

Cavablamaq üçün sağ sütundan hesaba daxil olmaq lazımdır

(22:35, 13/11/2011 ) #4442

phpmyadmin səhvi axı göstərir

Cavablamaq üçün sağ sütundan hesaba daxil olmaq lazımdır

Bu suala aid öz sualım var:
Sual verin
Bu suala cavab vermək istəyirəm:
Cavab verin

Cavab verin


Cavab yazmaq üçün lütfən sağ sütundan və ya buradan hesaba daxil olun.

Üzvlər üçün giriş

Qeydiyyat
Login with Facebook

Elan qutusu

Son cavablar və şərhlər

Software Developer cavab verdi - ilkaddimlar.com-a nə oldu? (6 gün əvvəl)

E. Hacı cavab verdi - Adsense ya görə VÖEN gəlir vergisi 20% istəyirlər (16 gün əvvəl)

Triste cavab verdi - Adsense ya görə VÖEN gəlir vergisi 20% istəyirlər (17 gün əvvəl)

E. Hacı cavab verdi - Adsense ya görə VÖEN gəlir vergisi 20% istəyirlər (17 gün əvvəl)

Triste cavab verdi - Adsense ya görə VÖEN gəlir vergisi 20% istəyirlər (18 gün əvvəl)

E. Hacı cavab verdi - Telefon almışam kamerasında ləkə var qaytarmaq istəyirəm, mağaza qaytarmır (18 gün əvvəl)

Software Developer cavab verdi - Rus dili yatırımı (18 gün əvvəl)

Cənab cavab verdi - Rus dili yatırımı (18 gün əvvəl)

Software Developer cavab verdi - Rus dili yatırımı (19 gün əvvəl)

Cənab cavab verdi - Rus dili yatırımı (19 gün əvvəl)

Software Developer cavab verdi - Rus dili yatırımı (19 gün əvvəl)

Azad cavab verdi - Windows 11 FPS drop (32 gün əvvəl)

AGAPROGRAMM cavab verdi - Kompyuterimin çox gec yanmasının səbəbləri nədir ? Necə düzəldərəm ? (35 gün əvvəl)

Ayaz2550 cavab verdi - 1ci qrupda informatika üzre imtahan vermek (37 gün əvvəl)

Ayaz2550 cavab verdi - Windows 11 FPS drop (37 gün əvvəl)

Software Developer - 615 xal

E. Hacı - 608 xal

Onar Alili - 526 xal

Dilsuz - 448 xal

Cabbarov Sübhan - 434 xal

Maqa - 346 xal

Ruslan Butdayev - 328 xal

Namiq Bəndəli - 297 xal

U.Tarlan - 244 xal

Meherremoff - 234 xal

Sistemə daxil olmuş 23307 sualdan 92%-dən çoxu cavablandırılmışdır.

Proyekt haqqında

E-Haci.net istehsalı. © 2010-2025