İl ve İlçeleri (SQL Script halinde)

Yazdığınız makaleleri ve üyelerimizin işine yarayacağını düşündüğünüz kodlarınızı gönderebilirsiniz. Bu foruma soru sormayın!
Kullanıcı avatarı
freeman35
Admin
Mesajlar: 2356
Kayıt: 12 Haz 2003 04:05
Konum: merkez camii yanı

İl ve İlçeleri (SQL Script halinde)

Mesaj gönderen freeman35 »

Kod: Tümünü seç

/* Tables definitions */

CREATE TABLE IL (
    SELF DM_INTEGER NOT NULL,
    ADI DM_STR25 NOT NULL);

CREATE TABLE ILCE (
    SELF DM_INTEGER NOT NULL,
    MST_ID DM_INTEGER NOT NULL,
    ADI DM_STR25 NOT NULL);

INSERT INTO IL (SELF, ADI) VALUES (1, 'Adana');
INSERT INTO IL (SELF, ADI) VALUES (2, 'Adiyaman');
INSERT INTO IL (SELF, ADI) VALUES (3, 'Afyon');
INSERT INTO IL (SELF, ADI) VALUES (4, 'Ağri');
INSERT INTO IL (SELF, ADI) VALUES (5, 'Amasya');
INSERT INTO IL (SELF, ADI) VALUES (6, 'Ankara');
INSERT INTO IL (SELF, ADI) VALUES (7, 'Antalya');
INSERT INTO IL (SELF, ADI) VALUES (8, 'Artvin');
INSERT INTO IL (SELF, ADI) VALUES (9, 'Aydin');
INSERT INTO IL (SELF, ADI) VALUES (10, 'Balikesir');
INSERT INTO IL (SELF, ADI) VALUES (11, 'Bilecik');
INSERT INTO IL (SELF, ADI) VALUES (12, 'Bingöl');
INSERT INTO IL (SELF, ADI) VALUES (13, 'Bitlis');
INSERT INTO IL (SELF, ADI) VALUES (14, 'Bolu');
INSERT INTO IL (SELF, ADI) VALUES (15, 'Burdur');
INSERT INTO IL (SELF, ADI) VALUES (16, 'Bursa');
INSERT INTO IL (SELF, ADI) VALUES (17, 'Çanakkale');
INSERT INTO IL (SELF, ADI) VALUES (18, 'Çankiri');
INSERT INTO IL (SELF, ADI) VALUES (19, 'Çorum');
INSERT INTO IL (SELF, ADI) VALUES (20, 'Denizlİ');
INSERT INTO IL (SELF, ADI) VALUES (21, 'Diyarbakir');
INSERT INTO IL (SELF, ADI) VALUES (22, 'Edirne');
INSERT INTO IL (SELF, ADI) VALUES (23, 'Elaziğ');
INSERT INTO IL (SELF, ADI) VALUES (24, 'Erzincan');
INSERT INTO IL (SELF, ADI) VALUES (25, 'Erzurum');
INSERT INTO IL (SELF, ADI) VALUES (26, 'Eskişehir');
INSERT INTO IL (SELF, ADI) VALUES (27, 'Gaziantep');
INSERT INTO IL (SELF, ADI) VALUES (28, 'Giresun');
INSERT INTO IL (SELF, ADI) VALUES (29, 'Gümüşhane');
INSERT INTO IL (SELF, ADI) VALUES (30, 'Hakkari');
INSERT INTO IL (SELF, ADI) VALUES (31, 'Hatay');
INSERT INTO IL (SELF, ADI) VALUES (32, 'Isparta');
INSERT INTO IL (SELF, ADI) VALUES (33, 'İçel');
INSERT INTO IL (SELF, ADI) VALUES (34, 'İstanbul');
INSERT INTO IL (SELF, ADI) VALUES (35, 'İzmir');
INSERT INTO IL (SELF, ADI) VALUES (36, 'Kars');
INSERT INTO IL (SELF, ADI) VALUES (37, 'Kastamonu');
INSERT INTO IL (SELF, ADI) VALUES (38, 'Kayserİ');
INSERT INTO IL (SELF, ADI) VALUES (39, 'Kirklareli');
INSERT INTO IL (SELF, ADI) VALUES (40, 'Kirşehir');
INSERT INTO IL (SELF, ADI) VALUES (41, 'Kocaeli');
INSERT INTO IL (SELF, ADI) VALUES (42, 'Konya');
INSERT INTO IL (SELF, ADI) VALUES (43, 'Kütahya');
INSERT INTO IL (SELF, ADI) VALUES (44, 'Malatya');
INSERT INTO IL (SELF, ADI) VALUES (45, 'Manisa');
INSERT INTO IL (SELF, ADI) VALUES (46, 'Kahramanmaraş');
INSERT INTO IL (SELF, ADI) VALUES (47, 'Mardin');
INSERT INTO IL (SELF, ADI) VALUES (48, 'Muğla');
INSERT INTO IL (SELF, ADI) VALUES (49, 'Muş');
INSERT INTO IL (SELF, ADI) VALUES (50, 'Nevşehir');
INSERT INTO IL (SELF, ADI) VALUES (51, 'Niğde');
INSERT INTO IL (SELF, ADI) VALUES (52, 'Ordu');
INSERT INTO IL (SELF, ADI) VALUES (53, 'Rize');
INSERT INTO IL (SELF, ADI) VALUES (54, 'Sakarya');
INSERT INTO IL (SELF, ADI) VALUES (55, 'Samsun');
INSERT INTO IL (SELF, ADI) VALUES (56, 'Siirt');
INSERT INTO IL (SELF, ADI) VALUES (57, 'Sinop');
INSERT INTO IL (SELF, ADI) VALUES (58, 'Sivas');
INSERT INTO IL (SELF, ADI) VALUES (59, 'Tekirdağ');
INSERT INTO IL (SELF, ADI) VALUES (60, 'Tokat');
INSERT INTO IL (SELF, ADI) VALUES (61, 'Trabzon');
INSERT INTO IL (SELF, ADI) VALUES (62, 'Tuncelİ');
INSERT INTO IL (SELF, ADI) VALUES (63, 'Şanliurfa');
INSERT INTO IL (SELF, ADI) VALUES (64, 'Uşak');
INSERT INTO IL (SELF, ADI) VALUES (65, 'Van');
INSERT INTO IL (SELF, ADI) VALUES (66, 'Yozgat');
INSERT INTO IL (SELF, ADI) VALUES (67, 'Zonguldak');
INSERT INTO IL (SELF, ADI) VALUES (68, 'Aksaray');
INSERT INTO IL (SELF, ADI) VALUES (69, 'Bayburt');
INSERT INTO IL (SELF, ADI) VALUES (70, 'Karaman');
INSERT INTO IL (SELF, ADI) VALUES (71, 'Kirikkale');
INSERT INTO IL (SELF, ADI) VALUES (72, 'Batman');
INSERT INTO IL (SELF, ADI) VALUES (73, 'Şirnak');
INSERT INTO IL (SELF, ADI) VALUES (74, 'Bartin');

INSERT INTO IL (SELF, ADI) VALUES (75, 'Ardahan');
INSERT INTO IL (SELF, ADI) VALUES (76, 'Iğdir');
INSERT INTO IL (SELF, ADI) VALUES (77, 'Yalova');
INSERT INTO IL (SELF, ADI) VALUES (78, 'Karabük');
INSERT INTO IL (SELF, ADI) VALUES (79, 'Kilis');
INSERT INTO IL (SELF, ADI) VALUES (80, 'Osmaniye');
INSERT INTO IL (SELF, ADI) VALUES (81, 'Düzce');

COMMIT WORK;

INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (1, 1, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (2, 1, 'Aladag');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (3, 1, 'Ceyhan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (4, 1, 'Feke');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (5, 1, 'Imamoglu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (6, 1, 'Karaisali');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (7, 1, 'Karatas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (8, 1, 'Kozan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (9, 1, 'Pozanti');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (10, 1, 'Saimbeyli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (11, 1, 'Seyhan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (12, 1, 'Tufanbeyli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (13, 1, 'Yumurtalik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (14, 1, 'Yüregir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (15, 2, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (16, 2, 'Besni');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (17, 2, 'Çelikhan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (18, 2, 'Gerger');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (19, 2, 'Gölbasi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (20, 2, 'Kahta');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (21, 2, 'Samsat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (22, 2, 'Sincik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (23, 2, 'Tut');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (24, 3, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (25, 3, 'Basmakçi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (26, 3, 'Bayat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (27, 3, 'Bolvadin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (28, 3, 'Çobanlar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (29, 3, 'Çay');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (30, 3, 'Dazkiri');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (31, 3, 'Dinar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (32, 3, 'Emirdag');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (33, 3, 'Evciler');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (34, 3, 'Hocalar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (35, 3, 'Ihsaniye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (36, 3, 'Iscehisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (37, 3, 'Kizilören');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (38, 3, 'Sandikli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (39, 3, 'Sincanli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (40, 3, 'Sultandagi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (41, 3, 'Suhut');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (42, 4, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (43, 4, 'Diyadin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (44, 4, 'Dogubeyazit');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (45, 4, 'Eleskirt');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (46, 4, 'Hamur');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (47, 4, 'Patnos');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (48, 4, 'Tasliçay');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (49, 4, 'Tutak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (50, 5, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (51, 5, 'Göynücek');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (52, 5, 'Gümüshacikö');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (53, 5, 'Hamamözü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (54, 5, 'Merzifon');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (55, 5, 'Suluova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (56, 5, 'Tasova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (57, 6, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (58, 6, 'Akyurt');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (59, 6, 'Altindag');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (60, 6, 'Ayas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (61, 6, 'Bala');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (62, 6, 'Beypazari');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (63, 6, 'Çamlidere');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (64, 6, 'Çankaya');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (65, 6, 'Çubuk');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (66, 6, 'Elmadag');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (67, 6, 'Etimesgut');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (68, 6, 'Evren');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (69, 6, 'Gölbasi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (70, 6, 'Güdül');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (71, 6, 'Haymana');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (72, 6, 'Kalecik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (73, 6, 'Kazan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (74, 6, 'Keçiören');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (75, 6, 'Kizilcahama');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (76, 6, 'Mamak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (77, 6, 'Nallihan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (78, 6, 'Polatli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (79, 6, 'Sincan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (80, 6, 'Sereflikoçh');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (81, 6, 'Yenimahalle');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (82, 7, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (83, 7, 'Akseki');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (84, 7, 'Alanya');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (85, 7, 'Demre');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (86, 7, 'Elmali');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (87, 7, 'Finike');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (88, 7, 'Gazipasa');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (89, 7, 'Gündogmus');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (90, 7, 'Ibradi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (91, 7, 'Kale');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (92, 7, 'Kas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (93, 7, 'Kemer');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (94, 7, 'Korkuteli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (95, 7, 'Kumluca');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (96, 7, 'Manavgat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (97, 7, 'Serik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (98, 8, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (99, 8, 'Ardanuç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (100, 8, 'Arhavi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (101, 8, 'Borçka');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (102, 8, 'Hopa');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (103, 8, 'Murgul');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (104, 8, 'Savsat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (105, 8, 'Yusufeli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (106, 9, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (107, 9, 'Bozdogan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (108, 9, 'Buharkent');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (109, 9, 'Çine');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (110, 9, 'Germencik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (111, 9, 'Incirliova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (112, 9, 'Karacasu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (113, 9, 'Karpuzlu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (114, 9, 'Koçarli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (115, 9, 'Kösk');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (116, 9, 'Kusadasi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (117, 9, 'Kuyucak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (118, 9, 'Nazilli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (119, 9, 'Söke');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (120, 9, 'Sultanhisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (121, 9, 'Yenihisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (122, 9, 'Yenipazar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (123, 10, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (124, 10, 'Ayvalik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (125, 10, 'Akçay');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (126, 10, 'Balya');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (127, 10, 'Bandirma');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (128, 10, 'Bigadiç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (129, 10, 'Burhaniye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (130, 10, 'Dursunbey');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (131, 10, 'Edremit');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (132, 10, 'Erdek');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (133, 10, 'Gönen');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (134, 10, 'Gömeç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (135, 10, 'Havran');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (136, 10, 'Ivrindi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (137, 10, 'Kepsut');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (138, 10, 'Manyas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (139, 10, 'Marmara');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (140, 10, 'Savastepe');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (141, 10, 'Sindirgi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (142, 10, 'Susurluk');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (143, 11, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (144, 11, 'Bozöyük');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (145, 11, 'Gölpazari');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (146, 11, 'Inhisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (147, 11, 'Osmaneli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (148, 11, 'Pazaryeri');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (149, 11, 'Sögüt');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (150, 11, 'Yenipazar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (151, 12, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (152, 12, 'Adakli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (153, 12, 'Genç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (154, 12, 'Karliova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (155, 12, 'Kigi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (156, 12, 'Solhan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (157, 12, 'Yayladere');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (158, 12, 'Yedisu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (159, 13, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (160, 13, 'Adilcevaz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (161, 13, 'Ahlat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (162, 13, 'Güroymak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (163, 13, 'Hizan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (164, 13, 'Mutki');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (165, 13, 'Tatvan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (166, 14, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (167, 14, 'Dörtdivan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (168, 14, 'Gerede');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (169, 14, 'Göynük');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (170, 14, 'Kibriscik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (171, 14, 'Mengen');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (172, 14, 'Mudurnu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (173, 14, 'Seben');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (174, 14, 'Yeniçaga');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (175, 15, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (176, 15, 'Altinyayla');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (177, 15, 'Aglasun');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (178, 15, 'Bucak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (179, 15, 'Çavdir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (180, 15, 'Çeltikçi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (181, 15, 'Gölhisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (182, 15, 'Karamanli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (183, 15, 'Kemer');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (184, 15, 'Tefenni');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (185, 15, 'Yesilova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (186, 16, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (187, 16, 'Büyükorhan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (188, 16, 'Gemlik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (189, 16, 'Gürsu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (190, 16, 'Harmancik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (191, 16, 'Inegöl');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (192, 16, 'Iznik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (193, 16, 'Karacabey');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (194, 16, 'Keles');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (195, 16, 'Kestel');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (196, 16, 'Mudanya');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (197, 16, 'Mustafakema');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (198, 16, 'Nilüfer');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (199, 16, 'Orhaneli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (200, 16, 'Orhangazi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (201, 16, 'Osmangazi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (202, 16, 'Yenisehir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (203, 16, 'Yildirim');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (204, 17, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (205, 17, 'Ayvacik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (206, 17, 'Bayramiç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (207, 17, 'Bozcaada');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (208, 17, 'Biga');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (209, 17, 'Çan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (210, 17, 'Eceabat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (211, 17, 'Ezine');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (212, 17, 'Gelibolu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (213, 17, 'Gökçeada');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (214, 17, 'Lapseki');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (215, 17, 'Yenice');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (216, 18, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (217, 18, 'Atkaracalar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (218, 18, 'Bayramören');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (219, 18, 'Çerkes');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (220, 18, 'Eldivan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (221, 18, 'Ilgaz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (222, 18, 'Kizilirmak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (223, 18, 'Korgun');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (224, 18, 'Kursunlu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (225, 18, 'Orta');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (226, 18, 'Ovacik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (227, 18, 'Sabanözü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (228, 18, 'Yaprakli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (229, 19, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (230, 19, 'Alaca');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (231, 19, 'Bayat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (232, 19, 'Bogazkale');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (233, 19, 'Dodurga');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (234, 19, 'Iskilip');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (235, 19, 'Kargi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (236, 19, 'Laçin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (237, 19, 'Mecitözü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (238, 19, 'Oguzlar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (239, 19, 'Ortaköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (240, 19, 'Osmancik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (241, 19, 'Sungurlu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (242, 19, 'Ugurludag');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (243, 20, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (244, 20, 'Acipayam');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (245, 20, 'Akköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (246, 20, 'Babadag');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (247, 20, 'Baklan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (248, 20, 'Bekilli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (249, 20, 'Beyagaç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (250, 20, 'Buldan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (251, 20, 'Bozkurt');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (252, 20, 'Çal');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (253, 20, 'Çameli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (254, 20, 'Çardak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (255, 20, 'Çivril');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (256, 20, 'Güney');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (257, 20, 'Honaz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (258, 20, 'Kale');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (259, 20, 'Sarayköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (260, 20, 'Serinhisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (261, 20, 'Tavas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (262, 21, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (263, 21, 'Bismil');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (264, 21, 'Çermik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (265, 21, 'Çinar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (266, 21, 'Çüngüs');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (267, 21, 'Dicle');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (268, 21, 'Egil');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (269, 21, 'Ergani');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (270, 21, 'Hani');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (271, 21, 'Hazro');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (272, 21, 'Kocaköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (273, 21, 'Kulp');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (274, 21, 'Lice');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (275, 21, 'Silvan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (276, 22, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (277, 22, 'Enez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (278, 22, 'Havsa');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (279, 22, 'Ipsala');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (280, 22, 'Kesan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (281, 22, 'Lalapasa');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (282, 22, 'Meriç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (283, 22, 'Süloglu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (284, 22, 'Uzunköprü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (285, 23, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (286, 23, 'Agin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (287, 23, 'Alacakaya');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (288, 23, 'Aricak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (289, 23, 'Baskil');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (290, 23, 'Karakoçan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (291, 23, 'Keban');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (292, 23, 'Kovancilar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (293, 23, 'Maden');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (294, 23, 'Palu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (295, 23, 'Sivrice');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (296, 24, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (297, 24, 'Çayirli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (298, 24, 'Iliç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (299, 24, 'Kemah');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (300, 24, 'Kemaliye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (301, 24, 'Otlukbeli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (302, 24, 'Refahiye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (303, 24, 'Tercan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (304, 24, 'Üzümlü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (305, 25, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (306, 25, 'Askale');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (307, 25, 'Çat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (308, 25, 'Hinis');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (309, 25, 'Horasan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (310, 25, 'Ilica');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (311, 25, 'Ispir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (312, 25, 'Karaçoban');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (313, 25, 'Karayazi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (314, 25, 'Köprüköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (315, 25, 'Narman');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (316, 25, 'Oltu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (317, 25, 'Olur');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (318, 25, 'Pasinler');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (319, 25, 'Pazaryolu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (320, 25, 'Senkaya');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (321, 25, 'Tekman');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (322, 25, 'Tortum');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (323, 25, 'Uzundere');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (324, 26, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (325, 26, 'Alpu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (326, 26, 'Beylikova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (327, 26, 'Çifteler');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (328, 26, 'Günyüzü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (329, 26, 'Han');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (330, 26, 'Inönü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (331, 26, 'Mahmudiye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (332, 26, 'Mihalgazi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (333, 26, 'Mihaliççik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (334, 26, 'Saricakaya');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (335, 26, 'Seyitgazi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (336, 26, 'Sivrihisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (337, 27, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (338, 27, 'Araban');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (339, 27, 'Islahiye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (340, 27, 'Kilis');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (341, 27, 'Kargamis');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (342, 27, 'Nizip');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (343, 27, 'Nurdagi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (344, 27, 'Oguzeli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (345, 27, 'Sahinbey');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (346, 27, 'Sehitkamil');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (347, 27, 'Yavuzeli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (348, 28, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (349, 28, 'Alucra');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (350, 28, 'Bulancak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (351, 28, 'Çamoluk');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (352, 28, 'Çanakçi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (353, 28, 'Dereli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (354, 28, 'Dogankent');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (355, 28, 'Espiye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (356, 28, 'Eynesil');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (357, 28, 'Görele');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (358, 28, 'Güce');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (359, 28, 'Kesap');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (360, 28, 'Piraziz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (361, 28, 'Sebinkarahisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (362, 28, 'Tirebolu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (363, 28, 'Yaglidere');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (364, 29, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (365, 29, 'Kelkit');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (366, 29, 'Köse');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (367, 29, 'Kürtün');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (368, 29, 'Siran');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (369, 29, 'Torul');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (370, 30, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (371, 30, 'Çukurca');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (372, 30, 'Semdinli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (373, 30, 'Yüksekova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (374, 31, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (375, 31, 'Altinözü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (376, 31, 'Belen');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (377, 31, 'Dörtyol');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (378, 31, 'Erzin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (379, 31, 'Hassa');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (380, 31, 'Iskenderun');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (381, 31, 'Kirikhan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (382, 31, 'Kumlu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (383, 31, 'Reyhanli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (384, 31, 'Samandagi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (385, 31, 'Yayladagi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (386, 32, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (387, 32, 'Aksu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (388, 32, 'Atabey');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (389, 32, 'Egirdir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (390, 32, 'Gelendost');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (391, 32, 'Gönen');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (392, 32, 'Keçiborlu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (393, 32, 'Senirkent');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (394, 32, 'Sütçüler');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (395, 32, 'Sarkikaraag');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (396, 32, 'Uluborlu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (397, 32, 'Yenisarbade');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (398, 32, 'Yalvaç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (399, 33, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (400, 33, 'Anamur');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (401, 33, 'Aydincik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (402, 33, 'Bozyazi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (403, 33, 'Çamliyayla');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (404, 33, 'Erdemli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (405, 33, 'Gülnar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (406, 33, 'Mut');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (407, 33, 'Silifke');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (408, 33, 'Tarsus');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (409, 34, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (410, 34, 'Adalar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (411, 34, 'Avcilar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (412, 34, 'Bagcilar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (413, 34, 'Bakirköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (414, 34, 'Bahçelievle');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (415, 34, 'Bayrampasa');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (416, 34, 'Besiktas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (417, 34, 'Beykoz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (418, 34, 'Beyoglu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (419, 34, 'Büyükçekmece');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (420, 34, 'Çatalca');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (421, 34, 'Eminönü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (422, 34, 'Eyüp');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (423, 34, 'Esenler');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (424, 34, 'Fatih');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (425, 34, 'Gaziosmanpasa');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (426, 34, 'Güngören');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (427, 34, 'Kadiköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (428, 34, 'Kagithane');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (429, 34, 'Kartal');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (430, 34, 'Küçükçekmece');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (431, 34, 'Maltepe');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (432, 34, 'Pendik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (433, 34, 'Sariyer');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (434, 34, 'Silivri');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (435, 34, 'Sultanbeyli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (436, 34, 'Sile');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (437, 34, 'Sisli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (438, 34, 'Tuzla');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (439, 34, 'Ümraniye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (440, 34, 'Üsküdar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (441, 34, 'Yalova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (442, 34, 'Zeytinburnu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (443, 35, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (444, 35, 'Aliaga');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (445, 35, 'Bayindir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (446, 35, 'Balçova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (447, 35, 'Bergama');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (448, 35, 'Beydag');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (449, 35, 'Bornova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (450, 35, 'Buca');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (451, 35, 'Çesme');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (452, 35, 'Çigli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (453, 35, 'Dikili');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (454, 35, 'Foça');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (455, 35, 'Gaziemir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (456, 35, 'Güzelbahçe');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (457, 35, 'Karaburun');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (458, 35, 'Karsiyaka');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (459, 35, 'Kemalpasa');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (460, 35, 'Kinik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (461, 35, 'Kiraz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (462, 35, 'Konak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (463, 35, 'Menderes');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (464, 35, 'Menemen');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (465, 35, 'Narlidere');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (466, 35, 'Ödemis');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (467, 35, 'Seferihisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (468, 35, 'Selçuk');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (469, 35, 'Tire');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (470, 35, 'Torbali');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (471, 35, 'Urla');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (472, 36, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (473, 36, 'Akyaka');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (474, 36, 'Arpaçay');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (475, 36, 'Digor');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (476, 36, 'Kagizman');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (477, 36, 'Sarikamis');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (478, 36, 'Selim');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (479, 36, 'Susuz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (480, 37, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (481, 37, 'Abana');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (482, 37, 'Agli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (483, 37, 'Araç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (484, 37, 'Azdavay');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (485, 37, 'Bozkurt');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (486, 37, 'Cide');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (487, 37, 'Çatalzeytin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (488, 37, 'Daday');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (489, 37, 'Devrekani');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (490, 37, 'Doganyurt');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (491, 37, 'Hanönü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (492, 37, 'Ihsangazi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (493, 37, 'Inebolu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (494, 37, 'Küre');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (495, 37, 'Pinarbasi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (496, 37, 'Seydiler');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (497, 37, 'Senpazar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (498, 37, 'Tasköprü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (499, 37, 'Tosya');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (500, 38, 'Merkez');

COMMIT WORK;

INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (501, 38, 'Akkisla');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (502, 38, 'Bünyan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (503, 38, 'Develi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (504, 38, 'Felahiye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (505, 38, 'Hacilar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (506, 38, 'Incesu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (507, 38, 'Kocasinan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (508, 38, 'Melikgazi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (509, 38, 'Özvatan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (510, 38, 'Pinarbasi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (511, 38, 'Sarioglan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (512, 38, 'Sariz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (513, 38, 'Talas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (514, 38, 'Tomarza');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (515, 38, 'Yahyali');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (516, 38, 'Yesilhisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (517, 39, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (518, 39, 'Babaeski');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (519, 39, 'Demirköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (520, 39, 'Kofçaz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (521, 39, 'Lüleburgaz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (522, 39, 'Pehlivanköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (523, 39, 'Pinarhisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (524, 39, 'Vize');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (525, 40, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (526, 40, 'Akçakent');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (527, 40, 'Akpinar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (528, 40, 'Boztepe');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (529, 40, 'Çiçekdagi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (530, 40, 'Kaman');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (531, 40, 'Mucur');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (532, 41, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (533, 41, 'Darica');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (534, 41, 'Gebze');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (535, 41, 'Gölcük');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (536, 41, 'Kandira');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (537, 41, 'Karamürsel');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (538, 41, 'Körfez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (539, 42, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (540, 42, 'Ahirli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (541, 42, 'Akören');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (542, 42, 'Aksehir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (543, 42, 'Altinekin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (544, 42, 'Beysehir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (545, 42, 'Bozkir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (546, 42, 'Derebucak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (547, 42, 'Cihanbeyli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (548, 42, 'Çumra');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (549, 42, 'Çeltik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (550, 42, 'Derbent');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (551, 42, 'Doganhisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (552, 42, 'Emirgazi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (553, 42, 'Eregli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (554, 42, 'Güneysinir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (555, 42, 'Halkapinar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (556, 42, 'Hadim');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (557, 42, 'Hüyük');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (558, 42, 'Ilgin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (559, 42, 'Kadinhani');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (560, 42, 'Karapinar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (561, 42, 'Karatay');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (562, 42, 'Kulu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (563, 42, 'Meram');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (564, 42, 'Sarayönü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (565, 42, 'Selçuklu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (566, 42, 'Seydisehir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (567, 42, 'Taskent');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (568, 42, 'Tuzlukçu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (569, 42, 'Yalihöyük');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (570, 42, 'Yunak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (571, 43, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (572, 43, 'Altintas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (573, 43, 'Aslanapa');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (574, 43, 'Cavdarhisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (575, 43, 'Domaniç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (576, 43, 'Dumlupinar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (577, 43, 'Emet');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (578, 43, 'Gediz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (579, 43, 'Hisarcik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (580, 43, 'Pazarlar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (581, 43, 'Simav');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (582, 43, 'Saphane');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (583, 43, 'Tavsanli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (584, 44, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (585, 44, 'Akçadag');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (586, 44, 'Arapgir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (587, 44, 'Arguvan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (588, 44, 'Battalgazi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (589, 44, 'Darende');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (590, 44, 'Dogansehir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (591, 44, 'Doganyol');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (592, 44, 'Hekimhan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (593, 44, 'Kale');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (594, 44, 'Kuluncak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (595, 44, 'Pötürge');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (596, 44, 'Yazihan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (597, 44, 'Yesilyurt');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (598, 45, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (599, 45, 'Ahmetli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (600, 45, 'Akhisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (601, 45, 'Alasehir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (602, 45, 'Demirci');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (603, 45, 'Gölmarmara');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (604, 45, 'Gördes');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (605, 45, 'Kirkagaç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (606, 45, 'Köprübasi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (607, 45, 'Kula');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (608, 45, 'Salihli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (609, 45, 'Sarigöl');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (610, 45, 'Saruhanli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (611, 45, 'Selendi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (612, 45, 'Soma');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (613, 45, 'Turgutlu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (614, 46, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (615, 46, 'Afsin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (616, 46, 'Andirin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (617, 46, 'Çaglayancer');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (618, 46, 'Ekinözü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (619, 46, 'Elbistan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (620, 46, 'Göksun');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (621, 46, 'Nurhak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (622, 46, 'Pazarcik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (623, 46, 'Türkoglu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (624, 47, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (625, 47, 'Dargeçit');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (626, 47, 'Derik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (627, 47, 'Kiziltepe');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (628, 47, 'Mazidagi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (629, 47, 'Midyat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (630, 47, 'Nusaybin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (631, 47, 'Ömerli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (632, 47, 'Savur');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (633, 47, 'Yesilli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (634, 48, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (635, 48, 'Bodrum');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (636, 48, 'Dalaman');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (637, 48, 'Datça');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (638, 48, 'Fethiye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (639, 48, 'Kavaklidere');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (640, 48, 'Köycegiz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (641, 48, 'Marmaris');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (642, 48, 'Milas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (643, 48, 'Ortaca');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (644, 48, 'Ula');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (645, 48, 'Yatagan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (646, 49, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (647, 49, 'Bulanik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (648, 49, 'Hasköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (649, 49, 'Korkut');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (650, 49, 'Malazgirt');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (651, 49, 'Varto');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (652, 50, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (653, 50, 'Acigöl');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (654, 50, 'Avanos');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (655, 50, 'Derinkuyu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (656, 50, 'Gülsehir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (657, 50, 'Hacibektas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (658, 50, 'Kozakli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (659, 50, 'Ürgüp');
En son freeman35 tarafından 24 Kas 2004 03:07 tarihinde düzenlendi, toplamda 1 kere düzenlendi.
ZAGOR TENAY TÜRK'tür... TÜRK kalacak...
Zoru başarırım, İmkansız zaman alır
FreeMan 35.5

Soru sormaya üşenmiyorsan, sorunun çözümünü yazmaya da üşenme !!!
Kullanıcı avatarı
freeman35
Admin
Mesajlar: 2356
Kayıt: 12 Haz 2003 04:05
Konum: merkez camii yanı

Bölüm 2

Mesaj gönderen freeman35 »

Kod: Tümünü seç

INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (660, 51, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (661, 51, 'Altunhisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (662, 51, 'Bor');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (663, 51, 'Çamardi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (664, 51, 'Çiftlik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (665, 51, 'Ulukisla');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (666, 52, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (667, 52, 'Akkus');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (668, 52, 'Aybasti');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (669, 52, 'Çamas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (670, 52, 'Çatalpinar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (671, 52, 'Çaybasi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (672, 52, 'Fatsa');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (673, 52, 'Gölköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (674, 52, 'Gölyali');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (675, 52, 'Gürgentepe');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (676, 52, 'Ikizce');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (677, 52, 'Korgan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (678, 52, 'Kabadüz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (679, 52, 'Kabatas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (680, 52, 'Kumru');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (681, 52, 'Mesudiye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (682, 52, 'Persembe');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (683, 52, 'Ulubey');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (684, 52, 'Ünye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (685, 53, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (686, 53, 'Ardesen');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (687, 53, 'Çamlihemsin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (688, 53, 'Çayeli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (689, 53, 'Derepazari');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (690, 53, 'Findikli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (691, 53, 'Güneysu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (692, 53, 'Hemsin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (693, 53, 'Ikizdere');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (694, 53, 'Iyidere');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (695, 53, 'Kalkandere');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (696, 53, 'Pazar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (697, 54, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (698, 54, 'Akyazi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (699, 54, 'Ferizli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (700, 54, 'Geyve');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (701, 54, 'Hendek');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (702, 54, 'Karapürçek');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (703, 54, 'Karasu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (704, 54, 'Kaynarca');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (705, 54, 'Kocaali');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (706, 54, 'Pamukova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (707, 54, 'Sapanca');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (708, 54, 'Sögütlü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (709, 54, 'Tarakli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (710, 55, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (711, 55, 'Alaçam');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (712, 55, 'Asarcik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (713, 55, 'Ayvacik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (714, 55, 'Bafra');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (715, 55, 'Çarsamba');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (716, 55, 'Havza');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (717, 55, 'Kavak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (718, 55, 'Ladik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (719, 55, '19mayis');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (720, 55, 'Salipazari');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (721, 55, 'Tekkeköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (722, 55, 'Terme');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (723, 55, 'Vezirköprü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (724, 55, 'Yakakent');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (725, 56, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (726, 56, 'Aydinlar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (727, 56, 'Baykan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (728, 56, 'Eruh');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (729, 56, 'Kozluk');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (730, 56, 'Kurtalan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (731, 56, 'Pervari');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (732, 56, 'Sirvan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (733, 57, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (734, 57, 'Ayancik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (735, 57, 'Boyabat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (736, 57, 'Dikmen');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (737, 57, 'Duragan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (738, 57, 'Erfelek');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (739, 57, 'Gerze');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (740, 57, 'Saraydüzü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (741, 57, 'Türkeli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (742, 58, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (743, 58, 'Akincilar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (744, 58, 'Altinyayla');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (745, 58, 'Divrigi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (746, 58, 'Dogansar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (747, 58, 'Gemerek');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (748, 58, 'Gölova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (749, 58, 'Gürün');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (750, 58, 'Hafik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (751, 58, 'Imranli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (752, 58, 'Kangal');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (753, 58, 'Koyulhisar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (754, 58, 'Susehri');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (755, 58, 'Sarkisla');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (756, 58, 'Ulas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (757, 58, 'Yildizeli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (758, 58, 'Zara');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (759, 59, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (760, 59, 'Çerkezköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (761, 59, 'Çorlu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (762, 59, 'Hayrabolu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (763, 59, 'Malkara');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (764, 59, 'Marmaraeregli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (765, 59, 'Muratli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (766, 59, 'Saray');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (767, 59, 'Sarköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (768, 60, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (769, 60, 'Almus');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (770, 60, 'Artova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (771, 60, 'Basçiftlik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (772, 60, 'Erbaa');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (773, 60, 'Niksar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (774, 60, 'Pazar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (775, 60, 'Resadiye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (776, 60, 'Sulusaray');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (777, 60, 'Turhal');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (778, 60, 'Yesilyurt');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (779, 60, 'Zile');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (780, 61, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (781, 61, 'Akçaabat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (782, 61, 'Arakli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (783, 61, 'Arsin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (784, 61, 'Besikdüzü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (785, 61, 'Çarsibasi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (786, 61, 'Çaykara');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (787, 61, 'Dernekpazar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (788, 61, 'Düzköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (789, 61, 'Hayrat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (790, 61, 'Köprübasi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (791, 61, 'Maçka');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (792, 61, 'Of');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (793, 61, 'Sürmene');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (794, 61, 'Salpazari');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (795, 61, 'Tonya');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (796, 61, 'Vakfikebir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (797, 61, 'Yomra');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (798, 62, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (799, 62, 'Çemisgezek');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (800, 62, 'Hozat');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (801, 62, 'Mazgirt');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (802, 62, 'Nazimiye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (803, 62, 'Ovacik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (804, 62, 'Pertek');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (805, 62, 'Pülümür');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (806, 63, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (807, 63, 'Akçakale');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (808, 63, 'Birecik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (809, 63, 'Bozova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (810, 63, 'Ceylanpinar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (811, 63, 'Halfeti');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (812, 63, 'Harran');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (813, 63, 'Hilvan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (814, 63, 'Siverek');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (815, 63, 'Suruç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (816, 63, 'Viransehir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (817, 64, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (818, 64, 'Banaz');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (819, 64, 'Esme');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (820, 64, 'Karahalli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (821, 64, 'Sivasli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (822, 64, 'Ulubey');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (823, 65, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (824, 65, 'Bahçesaray');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (825, 65, 'Baskale');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (826, 65, 'Çaldiran');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (827, 65, 'Çatak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (828, 65, 'Edremit');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (829, 65, 'Ercis');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (830, 65, 'Gevas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (831, 65, 'Gürpinar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (832, 65, 'Muradiye');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (833, 65, 'Özalp');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (834, 65, 'Saray');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (835, 66, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (836, 66, 'Akdagmadeni');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (837, 66, 'Aydincik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (838, 66, 'Bogazliyan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (839, 66, 'Çandir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (840, 66, 'Çayiralan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (841, 66, 'Çekerek');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (842, 66, 'Kadisehri');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (843, 66, 'Sarikaya');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (844, 66, 'Saraykent');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (845, 66, 'Sorgun');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (846, 66, 'Sefaatli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (847, 66, 'Yenifakili');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (848, 66, 'Yerköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (849, 67, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (850, 67, 'Alapli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (851, 67, 'Çamoluk');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (852, 67, 'Çaycuma');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (853, 67, 'Devrek');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (854, 67, 'Eflani');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (855, 67, 'Eregli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (856, 67, 'Gökçebey');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (857, 68, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (858, 68, 'Agaçören');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (859, 68, 'Eskil');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (860, 68, 'Gülagaç');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (861, 68, 'Güzelyurt');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (862, 68, 'Ortaköy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (863, 68, 'Sariyahsi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (864, 69, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (865, 69, 'Aydintepe');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (866, 69, 'Demirözü');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (867, 70, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (868, 70, 'Ayranci');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (869, 70, 'Basyayla');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (870, 70, 'Ermenek');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (871, 70, 'Kazimkarabekir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (872, 70, 'Sariveliler');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (873, 71, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (874, 71, 'Bahsili');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (875, 71, 'Bagliseyh');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (876, 71, 'Çelebi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (877, 71, 'Delice');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (878, 71, 'Karakeçili');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (879, 71, 'Keskin');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (880, 71, 'Sulakyurt');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (881, 71, 'Yahsihan');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (882, 72, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (883, 72, 'Gercüs');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (884, 72, 'Hasankeyf');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (885, 72, 'Besiri');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (886, 72, 'Kozluk');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (887, 72, 'Sason');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (888, 73, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (889, 73, 'Beytüsseba');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (890, 73, 'Uludere');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (891, 73, 'Cizre');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (892, 73, 'Idil');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (893, 73, 'Silopi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (894, 73, 'Güçlükonak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (895, 74, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (896, 74, 'Amasra');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (897, 74, 'Kurucasile');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (898, 74, 'Ulus');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (899, 75, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (900, 75, 'Çildir');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (901, 75, 'Damal');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (902, 75, 'Göle');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (903, 75, 'Hanak');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (904, 75, 'Posof');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (905, 76, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (906, 76, 'Aralik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (907, 76, 'Karakoyunlu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (908, 76, 'Tuzluca');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (909, 77, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (910, 77, 'Altinova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (911, 77, 'Armutlu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (912, 77, 'Cinarcik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (913, 77, 'Ciftlikkoy');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (914, 77, 'Termal');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (915, 78, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (916, 78, 'Eflani');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (917, 78, 'Eskipazar');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (918, 78, 'Ovacik');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (919, 78, 'Safranbolu');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (920, 78, 'Yenice');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (921, 79, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (922, 79, 'Elbeyli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (923, 79, 'Musabeyli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (924, 79, 'Polateli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (925, 80, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (926, 80, 'Bahçe');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (927, 80, 'Hasanbeyli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (928, 80, 'Düziçi');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (929, 80, 'Kadirli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (930, 80, 'Sunbas');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (931, 80, 'Toprakkale');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (932, 81, 'Merkez');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (933, 81, 'Akçakoca');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (934, 81, 'Cumayeri');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (935, 81, 'Çilimli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (936, 81, 'Gölyaka');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (937, 81, 'Gümüsova');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (938, 81, 'Kaynasli');
INSERT INTO ILCE (SELF, MST_ID, ADI) VALUES (939, 81, 'Yigilca');

COMMIT WORK;


/******************************************************************************/
/****                          Unique Constraints                          ****/
/******************************************************************************/

ALTER TABLE IL ADD CONSTRAINT UNQ_IL UNIQUE (ADI);
ALTER TABLE ILCE ADD CONSTRAINT UNQ_ILCE UNIQUE (MST_ID, ADI);


/******************************************************************************/
/****                             Primary Keys                             ****/
/******************************************************************************/

ALTER TABLE IL ADD CONSTRAINT PK_IL PRIMARY KEY (SELF);
ALTER TABLE ILCE ADD CONSTRAINT PK_ILCE PRIMARY KEY (SELF);


/******************************************************************************/
/****                             Foreign Keys                             ****/
/******************************************************************************/

ALTER TABLE ILCE ADD CONSTRAINT FK_ILCE FOREIGN KEY (MST_ID) REFERENCES IL (SELF);
ZAGOR TENAY TÜRK'tür... TÜRK kalacak...
Zoru başarırım, İmkansız zaman alır
FreeMan 35.5

Soru sormaya üşenmiyorsan, sorunun çözümünü yazmaya da üşenme !!!
Kullanıcı avatarı
mussimsek
Admin
Mesajlar: 7586
Kayıt: 10 Haz 2003 12:26
Konum: İstanbul
İletişim:

Mesaj gönderen mussimsek »

olay budur :D

sağol abi, arşivime attım hemen.
Kullanıcı avatarı
vampir261
Üye
Mesajlar: 298
Kayıt: 23 Kas 2004 03:22
Konum: Denizli

Mesaj gönderen vampir261 »

Eline sağlık abi bunları yazmak bi yere toplamak bile bir sorundu benim için teşekkür ederim :alkis:
Kullanıcı avatarı
husonet
Admin
Mesajlar: 2962
Kayıt: 25 Haz 2003 02:14
Konum: İstanbul
İletişim:

Mesaj gönderen husonet »

Eyvallah Abi :) Eline sağlık.

Gazete manşetleri
* DİKKAT :Lütfen forum kurallarını okuyalım ve uyalım...!
* Warez,crack vs. paylaşımı kesinlikle yasaktır.
Kullanıcı avatarı
fahrettin
Admin
Mesajlar: 2619
Kayıt: 11 Haz 2003 10:38
Konum: İstanbul
İletişim:

Mesaj gönderen fahrettin »

Evet guzel hizmet..... Eyvallah....
* http://www.fahrettin.org Manzara Fotoğraflarım... :)
* http://delphiturkiye.gunduz.info Seminerler... ;)
* http://www.hakmar.com.tr Kalite bir haktır... 8)
Kullanıcı avatarı
freeman35
Admin
Mesajlar: 2356
Kayıt: 12 Haz 2003 04:05
Konum: merkez camii yanı

Mesaj gönderen freeman35 »

Rica ederim arkadaşlar :oops: Tükkan sizin :) Asıl teşekkür bunu mdb halinde toparlayan arkadaşta ben sadece az değiştirip Scripte çevirdim
ZAGOR TENAY TÜRK'tür... TÜRK kalacak...
Zoru başarırım, İmkansız zaman alır
FreeMan 35.5

Soru sormaya üşenmiyorsan, sorunun çözümünü yazmaya da üşenme !!!
Kullanıcı avatarı
fatihtolgaata
Üye
Mesajlar: 382
Kayıt: 04 Mar 2004 09:46
Konum: K.çekmece / İstanbul
İletişim:

Mesaj gönderen fatihtolgaata »

çok hoş yaa, sağolasın..
onaydin

Mesaj gönderen onaydin »

İstanbul için ilçe ve mahalleleri;

Kod: Tümünü seç

INSERT INTO ILCE (ILCE_NO, AD) VALUES (1, 'EMİNÖNÜ');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (2, 'FATİH');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (3, 'BEYOĞLU');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (4, 'ZEYTİNBURNU');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (5, 'EYÜP');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (6, 'GAZİOSMANPAŞA');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (7, 'ŞİŞLİ');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (8, 'BAYRAMPAŞA');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (9, 'ÜSKÜDAR');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (10, 'KADIKÖY');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (11, 'BAKIRKÖY');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (12, 'SARIYER');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (13, 'BEYKOZ');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (14, 'ADALAR');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (15, 'KARTAL');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (16, 'SİLİVRİ');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (17, 'KAĞITHANE');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (18, 'ÜMRANİYE');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (19, 'PENDİK');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (20, 'BEŞİKTAŞ');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (21, 'AVCILAR');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (22, 'BAĞCILAR');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (23, 'BAHÇELİEVLER');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (24, 'ESENLER');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (25, 'GÜNGÖREN');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (26, 'MALTEPE');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (27, 'TUZLA');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (28, 'ÇATALCA');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (29, 'SULTANBEYLİ');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (34, 'KÜÇÜKÇEKMECE');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (36, 'ŞİLE');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (33, 'BÜYÜKÇEKMECE');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (37, 'BİLİNMİYOR');
INSERT INTO ILCE (ILCE_NO, AD) VALUES (38, 'GÖZTEPE');

COMMIT WORK;
Mahalleler;

Kod: Tümünü seç

INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (1, 1, 'ALEMDAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (2, 1, 'BALABANAĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (3, 1, 'BEYAZIT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (4, 1, 'BİNBİRDİREK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (5, 1, 'CANKURTARAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (6, 1, 'DEMİRTAŞ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (7, 1, 'EMİN SİNAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (8, 1, 'HACI KADIN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (9, 1, 'HOBYAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (10, 1, 'HOCA GIYASETTİN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (11, 1, 'HOCA PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (12, 1, 'KALENDERHANE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (13, 1, 'KATİP KASIM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (14, 1, 'KEMAL PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (15, 1, 'KÜÇÜK AYASOFYA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (16, 1, 'MERCAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (17, 1, 'MESİH PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (18, 1, 'MİMAR HAYRETTİN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (19, 1, 'MİMAR KEMALETTİN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (20, 1, 'MOLLA FERANİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (21, 1, 'MOLLA HÜSREV');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (22, 1, 'MUHSİNE HATUN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (23, 1, 'NİŞANCA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (24, 1, 'RÜSTEMPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (25, 1, 'SARAÇ İSHAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (26, 1, 'SARI DEMİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (27, 1, 'SULTANAHMET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (28, 1, 'SURURİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (29, 1, 'SÜLEYMANİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (30, 1, 'SEHSUVAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (31, 1, 'TAHTAKALE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (32, 1, 'TAYA HATUN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (33, 1, 'YAVUZ SİNAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (34, 2, 'ABDİ ÇELEBİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (35, 2, 'AVCI BEY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (36, 2, 'ATİK MUSTAFA PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (37, 2, 'HÜSAMBEY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (38, 2, 'HOCA ÜVEYZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (39, 2, 'HIZIR ÇAVUŞ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (40, 2, 'HAYDAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (41, 2, 'HATİP MUSLUHİTTİN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (42, 2, 'HATİCE SULTAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (43, 2, 'HASAN HALİFE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (44, 2, 'HARAÇCI KARAMEHMET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (45, 2, 'HAMAMI MUHİTTİN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (46, 2, 'HACI HÜSEYİN AĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (47, 2, 'HACI HAMZA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (48, 2, 'HACI EVHADETTİN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (49, 2, 'GURABA HÜSEYİNAĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (50, 2, 'FATMA SULTAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (51, 2, 'EREĞLİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (52, 2, 'DERVİŞ ALİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (53, 2, 'DENİZ ABDAL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (54, 2, 'DAVUTPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (55, 2, 'ÇAKIRAĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (56, 2, 'CAMBAZİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (57, 2, 'BEYCEĞİZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (58, 2, 'BEYAZITAĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (59, 2, 'BALAT KARABAŞ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (60, 2, 'KASIM GÜNANİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (61, 2, 'KASAP İLYAS');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (62, 2, 'KASAP DEMİRHUN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (63, 2, 'KARİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (64, 2, 'İSKENDER PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (65, 2, 'İNEBEY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (66, 2, 'İMRAHOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (67, 2, 'İBRAHİM ÇAVUŞ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (68, 2, 'MÜFTÜ ALİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (69, 2, 'MURAT PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (70, 2, 'MUHTESİP İSKENDER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (71, 2, 'MOLLA AŞKI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (72, 2, 'MİMAR SİNAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (73, 2, 'MELEK HATUN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (74, 2, 'KÜRKÇÜBAŞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (75, 2, 'YALI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (76, 2, 'VELEDİ KARAKAŞ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (77, 2, 'UZUN YUSUF');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (78, 2, 'TEVKİİ CAFER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (79, 2, 'TAHTAMİNARE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (80, 2, 'ŞEYH RESMİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (81, 2, 'SOFULAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (82, 2, 'SİNAN AĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (83, 2, 'SEYİT ÖMER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (84, 2, 'SANCAKTAR HAYRETTİN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (85, 2, 'ÖRDEK KASAP');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (86, 2, 'NEVBAHAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (87, 2, 'NESLİŞAH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (88, 2, 'KÜÇÜK MUSTAFA PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (89, 2, 'KOCA MUSTAFA PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (90, 2, 'KOCA DEDE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (91, 2, 'KIRMASTI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (92, 2, 'KIRKÇEŞME');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (93, 2, 'KEÇİ HATUN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (94, 2, 'KEÇECİ KARABAŞ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (95, 2, 'KATİP MUSLUHİTTİN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (96, 2, 'BABAHASAN ALEMİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (97, 2, 'ABDİ SUBAŞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (98, 2, 'ALİ FAKIH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (99, 2, 'ARABACI BEYAZIT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (100, 2, 'ARPAEMİNİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (101, 3, 'ARAPCAMİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (102, 3, 'BEDRETTİN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (103, 3, 'ASMALIMESCİT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (104, 3, 'EVLİYA ÇELEBİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (105, 3, 'EMEKYEMEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (106, 3, 'ÇUKUR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (107, 3, 'ÇATMAMESCİT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (108, 3, 'CİHANGİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (109, 3, 'CAMİİKEBİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (110, 3, 'BÜLBÜL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (111, 3, 'BOSTAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (112, 3, 'İSTİKLAL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (113, 3, 'HÜSEYİNAĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (114, 3, 'HALICIOĞLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (115, 3, 'HACIMİMİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (116, 3, 'HACIAHMET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (117, 3, 'GÜMÜŞSUYU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (118, 3, 'FİRUZAĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (119, 3, 'FETİHTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (120, 3, 'PİRİMEHMET PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (121, 3, 'ÖRNEKTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (122, 3, 'ÖMERAVNİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (123, 3, 'MÜEYYETZADE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (124, 3, 'KÜÇÜKPİYALE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (125, 3, 'KULOĞLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (126, 3, 'KULAKSIZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (127, 3, 'KOCATEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (128, 3, 'YENİŞEHİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (129, 3, 'YAHYAKAHYA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (130, 3, 'TOMTOM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (131, 3, 'ŞEHİTMUHTAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (132, 3, 'ŞAHKULU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (133, 3, 'SÜTLÜCE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (134, 3, 'SURURİ MEHMET EFENDİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (135, 3, 'PÜRTELAŞ HASAN EFEND');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (136, 3, 'PİYALEPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (137, 3, 'KILIÇALİPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (138, 3, 'KEMANKEŞ KARAMUSTAFA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (139, 3, 'KEÇECİPİRİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (140, 3, 'KATİPMUSTAFA ÇELEBİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (141, 3, 'KAPTANPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (142, 3, 'KAMER HATUN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (143, 3, 'KALYONCU KULLUĞU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (144, 3, 'KADIMEHMET EFENDİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (145, 3, 'BEREKETZADE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (146, 4, 'BEŞTELSİZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (147, 4, 'KAZLIÇEŞME');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (148, 4, 'MALTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (149, 4, 'ÇIRPICI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (150, 4, 'MERKEZEFENDİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (151, 4, 'SEYİT NİZAM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (152, 4, 'YEŞİLTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (153, 4, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (154, 4, 'YENİDOĞAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (155, 4, 'VELİ EFENDİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (156, 4, 'TELSİZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (157, 4, 'SÜMER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (158, 5, 'MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (159, 5, 'DÜĞMECİLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (160, 5, 'ESENTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (161, 5, 'EMNİYETTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (162, 5, 'RAMİ CUMA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (163, 5, 'NİŞANCA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (164, 5, 'MİTHATPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (165, 5, 'MİMAR SİNAN PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (166, 5, 'KARADOLAP');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (167, 5, 'İSLAMBEY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (168, 5, 'GÜZELTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (169, 5, 'AKŞEMSEDDİN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (170, 5, 'YEŞİLPINAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (171, 5, 'TOPÇULAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (172, 5, 'SİLAHTARAĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (173, 5, 'SAKARYA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (174, 5, 'RAMİ YENİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (175, 5, 'DEFTERDAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (176, 5, 'ÇIRÇIR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (177, 5, 'ALİBEYKÖY/MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (178, 6, 'BAĞLARBAŞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (179, 6, 'FEVZİ ÇAKMAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (180, 6, 'KARADENİZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (181, 6, 'GAZİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (182, 6, 'HÜRRİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (183, 6, 'UĞUR MUMCU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (184, 6, 'PAZARİÇİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (185, 6, 'KARAYOLLARI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (186, 6, 'İSMETPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (187, 6, 'HABİBLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (188, 6, 'CUMHURİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (189, 6, 'ZÜBEYDE HANIM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (190, 6, 'YILDIZTABYA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (191, 6, 'YENİDOĞAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (192, 6, 'YENİMAHALLE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (193, 6, 'ŞEMSİ PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (194, 6, 'SULTAN ÇİFTLİĞİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (195, 6, 'SARIGÖL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (196, 6, 'MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (197, 6, 'MALKOÇOĞLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (198, 6, 'KAZIM KARABEKİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (199, 6, 'ESENTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (200, 6, 'KARLITEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (201, 6, 'ELLİNCİ YIL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (202, 6, 'BARBAROS HAYRETTİN P');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (203, 6, 'CEBECİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (205, 7, 'ERGENEKON');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (206, 7, 'ESKİŞEHİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (208, 7, 'YAYLA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (209, 7, 'PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (210, 7, 'ONDOKUZ MAYIS');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (212, 7, 'MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (213, 7, 'MECİDİYEKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (214, 7, 'MASLAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (216, 7, 'KUŞTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (217, 7, 'KAPTAN PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (218, 7, 'İZZET PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (219, 7, 'İNÖNÜ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (220, 7, 'HUZUR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (222, 7, 'HALİL RIFAT PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (223, 7, 'HALİDE EDİP ADIVAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (225, 7, 'GÜLBAHAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (226, 7, 'FULYA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (227, 7, 'FERİKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (228, 7, 'DUATEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (229, 7, 'BOZKURT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (230, 7, 'CUMHURİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (231, 8, 'ALTINTEPSİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (232, 8, 'KOCATEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (233, 8, 'TERAZİDERE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (234, 8, 'ORTAMAHALLE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (235, 8, 'MURATPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (236, 8, 'YILDIRIM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (237, 8, 'YENİDOĞAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (238, 8, 'VATAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (239, 8, 'KARTALTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (240, 8, 'CEVATPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (241, 8, 'İSMETPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (242, 9, 'ABDULLAH AĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (243, 9, 'ARAKİYECİ HACI MEHME');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (244, 9, 'AHMET ÇELEBİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (245, 9, 'EMNİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (246, 9, 'EMEK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (247, 9, 'CUMHURİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (248, 9, 'BURHANİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (249, 9, 'BULGURLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (250, 9, 'BEYLERBEYİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (251, 9, 'BARBAROS');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (252, 9, 'BAHÇELİEVLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (253, 9, 'HAYRETTİN ÇAVUŞ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (254, 9, 'HAVUZBAŞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (255, 9, 'HACIHESNA HATUN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (256, 9, 'GÜZELTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (258, 9, 'FETİH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (257, 9, 'GÜLFEMHATUN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (259, 9, 'FERAH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (260, 9, 'ESATPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (261, 9, 'RUMİMEHMET PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (262, 9, 'PAZARBAŞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (263, 9, 'ÖRNEK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (264, 9, 'MURAT REİS');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (265, 9, 'KÜPLÜCE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (266, 9, 'KÜÇÜKSU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (267, 9, 'KUZGUNCUK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (268, 9, 'KULELİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (269, 9, 'YAVUZTÜRK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (270, 9, 'VANİKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (271, 9, 'VALİDE-İ ATİK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (272, 9, 'ÜNALAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (273, 9, 'MERKEZ İNKILAP');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (274, 9, 'TOYGAR HAMZA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (275, 9, 'TEMBEL HACI MEHMET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (276, 9, 'TAVAŞİ HASAN AĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (277, 9, 'TABAKLAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (278, 9, 'SOLAKSİNAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (279, 9, 'SELMANAĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (280, 9, 'SELİMİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (281, 9, 'SELAMİ ALİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (282, 9, 'KISIKLI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (283, 9, 'KİRAZLITEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (284, 9, 'KEFÇEDEDE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (286, 9, 'İMRAHOR-SALACAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (287, 9, 'İHSANİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (289, 9, 'AYAZMA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (290, 9, 'ACIBADEM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (292, 9, 'AHÇIBAŞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (293, 10, 'ACIBADEM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (294, 10, 'ATATÜRK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (296, 10, 'BARBAROS');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (297, 10, 'MERDİVENKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (298, 10, 'KÜÇÜKBAKKALKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (300, 10, 'KOŞUYOLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (301, 10, 'KAYIŞDAĞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (302, 10, 'İNÖNÜ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (303, 10, 'İÇERENKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (304, 10, 'HASANPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (305, 10, 'GÖZTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (306, 10, 'FİKİRTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (307, 10, 'FENERBAHÇE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (308, 10, 'FENERYOLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (309, 10, 'ERENKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (310, 10, 'EĞİTİM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (311, 10, 'DUMLUPINAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (312, 10, 'CAFERAĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (313, 10, 'ZÜHTÜPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (314, 10, 'YENİSAHRA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (315, 10, 'SUADİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (316, 10, 'SAHRAYICEDİD');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (317, 10, 'RASİMPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (318, 10, 'OSMANAĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (319, 10, 'ONDOKUZ MAYIS');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (320, 11, 'BASINKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (321, 11, 'ATAKÖY 1.KISIM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (322, 11, 'CEVİZLİK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (323, 11, 'SAKIZAĞACI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (324, 11, 'YENİMAHALLE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (325, 11, 'YEŞİLYURT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (326, 11, 'ZUHURATBABA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (327, 11, 'ATAKÖY 2-5-6 KISIM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (328, 11, 'ATAKÖY 3-4-11 KISIM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (329, 11, 'ZEYTİNLİK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (330, 11, 'YEŞİLKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (331, 11, 'ŞENLİKKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (332, 11, 'OSMANİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (333, 11, 'KARTALTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (334, 11, 'ATAKÖY 7-8-9-10 KISIM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (335, 12, 'BÜYÜKDERE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (336, 12, 'BALTALİMANI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (337, 12, 'CUMHURİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (338, 12, 'FERAHEVLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (339, 12, 'İSTİNYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (340, 12, 'EMİRGAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (341, 12, 'ÇAYIRBAŞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (342, 12, 'KİREÇBURNU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (343, 12, 'MADEN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (344, 12, 'KOCATAŞ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (345, 12, 'KAZIM KARABEKİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (346, 12, 'DERBENT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (347, 12, 'YENİMAHALLE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (348, 12, 'YENİKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (349, 12, 'TARABYA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (350, 12, 'RUMELİ KAVAĞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (351, 12, 'RUMELİ HİSARI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (352, 12, 'REŞİTPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (353, 12, 'P.T.T.  EVLERİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (354, 12, 'POLİGON');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (355, 12, 'PINAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (356, 13, 'ANADOLU HİSARI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (358, 13, 'ÇUBUKLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (359, 13, 'GÖZTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (360, 13, 'İNCİRKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (362, 13, 'KANLICA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (363, 13, 'YENİMAHALLE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (365, 13, 'TOKATKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (366, 13, 'SOĞUKSU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (367, 13, 'RÜZGARLIBAHÇE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (369, 13, 'ORTAÇEŞME');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (370, 13, 'BEYKOZ MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (372, 13, 'GÖKSU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (373, 13, 'ÇİĞDEM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (374, 13, 'ANADOLU KAVAĞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (376, 14, 'NİZAM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (377, 15, 'CEVİZLİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (379, 15, 'TOPSELVİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (380, 15, 'SOĞANLIK YENİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (381, 15, 'RAHMANLAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (382, 15, 'PETROL İŞ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (383, 15, 'ORTA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (384, 15, 'ORHANTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (385, 15, 'KORDONBOYU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (386, 15, 'YUKARI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (387, 15, 'YENİMAHALLE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (388, 15, 'YALI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (389, 15, 'YAKACIK YENİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (390, 15, 'ÇAVUŞOĞLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (391, 15, 'ESENTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (392, 15, 'GÜMÜŞPINAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (393, 15, 'KARLIKTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (394, 15, 'HÜRRİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (395, 15, 'ÇARŞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (396, 15, 'CUMHURİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (397, 16, 'ALİBEY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (398, 16, 'P.MEHMET PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (399, 16, 'FATİH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (400, 16, 'MİMARSİNAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (401, 16, 'YENİMAHALLE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (402, 16, 'ÇANTA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (403, 16, 'B.ÇAVUŞLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (404, 16, 'ORTAKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (405, 16, 'KAMİLOBA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (406, 16, 'GÜMÜŞYAKA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (407, 16, 'CELALİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (408, 16, 'SELİMPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (409, 16, 'D.KÖY/FEVZİPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (410, 16, 'D.İSMETPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (411, 17, 'ÇAĞLAYAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (412, 17, 'YEŞİLCE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (413, 17, 'YAHYA KEMAL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (414, 17, 'TELSİZLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (415, 17, 'TALATPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (416, 17, 'ŞİRİNTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (417, 17, 'SEYRANTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (418, 17, 'SANAYİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (419, 17, 'ORTABAYIR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (420, 17, 'GÜLTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (421, 17, 'GÜRSEL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (422, 17, 'HARMANTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (423, 17, 'MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (424, 17, 'HÜRRİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (425, 17, 'EMNİYETEVLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (426, 17, 'ÇELİKTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (427, 18, 'ATAKENT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (428, 18, 'YUKARI DUDULLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (429, 18, 'NAMIK KEMAL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (430, 18, 'MUSTAFA KEMAL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (431, 18, 'KAZIM KARABEKİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (432, 18, 'ÇAKMAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (433, 18, 'HEKİMBAŞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (436, 18, 'İNKİLAP');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (434, 18, 'IHLAMURKUYU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (437, 18, 'ATATÜRK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (439, 19, 'BAHÇELİEVLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (440, 19, 'ORHANGAZİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (441, 19, 'GÜLLÜ BAĞLAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (442, 19, 'FATİH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (444, 19, 'AHMET YESEVİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (445, 19, 'YEŞİLBAĞLAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (446, 19, 'YENİMAHALLE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (447, 19, 'YAYALAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (449, 19, 'SÜLÜNTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (450, 19, 'SAPANBAĞLARI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (452, 19, 'VELİBABA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (453, 19, 'ŞEYHLİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (454, 19, 'ORTA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (456, 19, 'KAYNARCA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (457, 19, 'KAVAKPINAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (459, 19, 'GÜZELYALI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (460, 19, 'ÇINARDERE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (461, 19, 'DOĞU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (462, 19, 'DUMLUPINAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (463, 19, 'FEVZİ ÇAKMAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (464, 19, 'ESENYALI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (465, 19, 'ÇAMÇEŞME');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (466, 19, 'BATI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (467, 20, 'ABBASAĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (468, 20, 'TEŞVİKİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (469, 20, 'ARNAVUTKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (470, 20, 'CİHANNUMA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (471, 20, 'DİKİLİTAŞ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (472, 20, 'BEBEK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (473, 20, 'KURUÇEŞME');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (474, 20, 'LEVENT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (475, 20, 'MURADİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (476, 20, 'SİNANPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (477, 20, 'TÜRKALİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (478, 20, 'ORTAKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (479, 20, 'VİŞNEZADE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (480, 20, 'YILDIZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (481, 20, 'AKAT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (482, 20, 'BALMUMCU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (483, 20, 'GAYRETTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (484, 20, 'ETİLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (485, 20, 'KONAKLAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (486, 20, 'KÜLTÜR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (487, 20, 'LEVAZIM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (488, 20, 'NİSBETİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (489, 21, 'CİHANGİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (490, 21, 'AMBARLI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (491, 21, 'DENİZKÖŞKLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (492, 21, 'FİRUZKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (493, 21, 'GÜMÜŞPALA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (494, 21, 'MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (495, 21, 'MUSTAFA KEMAL PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (496, 21, 'TAHTAKALE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (497, 21, 'ÜNİVERSİTE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (498, 22, '100.YIL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (499, 22, 'YILDIZTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (500, 22, 'YENİMAHALLE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (501, 22, 'YENİGÜN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (502, 22, 'YAVUZ SELİM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (503, 22, 'SANCAKTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (504, 22, 'MAHMUTBEY MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (505, 22, 'GÜNEŞLİ MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (506, 22, 'KEMALPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (507, 22, 'İNÖNÜ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (508, 22, 'HÜRRİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (509, 22, 'GÖZTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (510, 22, 'FEVZİ ÇAKMAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (511, 22, 'KİRAZLI FEVZİ ÇAKMAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (512, 22, 'ÇINAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (513, 22, 'DEMİRKAPI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (515, 22, 'KAZIM KARABEKİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (516, 22, 'FATİH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (518, 22, 'BAĞLAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (519, 23, 'BAHÇELİEVLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (521, 23, 'ŞİRİNEVLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (522, 23, 'HÜRRİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (524, 23, 'SOĞANLI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (525, 23, 'SİYAVUŞPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (526, 23, 'FEVZİ ÇAKMAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (527, 23, 'ÇOBANÇEŞME');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (528, 24, 'ÇİFTE HAVUZLAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (530, 24, 'HAVAALANI');
COMMIT WORK;
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (532, 24, 'MENDERES');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (533, 24, 'NAMIK KEMAL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (534, 24, 'TURGUT REİS');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (535, 24, 'NİNE HATUN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (536, 24, 'BİRLİK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (538, 24, 'MİMAR SİNAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (539, 24, 'KEMER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (540, 24, 'KARABAYIR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (541, 24, 'HABİBLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (542, 24, 'DAVUTPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (543, 24, 'FEVZİ ÇAKMAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (544, 25, 'AKINCILAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (545, 25, 'ABDURRAHMAN NAFİZ GÜ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (546, 25, 'GENÇOSMAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (547, 25, 'GÜNEŞTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (548, 25, 'GÜVEN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (549, 25, 'HAZNEDAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (550, 25, 'TOZKOPARAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (551, 25, 'SANAYİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (552, 25, 'MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (553, 25, 'MAREŞAL ÇAKMAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (554, 25, 'MEHMET NEZİHİ ÖZMEN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (555, 26, 'ALTAYÇEŞME');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (556, 26, 'ALTINTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (557, 26, 'AYDINEVLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (558, 26, 'BAĞLARBAŞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (559, 26, 'BAŞIBÜYÜK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (560, 26, 'BÜYÜKBAKKALKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (561, 26, 'CEVİZLİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (562, 26, 'ÇINAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (563, 26, 'ESENKENT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (564, 26, 'FERHATPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (565, 26, 'ZÜMRÜTEVLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (566, 26, 'YALI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (567, 26, 'KÜÇÜKYALI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (568, 26, 'İDEALTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (569, 26, 'GÜLSUYU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (570, 26, 'GÜLENSU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (571, 26, 'GİRNE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (572, 26, 'FEYZULLAH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (573, 26, 'FINDIKLI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (574, 27, 'TUZLA MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (575, 27, 'CAMİİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (576, 27, 'EVLİYA ÇELEBİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (577, 27, 'İÇMELER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (578, 27, 'İSTASYON');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (579, 27, 'MİMAR SİNAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (580, 27, 'YAYLA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (581, 27, 'ŞİFA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (582, 27, 'AYDINLI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (583, 27, 'POSTAHANE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (584, 27, 'AYDINTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (585, 33, 'GÜZELCE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (586, 8, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (587, 14, 'HEYBELİADA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (588, 14, 'BURGAZADA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (589, 14, 'KINALIADA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (590, 22, 'MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (591, 23, 'KOCASİNAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (592, 23, 'CUMHURİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (593, 20, 'AMBARLIDERE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (594, 20, 'MECİDİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (595, 13, 'ÇAVUŞBAŞI / ÇİFTLİK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (597, 13, 'ÇAVUŞBAŞI/BAKLACI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (598, 13, 'ÇAVUŞBAŞI/YAVUZSELİM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (599, 33, 'HARAMİDERE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (600, 33, 'İNÖNÜ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (601, 33, 'BAHÇELİEVLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (603, 33, 'MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (604, 33, 'NAMIK KEMAL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (606, 33, 'TEPECİK ULUS');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (608, 33, 'GÜRPINAR MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (611, 33, 'SAADETDERE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (612, 33, 'SAHİL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (614, 33, 'KAVAKLI MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (615, 33, 'BATIKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (616, 33, 'HÜRRİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (617, 33, 'YENİKENT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (618, 33, '19 MAYIS MAHALLESİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (620, 33, 'NAMIK KEMAL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (621, 33, 'MEHTER ÇEŞME');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (622, 33, 'YAKUPLU MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (623, 33, 'BÜYÜKŞEHİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (624, 33, 'ATATÜRK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (625, 33, 'FATİH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (626, 33, 'YENİ MAHALLE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (627, 33, 'M.ÇEŞME');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (628, 33, 'TALATPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (629, 33, 'İNCİRTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (630, 33, 'BEYLİKDÜZÜ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (632, 28, 'FERHATPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (633, 28, 'KALEİÇİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (634, 28, 'HADIMKÖY/HASTANE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (635, 28, 'HADIMKÖY/İSTASYON');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (636, 28, 'DURUSU/ZAFER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (637, 28, 'DURUSU/CAMİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (638, 28, 'BİNKILIÇ/ATATÜRK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (639, 28, 'BİNKILIÇ/FATİH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (640, 28, 'KARACAKÖY/MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (641, 28, 'ÇİFTLİKKÖY/MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (642, 28, 'MURATBEY/MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (643, 24, 'ORUÇ REİS');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (644, 2, 'MOLLA ŞEREF');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (645, 5, 'GÖKTÜRK/MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (646, 2, 'HOBYAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (647, 6, 'MAREŞAL FEVZİÇAKMAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (648, 6, 'MEHMET AKİF ERSOY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (649, 6, 'MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (650, 6, 'ADNAN MENDERES');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (651, 6, 'BOLLUCA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (652, 6, 'İSTİKLAL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (653, 6, 'İSLAMBEY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (654, 6, 'MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (655, 6, 'YAVUZSELİM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (656, 6, 'ATATÜRK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (657, 6, 'MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (658, 6, 'KARLIBAYIR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (659, 6, 'HARAÇCI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (660, 6, 'YUNUS EMRE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (661, 6, '75. YIL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (662, 17, 'MEHMET AKİF');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (663, 17, 'HAMİDİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (664, 17, 'NURTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (665, 15, 'VEYSEL KARANİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (666, 15, 'OSMANGAZİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (667, 15, 'EYÜP SULTAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (668, 15, 'A.GAZİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (669, 34, 'ALTINŞEHİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (670, 34, 'ATATÜRK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (671, 34, 'BEŞYOL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (672, 34, 'CENNET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (674, 34, 'FATİH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (675, 34, 'FEVZİÇAKMAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (676, 34, 'GÜLTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (678, 34, 'İNÖNÜ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (679, 34, 'İSTASYON');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (680, 34, 'KANARYA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (681, 34, 'KARTALTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (683, 34, 'MEHMET AKİF');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (684, 34, 'SÖĞÜTLÜÇEŞME');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (686, 34, 'TEVFİKBEY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (687, 34, 'YENİMAHALLE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (688, 34, 'YEŞİLOVA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (689, 34, 'ZİYA GÖKALP');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (690, 34, 'KAYABAŞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (691, 19, 'FEVZİ ÇAKMAK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (692, 12, 'FATİH SULTAN MEHMET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (693, 12, 'SARIYER MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (694, 12, 'BAHÇEKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (695, 29, 'ABDURRAHMAN GAZİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (696, 29, 'ADİL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (697, 29, 'AHMET YESEVİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (698, 29, 'AKŞEMSEDDİN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (699, 29, 'BATTAL GAZİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (700, 29, 'FATİH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (701, 29, 'HAMİDİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (702, 29, 'HASAN PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (703, 29, 'MİMAR SİNAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (704, 29, 'MECİDİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (705, 29, 'MEHMET AKİF');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (706, 29, 'NECİP FAZIL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (707, 29, 'ORHAN GAZİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (708, 29, 'TURGUT REİS');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (709, 29, 'YAVUZ SELİM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (710, 27, 'FIRAT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (711, 27, 'FATİH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (712, 27, 'ANADOLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (713, 27, 'MESCİT');
onaydin

Mesaj gönderen onaydin »

Kod: Tümünü seç

INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (714, 27, 'ORTA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (715, 36, 'BALİBEY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (716, 36, 'ÇAVUŞ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (717, 36, 'HACIKASIM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (718, 36, 'KUMBABA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (719, 36, 'AĞVA MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (720, 7, 'TEŞVİKİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (721, 18, 'MUSTAFA KEMAL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (722, 18, 'ALEMDAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (723, 18, 'ALEMDAR ÇATALÇEŞME');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (724, 18, 'ALEMDAR EKŞİOĞLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (725, 18, 'SARIGAZİ MECLİS');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (726, 18, 'SARIGAZİ İNÖNÜ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (727, 18, 'SARIGAZİ KEMALTÜRKLE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (728, 18, 'SARIGAZİ MEMEK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (729, 18, 'SARIGAZİ MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (730, 18, 'YENİÇAMLICA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (731, 18, 'ESENŞEHİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (732, 18, 'YENİDOĞAN MERVE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (733, 18, 'YENİDOĞAN SAFA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (734, 18, 'YENİDOĞAN MEVLANA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (735, 18, 'YENİDOĞAN YUNUSEMRE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (736, 18, 'YENİDOĞAN OSMANGAZİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (737, 18, 'ÇEKMEKÖY MİMARSİNAN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (738, 18, 'ÇEKMEKÖY MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (739, 18, 'ÇEKMEKÖY MEHMET AKİF');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (740, 18, 'ÇEKMEKÖY ÇAMLIK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (741, 18, 'ÇEKMEKÖY HAMİDİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (742, 18, 'S.ÇİFTLİĞİ GÜNGÖREN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (743, 18, 'S.ÇİFTLİĞİ SOĞUKPINA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (744, 18, 'S.ÇİFTLİĞİ ÇAMLIK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (745, 18, 'S.ÇİFTLİĞİ MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (747, 18, 'S.ÇİFTLİĞİ AYDINLAR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (748, 18, 'S.ÇİFTLİĞİ CUMHURİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (749, 18, 'ÖMERLİ MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (750, 9, 'ARAKİYECİ HACI CAFER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (751, 9, 'HASIPPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (752, 9, 'MEHMET AKİF ERSOY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (754, 21, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (755, 22, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (756, 23, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (758, 20, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (759, 13, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (760, 3, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (761, 33, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (762, 28, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (763, 1, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (764, 24, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (765, 5, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (766, 2, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (767, 6, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (768, 25, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (769, 10, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (770, 17, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (771, 15, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (772, 34, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (773, 34, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (774, 26, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (775, 19, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (776, 12, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (777, 16, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (778, 29, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (779, 36, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (780, 7, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (781, 27, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (782, 18, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (783, 9, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (204, 7, 'AYAZAĞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (207, 7, 'ESENTEPE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (211, 7, 'MEŞRUTİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (215, 7, 'MAHMUT ŞEVKET PAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (221, 7, 'HARBİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (224, 7, 'HALASKARGAZİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (285, 9, 'KANDİLLİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (288, 9, 'İCADİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (291, 9, 'ALTUNİZADE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (295, 10, 'BOSTANCI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (299, 10, 'KOZYATAĞI');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (357, 13, 'ÇAMLIBAHÇE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (361, 13, 'KAVACIK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (364, 13, 'YALIKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (368, 13, 'PAŞABAHÇE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (371, 13, 'GÜMÜŞSUYU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (375, 14, 'MADEN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (378, 15, 'UĞUR MUMCU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (435, 18, 'İSTİKLAL');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (438, 18, 'AŞAĞI DUDULLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (443, 19, 'ERTUĞRULGAZİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (448, 19, 'SANAYİ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (451, 19, 'RAMAZANOĞLU');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (455, 19, 'KURTKÖY');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (458, 19, 'HARMANDERE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (514, 22, 'EVREN');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (517, 22, 'BARBAROS');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (520, 23, 'ZAFER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (523, 23, 'YENİBOSNA MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (529, 24, 'FATİH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (531, 24, 'KAZIM KARABEKİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (537, 24, 'YAVUZ SELİM');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (596, 13, 'ÇAVUŞBAŞI/ÇENGELDERE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (602, 33, 'FATİH');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (605, 33, 'CUMHURİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (609, 33, 'DİZDARİYE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (613, 33, 'ÖRNEK');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (673, 34, 'CUMHURİYET');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (677, 34, 'HALKALI MERKEZ');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (682, 34, 'KEMALPAŞA');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (685, 34, 'SULTAN MURAT');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (746, 18, 'S.ÇİFTLİĞİ KİRAZLIDE');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (753, 14, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (757, 11, 'BİLİNMİYOR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (784, 19, 'ESENLER');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (785, 24, 'BAŞAKŞEHİR');
INSERT INTO MAHALLE (MAHALLE_NO, ILCE_NO, AD) VALUES (786, 12, 'KİLYOS');

COMMIT WORK;
must_sargin
Üye
Mesajlar: 216
Kayıt: 14 Şub 2004 03:13
Konum: Gebze
İletişim:

Mesaj gönderen must_sargin »

iyi çalışmalar,
ben paradox kullanıyorum. acaba bu yapıyı paradoxa nasıl uyarlayabilirim?
Misafir

bankalar ve şubeleri

Mesaj gönderen Misafir »

bi hizmet de mikrocu dan olsun bankalar ve subeleri. sıkıştırılmış text dosyada ms sql de sorunsuz çalışıyor.

iyi çalışmalar.

http://www.kombassanpetrol.com/mustafa/BANKALAR.zip

bu arada teşekkürler mikro yazılımevi. datayı mikro dan export ettim;
P206
Kıdemli Üye
Mesajlar: 395
Kayıt: 17 Haz 2003 12:36
Konum: İstanbul

Mesaj gönderen P206 »

Teşekkürler @fireman abi ilerde mutlaka karşımıza çıkacak bişey. Elinde bu şekilde ülkeler olan arkadaş var mı?
I love my car.
Blog Yaptık
Kullanıcı avatarı
ofenX
Üye
Mesajlar: 397
Kayıt: 09 Nis 2005 10:24
Konum: Diyarbakır
İletişim:

Re: bankalar ve şubeleri

Mesaj gönderen ofenX »

Merhaba,
Anonymous yazdı:bi hizmet de mikrocu dan olsun bankalar ve subeleri.

bu arada teşekkürler mikro yazılımevi. datayı mikro dan export ettim;
Çorbaya biraz da Lks'den tuz ekleyelim. :lol: :lol: :lol: :lol: :lol: :lol: Vergi daireleri ve kodları. CNTRNR sütunundaki 178 kodu Lks vt sinde Türkiye'nin kodudur.


Kod: Tümünü seç


CREATE TABLE L_TAXOFFICE (
    LOGICALREF   INTEGER NOT NULL,
    CODE         VARCHAR(25),
    NAME         VARCHAR(51),
    ADDR1        VARCHAR(41),
    ADDR2        VARCHAR(41),
    CNTRNR       INTEGER,
    SITEID       SMALLINT,
    RECSTATUS    SMALLINT,
    ORGLOGICREF  INTEGER
);


CREATE UNIQUE INDEX TAXOFFICE_I1 ON L_TAXOFFICE (LOGICALREF);
CREATE UNIQUE INDEX TAXOFFICE_I2 ON L_TAXOFFICE (CNTRNR, CODE);
CREATE UNIQUE INDEX TAXOFFICE_I3 ON L_TAXOFFICE (NAME, LOGICALREF);


INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (1, '1115', 'İMAMOĞLU MAL MÜD', 'ADANA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (2, '1201', 'CEYHAN VD', 'ADANA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (3, '1202', 'KADİRLİ VD', 'ADANA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (4, '1203', 'KOZAN VD', 'ADANA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (5, '1204', 'OSMANİYE VD', 'ADANA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (6, '1251', 'BEŞOCAK VD', 'ADANA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (7, '1252', 'YÜREĞİR VD', 'ADANA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (8, '1253', 'SEYHAN VD', 'ADANA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (9, '1254', 'ZİYAPAŞA VD', 'ADANA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (10, '1255', 'ÇUKUROVA VD', 'ADANA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (11, '2260', 'ADIYAMAN VD', 'ADIYAMAN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (12, '3201', 'TINAZTEPE VD', 'AFYON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (13, '3260', 'DİNAR VD', 'AFYON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (14, '3261', 'BOLVADİN VD', 'AFYON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (15, '3262', 'EMİRDAĞ VD', 'AFYON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (16, '3263', 'SANDIKLI VD', 'AFYON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (17, '3280', 'KOCATEPE VD', 'AFYON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (18, '4260', 'AGRI VD', 'AĞRI', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (19, '68201', 'AKSARAY VD', 'AKSARAY', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (20, '5260', 'AMASYA VD', 'AMASYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (21, '5261', 'MERZİFON VD', 'AMASYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (22, '5264', 'SULUOVA VD', 'AMASYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (23, '6124', 'KAZAN MAL MD.', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (24, '6205', 'POLATLI VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (25, '6209', 'BEYPAZARI VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (26, '6211', 'ÇUBUK VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (27, '6215', 'ELMADAĞ VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (28, '6252', 'VERASET HARÇLAR VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (29, '6253', 'KAVAKLIDERE VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (30, '6254', 'MALTEPE VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (31, '6255', 'YENİMAHALLE VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (32, '6257', 'ÇANKAYA VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (33, '6258', 'KIZILBEY VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (34, '6259', 'MİTHATPAŞA VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (35, '6260', 'ULUS VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (36, '6261', 'YILDIRIM BAYAZIT VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (37, '6262', 'SEĞMENLER VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (38, '6263', 'ULUSİTE VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (39, '6264', 'DİKİMEVİ VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (40, '6265', 'DOĞANBEY VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (41, '6266', 'YEĞENBEY V.D', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (42, '6268', 'HİTİT VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (43, '6269', 'YAHYA GALİP VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (44, '6270', 'M.KARAGÜZEL VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (45, '6271', 'OSTİM VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (46, '6272', 'GÖLBAŞI VD', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (47, '6273', 'SİNCAN VD.', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (48, '6274', 'DIŞKAPI VD.', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (49, '6275', 'ETİMESGUT VD.', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (50, '6276', 'BAŞKENT VD.', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (51, '6277', 'CUMHURİYET VD.', 'ANKARA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (52, '7108', 'KORKUTELİ MAL MÜD', 'ANTALYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (53, '7109', 'KUMLUCA MAL MÜD', 'ANTALYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (54, '7201', 'ALANYA VD', 'ANTALYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (55, '7202', 'SERİK VD', 'ANTALYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (56, '7203', 'MANAVGAT VD', 'ANTALYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (57, '7205', 'KEMER VD.', 'ANTALYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (58, '7251', 'ÜÇKAPILAR VD', 'ANTALYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (59, '7252', 'KALEKAPI VD', 'ANTALYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (60, '7253', 'MURATPAŞA VD', 'ANTALYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (61, '7254', 'DÜDEN VD', 'ANTALYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (62, '7255', 'ANTALYA KURUMLAR VD', 'ANTALYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (63, '8102', 'ARHAVİ MAL MÜD', 'ARTVİN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (64, '8260', 'ARTVİN VD', 'ARTVİN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (65, '8261', 'HOPA VD', 'ARTVİN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (66, '75201', 'ARDAHAN VD', 'ARDAHAN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (67, '9201', 'EFELER VD', 'AYDIN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (68, '9260', 'NAZİLLİ VD', 'AYDIN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (69, '9261', 'SÖKE VD', 'AYDIN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (70, '9262', 'ÇİNE VD', 'AYDIN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (71, '9265', 'KUŞADASI VD', 'AYDIN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (72, '9280', 'GÜZELHİSAR VD', 'AYDIN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (73, '10201', 'KARESİ VD', 'BALIKESİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (74, '10260', 'AYVALIK VD', 'BALIKESİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (75, '10261', 'BANDIRMA VD', 'BALIKESİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (76, '10262', 'BURHANİYE VD', 'BALIKESİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (77, '10263', 'EDREMİT VD', 'BALIKESİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (78, '10264', 'GÖNEN VD', 'BALIKESİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (79, '10265', 'SUSURLUK VD', 'BALIKESİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (80, '10266', 'ERDEK VD', 'BALIKESİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (81, '10267', 'BİGADİÇ VD', 'BALIKESİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (82, '10268', 'SINDIRGI VD', 'BALIKESİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (83, '10280', 'KURTDERELİ VD', 'BALIKESİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (84, '74260', 'BARTIN VD', 'BARTIN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (85, '72260', 'BATMAN VD', 'BATMAN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (86, '69201', 'BAYBURT VD', 'BAYBURT', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (87, '11260', 'BİLECİK VD', 'BİLECİK', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (88, '11261', 'BOZÜYÜK VD', 'BİLECİK', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (89, '12260', 'BİNGÖL VD', 'BİNGÖL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (90, '14107', 'MUDURNU MAL MÜD.', 'BOLU', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (91, '14260', 'BOLU VD', 'BOLU', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (92, '', 'GEREDE V.D.', 'BOLU', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (93, '15260', 'BURDUR VD', 'BURDUR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (94, '15261', 'BUCAK VD', 'BURDUR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (95, '16201', 'GEMLİK VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (96, '16202', 'İNEGÖL VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (97, '16203', 'KARACABEY VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (98, '16204', 'M.KEMALPAŞA VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (99, '16205', 'MUDANYA VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (100, '16206', 'ORHANGAZİ VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (101, '16207', 'İZNİK VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (102, '16208', 'YENİŞEHİR VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (103, '16251', 'OSMANGAZİ VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (104, '16252', 'YILDIRIM VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (105, '16253', 'ÇEKİRGE VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (106, '16254', 'SETBAŞI VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (107, '16255', 'ULUDAĞ VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (108, '16256', 'YEŞİL VD', 'BURSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (109, '17107', 'EZİNE MAL MÜD', 'ÇANAKKALE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (110, '17260', 'ÇANAKKALE VD', 'ÇANAKKALE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (111, '17261', 'BİGA VD', 'ÇANAKKALE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (112, '17262', 'ÇAN VD', 'ÇANAKKALE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (113, '17263', 'GELİBOLU VD', 'ÇANAKKALE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (114, '18106', 'ORTA MAL MD', 'ÇANKIRI', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (115, '18260', 'ÇANKIRI VD', 'ÇANKIRI', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (116, '19107', 'OSMANCIK MAL MÜD', 'ÇORUM', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (117, '19260', 'ÇORUM VD', 'ÇORUM', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (118, '20201', 'SARAYLAR VD', 'DENİZLİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (119, '20203', 'GÖKPINAR VD', 'DENİZLİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (120, '20262', 'TAVAS VD', 'DENİZLİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (121, '20265', 'ÇİVRİL VD', 'DENİZLİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (122, '20280', 'PAMUKKALE VD', 'DENİZLİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (123, '21251', 'GÖKALP VD', 'DİYARBAKIR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (124, '21281', 'SÜLEYMANNAZİF VD', 'DİYARBAKIR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (125, '21282', 'CAHİT SITKI TARANCI V.D.', 'DİYARBAKIR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (126, '81260', 'DÜZCE VD.', 'DÜZCE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (127, '22106', 'MERİÇ MALMÜDÜRLÜĞÜ', 'EDİRNE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (128, '22201', 'ARDA VD', 'EDİRNE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (129, '22260', 'KIRKPINAR VD', 'EDİRNE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (130, '22261', 'KEŞAN VD', 'EDİRNE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (131, '22262', 'UZUNKÖPRÜ VD', 'EDİRNE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (132, '22263', 'HAVSA VD', 'EDİRNE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (133, '22264', 'İPSALA VD', 'EDİRNE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (134, '23201', 'HARPUT VD', 'ELAZIĞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (135, '23280', 'HAZAR VD', 'ELAZIĞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (136, '24260', 'FEVZİPAŞA VD', 'ERZİNCAN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (137, '25251', 'AZİZİYE VD', 'ERZURUM', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (138, '25280', 'KAZIMKARABEKİR VD', 'ERZURUM', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (139, '26252', 'YUNUSEMRE VD', 'ESKİŞEHİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (140, '26253', '2 EYLÜL VD', 'ESKİŞEHİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (141, '26254', 'BATTALGAZİ VD', 'ESKİŞEHİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (142, '26255', 'TAŞBAŞI VD', 'ESKİŞEHİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (143, '27202', 'NİZİP VD', 'GAZİANTEP', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (144, '27251', 'SUBURCU VD', 'GAZİANTEP', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (145, '27252', 'ŞEHİTKAMİL VD', 'GAZİANTEP', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (146, '27253', 'ŞAHİNBEY VD', 'GAZİANTEP', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (147, '27254', 'GAZİKENT VD', 'GAZİANTEP', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (148, '27255', 'KOZANLI VD', 'GAZİANTEP', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (149, '28104', 'ESPİYE VD', 'GİRESUN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (150, '28106', 'GÖRELE VD', 'GİRESUN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (151, '28109', 'TİREBOLU MAL MÜD', 'GİRESUN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (152, '28260', 'GİRESUN VD', 'GİRESUN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (153, '28261', 'BULANCAK VD', 'GİRESUN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (154, '31201', '23 TEMMUZ VD', 'HATAY', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (155, '31202', 'SAHİL VD', 'HATAY', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (156, '31260', 'DÖRTYOL VD', 'HATAY', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (157, '31261', 'KIRIKHAN VD', 'HATAY', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (158, '31262', 'REYHANLI VD', 'HATAY', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (159, '31280', 'ŞÜKRÜKANATLI VD', 'HATAY', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (160, '31281', 'AKDENİZ VD', 'HATAY', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (161, '31290', 'ASIMGÜNDÜZ VD', 'HATAY', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (162, '76201', 'IĞDIR VD', 'IĞDIR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (163, '32201', 'DAVRAZ VD', 'ISPARTA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (164, '32260', 'KAYMAKKAPI VD', 'ISPARTA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (165, '33201', 'ERDEMLİ VD', 'İÇEL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (166, '33202', 'SİLİFKE VD', 'İÇEL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (167, '33203', 'ANAMUR VD', 'İÇEL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (168, '33204', 'KIZILMURAT VD', 'İÇEL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (169, '33205', 'ŞEHİTKERİM VD', 'İÇEL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (170, '33250', 'İSTİKLAL VD', 'İÇEL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (171, '33252', 'ÜRAY VD', 'İÇEL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (172, '33254', 'LİMAN VD', 'İÇEL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (173, '33255', 'TOROS VD', 'İÇEL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (174, '34203', 'SİLİVRİ VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (175, '34204', 'BÜYÜKÇEKMECE VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (176, '34206', 'ÇATALCA VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (177, '34231', 'BOĞAZİÇİ KUR VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (178, '34232', 'MARMARA KUR VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (179, '34233', 'ULAŞTIRMA VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (180, '55203', 'ÇARŞAMBA VD', 'SAMSUN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (181, '55251', '19 MAYIS VD', 'SAMSUN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (182, '55252', 'GAZİLER VD', 'SAMSUN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (183, '55290', 'ZAFER VD', 'SAMSUN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (184, '56260', 'SİİRT VD', 'SİİRT', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (185, '57101', 'AYANCIK MAL MÜD', 'SİNOP', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (186, '57261', 'BOYABAT VD', 'SİNOP', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (187, '58101', 'DİVRİĞİ MAL MÜD', 'SİVAS', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (188, '58201', 'KALE VD', 'SİVAS', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (189, '58280', 'SİTE VD', 'SİVAS', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (190, '59106', 'SARAY MAL MÜD', 'TEKİRDAĞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (191, '59107', 'ŞARKÖY VD', 'TEKİRDAĞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (192, '59201', 'SÜLEYMANPAŞA VD', 'TEKİRDAĞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (193, '59260', 'NAMIK KEMAL VD', 'TEKİRDAĞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (194, '59261', 'ÇERKEZKÖY VD', 'TEKİRDAĞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (195, '59262', 'ÇORLU VD', 'TEKİRDAĞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (196, '59263', 'HAYRABOLU VD', 'TEKİRDAĞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (197, '59264', 'MALKARA VD', 'TEKİRDAĞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (198, '59265', 'MURATLI VD.', 'TEKİRDAĞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (199, '60260', 'TOKAT VD', 'TOKAT', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (200, '60261', 'ERBAA VD', 'TOKAT', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (201, '60262', 'NİKSAR VD', 'TOKAT', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (202, '60263', 'TURHAL VD', 'TOKAT', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (203, '60264', 'ZİLE VD', 'TOKAT', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (204, '61102', 'ARAKLI VD', 'TRABZON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (205, '61107', 'SÜRMENE VD', 'TRABZON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (206, '61201', 'HIZIRBEY VD', 'TRABZON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (207, '61260', 'AKÇAABAT VD', 'TRABZON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (208, '61261', 'OF VD', 'TRABZON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (209, '61262', 'VAKFIKEBİR VD', 'TRABZON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (210, '61280', 'KARADENİZ VD', 'TRABZON', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (211, '63201', 'ŞEHİTLİK VD', 'ŞANLIURFA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (212, '63260', 'SİVEREK VD', 'ŞANLIURFA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (213, '63280', 'TOPÇU MEYDANI VD', 'ŞANLIURFA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (214, '64104', 'ULUBEY MAL MÜD', 'UŞAK', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (215, '64260', 'UŞAK VD', 'UŞAK', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (216, '65260', 'VAN VD', 'VAN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (217, '77201', 'YALOVA VD', 'YALOVA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (218, '66260', 'YOZGAT VD', 'YOZGAT', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (219, '67201', 'UZUNMEHMET VD', 'ZONGULDAK', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (220, '67261', 'EREĞLİ KDZ VD', 'ZONGULDAK', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (221, '67263', 'ÇAYCUMA VD', 'ZONGULDAK', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (222, '67264', 'DEVREK VD', 'ZONGULDAK', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (223, '67280', 'KARAELMAS VD', 'ZONGULDAK', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (224, '34234', 'DAVUTPAŞA VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (225, '34236', 'FATİH VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (226, '34237', 'KÜÇÜKKÖY VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (227, '34238', 'LALELİ VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (228, '34239', 'MERTER VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (229, '34240', 'MEVLANAKAPI VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (230, '34241', 'RAMİ VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (231, '34242', 'SULTANBEYLİ VD.', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (232, '34243', 'SÜLEYMANİYE VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (233, '34244', 'ANADOLU KURUMLAR VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (234, '34245', 'TUZLA VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (235, '34246', 'KOZYATAĞI VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (236, '34247', 'MASLAK VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (237, '34248', 'ZİNCİRLİKUYU VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (238, '34250', 'ÇAPA VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (239, '34251', 'BEŞİKTAŞ VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (240, '34252', 'ÜMRANİYE VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (241, '34253', 'YEDİTEPE VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (242, '34254', 'GAYRETTEPE VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (243, '34255', 'ERENKÖY VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (244, '34256', 'HİSAR VER HARÇ VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (245, '34257', 'TUNA VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (246, '34258', 'RIHTIM VER HARÇ VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (247, '34259', 'GÜNGÖREN VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (248, '34260', 'KOCASİNAN VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (249, '34261', 'GÜNEŞLİ VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (250, '34262', 'KÜÇÜKYALI VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (251, '34263', 'PENDİK VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (252, '34264', 'BAYRAMPAŞA VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (253, '34265', 'BEYAZIT VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (254, '34266', 'BEYOĞLU VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (255, '34267', 'NURUOSMANİYE VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (256, '34268', 'GALATA VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (257, '34269', 'GAZİOSMANPAŞA VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (258, '34270', 'GÖZTEPE VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (259, '34271', 'HOCAPAŞA VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (260, '34272', 'KADIKÖY VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (261, '34273', 'KOCAMUSTAFAPAŞA VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (262, '34274', 'MECİDİYEKÖY VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (263, '34275', 'MERCAN VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (264, '34276', 'ŞİŞLİ VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (265, '34277', 'ÜSKÜDAR VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (266, '34278', 'HALKALI VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (267, '34279', 'KAĞITHANE VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (268, '34280', 'ZEYTİNBURNU VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (269, '34281', 'BEYKOZ VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (270, '34283', 'SARIYER VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (271, '34284', 'BAKIRKÖY VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (272, '34285', 'KARTAL VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (273, '34286', 'SULTANAHMET VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (274, '34287', 'NAKİL VASITALARI VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (275, '34288', 'SARIGAZİ VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (276, '34289', 'DIŞ TİCARET VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (277, '34291', 'ATIŞALANI VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (278, '34292', 'YAKACIK VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (279, '34293', 'YENİBOSNA VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (280, '34294', 'AVCILAR VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (281, '34295', 'ADALAR VD', 'İSTANBUL', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (282, '35114', 'SEFERİHİSAR MAL MÜD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (283, '35202', 'BERGAMA VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (284, '35203', 'MENEMEN VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (285, '35204', 'ÖDEMİŞ VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (286, '35205', 'TİRE VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (287, '35206', 'TORBALI VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (288, '35207', 'KEMALPAŞA VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (289, '35209', 'SELÇUK VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (290, '35212', 'ÇEŞME VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (291, '35213', 'ALİAĞA VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (292, '35251', '9 EYLÜL VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (293, '35252', 'YAMANLAR VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (294, '35254', 'BELKAHVE VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (295, '35255', 'BASMANE', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (296, '35256', 'KARŞIYAKA VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (297, '35257', 'KEMERALTI VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (298, '35258', 'KONAK VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (299, '35259', 'KORDON VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (300, '35260', 'ŞİRİNYER VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (301, '35261', 'KADİFEKALE VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (302, '35263', 'HASAN TAHSİN VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (303, '35264', 'BORNOVA VD', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (304, '35265', 'ÇAKABEY VD.', 'İZMİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (305, '78201', 'KARABÜK VD', 'KARABÜK', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (306, '70201', 'KARAMAN VD', 'KARAMAN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (307, '36260', 'KARS VD', 'KARS', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (308, '37108', 'İNEBOLU MAL MÜD', 'KASTAMONU', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (309, '37260', 'KASTAMONU VD', 'KASTAMONU', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (310, '37262', 'TAŞKÖPRÜ VD', 'KASTAMONU', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (311, '38251', 'MİMARSİNAN VD', 'KAYSERİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (312, '38252', 'ERCİYES VD', 'KAYSERİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (313, '38253', 'KALEÖNÜ VD', 'KAYSERİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (314, '38254', 'GEVHER NESİBE VD', 'KAYSERİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (315, '71201', 'IRMAK VD', 'KIRIKKALE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (316, '71202', 'KALETEPE VD', 'KIRIKKALE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (317, '39107', 'VİZE MAL MÜD', 'KIRKLARELİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (318, '39260', 'KIRKLARELİ VD', 'KIRKLARELİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (319, '39261', 'LÜLEBURGAZ VD', 'KIRKLARELİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (320, '39262', 'BABAESKİ VD', 'KIRKLARELİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (321, '40260', 'KIRŞEHİR VD', 'KIRŞEHİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (322, '41202', 'ULUÇINAR VD', 'KOCAELİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (323, '41203', 'İLYASBEY VD', 'KOCAELİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (324, '41204', 'GÖLCÜK VD', 'KOCAELİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (325, '41205', 'KARAMÜRSEL VD', 'KOCAELİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (326, '41206', 'KÖRFEZ VD', 'KOCAELİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (327, '41252', 'TEPECİK VD', 'KOCAELİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (328, '41253', 'ALEMDAR VD', 'KOCAELİ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (329, '42201', 'AKŞEHİR VD', 'KONYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (330, '42202', 'EREĞLİ VD', 'KONYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (331, '42204', 'BEYŞEHİR VD', 'KONYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (332, '42208', 'ILGIN VD', 'KONYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (333, '42209', 'KULU VD', 'KONYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (334, '42251', 'SELÇUK VD', 'KONYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (335, '42252', 'MEVLANA VD', 'KONYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (336, '42253', 'MERAM VD', 'KONYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (337, '42254', 'ALAADDİN VD', 'KONYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (338, '43110', 'ŞAPHANE MAL MÜDR.', 'KÜTAHYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (339, '43201', '30 AĞUSTOS VD', 'KÜTAHYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (340, '43260', 'GEDİZ VD', 'KÜTAHYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (341, '43261', 'SİMAV VD', 'KÜTAHYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (342, '43262', 'TAVŞANLI VD', 'KÜTAHYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (343, '43280', 'ÇİNİLİ VD', 'KÜTAHYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (344, '44251', 'FIRAT VD', 'MALATYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (345, '44252', 'BEYDAĞI VD', 'MALATYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (346, '45114', 'GÖLMARMARA MAL MÜD', 'MANİSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (347, '45201', 'AKHİSAR VD', 'MANİSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (348, '45202', 'ALAŞEHİR VD', 'MANİSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (349, '45204', 'KIRKAĞAÇ VD', 'MANİSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (350, '45205', 'SALİHLİ ADİL ORAL VD', 'MANİSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (351, '45207', 'SARUHANLI VD', 'MANİSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (352, '45208', 'SOMA VD', 'MANİSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (353, '45209', 'TURGUTLU VD', 'MANİSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (354, '45210', 'GÖRDES VD', 'MANİSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (355, '45211', 'KULA VD', 'MANİSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (356, '45251', 'ALAYBEY VD', 'MANİSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (357, '45252', 'MESİR VD', 'MANİSA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (358, '46201', 'ASLANBEY VD', 'K.MARAŞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (359, '46280', 'AKSU VD', 'K.MARAŞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (360, '47260', 'MARDİN VD', 'MARDİN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (361, '47261', 'KIZILTEPE VD', 'MARDİN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (362, '48110', 'ORTACA MAL MÜD', 'MUĞLA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (363, '48260', 'MUĞLA VD', 'MUĞLA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (364, '48261', 'BODRUM VD', 'MUĞLA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (365, '48262', 'FETHİYE VD', 'MUĞLA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (366, '48264', 'MİLAS VD', 'MUĞLA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (367, '48265', 'MARMARİS VD', 'MUĞLA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (368, '48266', 'YATAĞAN VD', 'MUĞLA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (369, '49105', 'KORKUT MAL MÜDÜRL.', 'MUŞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (370, '49260', 'MUŞ VD', 'MUŞ', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (371, '50101', 'AVANOS MAL MÜD', 'NEVŞEHİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (372, '50106', 'ÜRGÜP MAL MÜD', 'NEVŞEHİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (373, '50260', 'NEVŞEHİR VD', 'NEVŞEHİR', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (374, '51260', 'NİĞDE VD', 'NİĞDE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (375, '52201', 'BOZTEPE VD', 'ORDU', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (376, '52260', 'KÖPRÜBAŞI VD', 'ORDU', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (377, '52261', 'FATSA VD', 'ORDU', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (378, '52262', 'ÜNYE VD', 'ORDU', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (379, '53201', 'KAÇKAR VD', 'RİZE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (380, '53260', 'YEŞİLÇAY VD', 'RİZE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (381, '53261', 'ÇAYELİ VD', 'RİZE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (382, '53262', 'PAZAR VD', 'RİZE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (383, '53263', 'ARDEŞEN VD', 'RİZE', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (384, '54105', 'KAYNARCA VD', 'SAKARYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (385, '54107', 'KOCAALİ MAL MÜD', 'SAKARYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (386, '54108', 'PAMUKOVA MAL MÜD', 'SAKARYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (387, '54201', 'AKYAZI VD', 'SAKARYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (388, '54251', 'GÜMRÜKÖNÜ VD', 'SAKARYA', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (389, '55101', 'ALAÇAM MAL MÜD', 'SAMSUN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (390, '55110', '19 MAYIS MAL MÜD', 'SAMSUN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (391, '55114', 'YAKAKENT MD', 'SAMSUN', 178);
INSERT INTO L_TAXOFFICE (LOGICALREF, CODE, NAME, ADDR1, CNTRNR) VALUES (392, '55202', 'BAFRA VD', 'SAMSUN', 178);

COMMIT WORK;

İyi çalışmalar.
Kullanıcı avatarı
şimal
Kıdemli Üye
Mesajlar: 516
Kayıt: 10 Kas 2003 09:36
Konum: ANKARA

Mesaj gönderen şimal »

çok sağolun hakikaten arşivlik :)
Boş Başak Dik Durur...
Santranç bitince şah da piyon da aynı torbaya girermiş...
Cevapla