xkare adlı üyeden alıntı: mesajı görüntüle
CREATE TABLE sehir (
id int(10) unsigned NOT NULL auto_increment,
sehir varchar(255) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) ;

INSERT INTO sehir VALUES("34", "Istanbul");
INSERT INTO sehir VALUES("6", "Ankara");
INSERT INTO sehir VALUES("35", "Izmir");
INSERT INTO sehir VALUES("1", "Adana");
INSERT INTO sehir VALUES("2", "Adıyaman");
INSERT INTO sehir VALUES("3", "Afyon");
INSERT INTO sehir VALUES("4", "Ağrı");
INSERT INTO sehir VALUES("68", "Aksaray");
INSERT INTO sehir VALUES("5", "Amasya");
INSERT INTO sehir VALUES("7", "Antalya");
INSERT INTO sehir VALUES("75", "Ardahan");
INSERT INTO sehir VALUES("8", "Artvin");
INSERT INTO sehir VALUES("9", "Aydın");
INSERT INTO sehir VALUES("10", "Balıkesir");
INSERT INTO sehir VALUES("74", "Bartın");
INSERT INTO sehir VALUES("72", "Batman");
INSERT INTO sehir VALUES("69", "Bayburt");
INSERT INTO sehir VALUES("11", "Bilecik");
INSERT INTO sehir VALUES("12", "Bingöl");
INSERT INTO sehir VALUES("13", "Bitlis");
INSERT INTO sehir VALUES("14", "Bolu");
INSERT INTO sehir VALUES("15", "Burdur");
INSERT INTO sehir VALUES("16", "Bursa");
INSERT INTO sehir VALUES("17", "Çanakkale");
INSERT INTO sehir VALUES("18", "Çankırı");
INSERT INTO sehir VALUES("19", "Çorum");
INSERT INTO sehir VALUES("20", "Denizli");
INSERT INTO sehir VALUES("21", "Diyarbakır");
INSERT INTO sehir VALUES("81", "Duzce");
INSERT INTO sehir VALUES("22", "Edirne");
INSERT INTO sehir VALUES("23", "Elazığ");
INSERT INTO sehir VALUES("24", "Erzincan");
INSERT INTO sehir VALUES("25", "Erzurum");
INSERT INTO sehir VALUES("26", "Eskişehir");
INSERT INTO sehir VALUES("27", "Gaziantep");
INSERT INTO sehir VALUES("28", "Giresun");
INSERT INTO sehir VALUES("29", "Gümüşhane");
INSERT INTO sehir VALUES("30", "Hakkari");
INSERT INTO sehir VALUES("31", "Hatay");
INSERT INTO sehir VALUES("76", "Iğdır");
INSERT INTO sehir VALUES("32", "Isparta");
INSERT INTO sehir VALUES("33", "Içel(Mersin)");
INSERT INTO sehir VALUES("78", "Karabük");
INSERT INTO sehir VALUES("70", "Karaman");
INSERT INTO sehir VALUES("36", "Kars");
INSERT INTO sehir VALUES("37", "Kastamonu");
INSERT INTO sehir VALUES("38", "Kayseri");
INSERT INTO sehir VALUES("71", "Kırıkkale");
INSERT INTO sehir VALUES("39", "Kırklareli");
INSERT INTO sehir VALUES("40", "Kırşehir");
INSERT INTO sehir VALUES("79", "Kilis");
INSERT INTO sehir VALUES("41", "Kocaeli");
INSERT INTO sehir VALUES("42", "Konya");
INSERT INTO sehir VALUES("43", "Kütahya");
INSERT INTO sehir VALUES("44", "Malatya");
INSERT INTO sehir VALUES("45", "Manisa");
INSERT INTO sehir VALUES("46", "Maraş");
INSERT INTO sehir VALUES("47", "Mardin");
INSERT INTO sehir VALUES("48", "Muğla");
INSERT INTO sehir VALUES("49", "Muş");
INSERT INTO sehir VALUES("50", "Nevşehir");
INSERT INTO sehir VALUES("51", "Niğde");
INSERT INTO sehir VALUES("52", "Ordu");
INSERT INTO sehir VALUES("80", "Osmaniye");
INSERT INTO sehir VALUES("53", "Rize");
INSERT INTO sehir VALUES("54", "Sakarya");
INSERT INTO sehir VALUES("55", "Samsun");
INSERT INTO sehir VALUES("56", "Siirt");
INSERT INTO sehir VALUES("57", "Sinop");
INSERT INTO sehir VALUES("58", "Sivas");
INSERT INTO sehir VALUES("73", "Sırnak");
INSERT INTO sehir VALUES("59", "Tekirdağ");
INSERT INTO sehir VALUES("60", "Tokat");
INSERT INTO sehir VALUES("61", "Trabzon");
INSERT INTO sehir VALUES("62", "Tunceli");
INSERT INTO sehir VALUES("63", "Urfa");
INSERT INTO sehir VALUES("64", "Uşak");
INSERT INTO sehir VALUES("65", "Van");
INSERT INTO sehir VALUES("77", "Yalova");
INSERT INTO sehir VALUES("66", "Yozgat");
INSERT INTO sehir VALUES("67", "Zonguldak");

db de hazır olarak daha çok işine yarar


Teşekkür Ettim