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