Advertisement
Guest User

Untitled

a guest
Feb 20th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.97 KB | None | 0 0
  1. CREATE TABLE `cities` (
  2. `id` Int( 11 ) AUTO_INCREMENT NOT NULL,
  3. `name` VarChar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
  4. PRIMARY KEY ( `id` ) )
  5. CHARACTER SET = utf8
  6. COLLATE = utf8_unicode_ci
  7. AUTO_INCREMENT = 82;
  8.  
  9. INSERT INTO `cities` (`id`,`name`) VALUES ( 1,'Adana' );
  10. INSERT INTO `cities` (`id`,`name`) VALUES ( 2,'Adıyaman' );
  11. INSERT INTO `cities` (`id`,`name`) VALUES ( 3,'Afyonkarahisar' );
  12. INSERT INTO `cities` (`id`,`name`) VALUES ( 4,'Ağrı' );
  13. INSERT INTO `cities` (`id`,`name`) VALUES ( 5,'Amasya' );
  14. INSERT INTO `cities` (`id`,`name`) VALUES ( 6,'Ankara' );
  15. INSERT INTO `cities` (`id`,`name`) VALUES ( 7,'Antalya' );
  16. INSERT INTO `cities` (`id`,`name`) VALUES ( 8,'Artvin' );
  17. INSERT INTO `cities` (`id`,`name`) VALUES ( 9,'Aydın' );
  18. INSERT INTO `cities` (`id`,`name`) VALUES ( 10,'Balıkesir' );
  19. INSERT INTO `cities` (`id`,`name`) VALUES ( 11,'Bilecik' );
  20. INSERT INTO `cities` (`id`,`name`) VALUES ( 12,'Bingöl' );
  21. INSERT INTO `cities` (`id`,`name`) VALUES ( 13,'Bitlis' );
  22. INSERT INTO `cities` (`id`,`name`) VALUES ( 14,'Bolu' );
  23. INSERT INTO `cities` (`id`,`name`) VALUES ( 15,'Burdur' );
  24. INSERT INTO `cities` (`id`,`name`) VALUES ( 16,'Bursa' );
  25. INSERT INTO `cities` (`id`,`name`) VALUES ( 17,'Çanakkale' );
  26. INSERT INTO `cities` (`id`,`name`) VALUES ( 18,'Çankırı' );
  27. INSERT INTO `cities` (`id`,`name`) VALUES ( 19,'Çorum' );
  28. INSERT INTO `cities` (`id`,`name`) VALUES ( 20,'Denizli' );
  29. INSERT INTO `cities` (`id`,`name`) VALUES ( 21,'Diyarbakır' );
  30. INSERT INTO `cities` (`id`,`name`) VALUES ( 22,'Edirne' );
  31. INSERT INTO `cities` (`id`,`name`) VALUES ( 23,'Elazığ' );
  32. INSERT INTO `cities` (`id`,`name`) VALUES ( 24,'Erzincan' );
  33. INSERT INTO `cities` (`id`,`name`) VALUES ( 25,'Erzurum' );
  34. INSERT INTO `cities` (`id`,`name`) VALUES ( 26,'Eskişehir' );
  35. INSERT INTO `cities` (`id`,`name`) VALUES ( 27,'Gaziantep' );
  36. INSERT INTO `cities` (`id`,`name`) VALUES ( 28,'Giresun' );
  37. INSERT INTO `cities` (`id`,`name`) VALUES ( 29,'Gümüşhane' );
  38. INSERT INTO `cities` (`id`,`name`) VALUES ( 30,'Hakkari' );
  39. INSERT INTO `cities` (`id`,`name`) VALUES ( 31,'Hatay' );
  40. INSERT INTO `cities` (`id`,`name`) VALUES ( 32,'Isparta' );
  41. INSERT INTO `cities` (`id`,`name`) VALUES ( 33,'Mersin' );
  42. INSERT INTO `cities` (`id`,`name`) VALUES ( 34,'İstanbul' );
  43. INSERT INTO `cities` (`id`,`name`) VALUES ( 35,'İzmir' );
  44. INSERT INTO `cities` (`id`,`name`) VALUES ( 36,'Kars' );
  45. INSERT INTO `cities` (`id`,`name`) VALUES ( 37,'Kastamonu' );
  46. INSERT INTO `cities` (`id`,`name`) VALUES ( 38,'Kayseri' );
  47. INSERT INTO `cities` (`id`,`name`) VALUES ( 39,'Kırklareli' );
  48. INSERT INTO `cities` (`id`,`name`) VALUES ( 40,'Kırşehir' );
  49. INSERT INTO `cities` (`id`,`name`) VALUES ( 41,'Kocaeli' );
  50. INSERT INTO `cities` (`id`,`name`) VALUES ( 42,'Konya' );
  51. INSERT INTO `cities` (`id`,`name`) VALUES ( 43,'Kütahya' );
  52. INSERT INTO `cities` (`id`,`name`) VALUES ( 44,'Malatya' );
  53. INSERT INTO `cities` (`id`,`name`) VALUES ( 45,'Manisa' );
  54. INSERT INTO `cities` (`id`,`name`) VALUES ( 46,'Kahramanmaraş' );
  55. INSERT INTO `cities` (`id`,`name`) VALUES ( 47,'Mardin' );
  56. INSERT INTO `cities` (`id`,`name`) VALUES ( 48,'Muğla' );
  57. INSERT INTO `cities` (`id`,`name`) VALUES ( 49,'Muş' );
  58. INSERT INTO `cities` (`id`,`name`) VALUES ( 50,'Nevşehir' );
  59. INSERT INTO `cities` (`id`,`name`) VALUES ( 51,'Niğde' );
  60. INSERT INTO `cities` (`id`,`name`) VALUES ( 52,'Ordu' );
  61. INSERT INTO `cities` (`id`,`name`) VALUES ( 53,'Rize' );
  62. INSERT INTO `cities` (`id`,`name`) VALUES ( 54,'Sakarya' );
  63. INSERT INTO `cities` (`id`,`name`) VALUES ( 55,'Samsun' );
  64. INSERT INTO `cities` (`id`,`name`) VALUES ( 56,'Siirt' );
  65. INSERT INTO `cities` (`id`,`name`) VALUES ( 57,'Sinop' );
  66. INSERT INTO `cities` (`id`,`name`) VALUES ( 58,'Sivas' );
  67. INSERT INTO `cities` (`id`,`name`) VALUES ( 59,'Tekirdağ' );
  68. INSERT INTO `cities` (`id`,`name`) VALUES ( 60,'Tokat' );
  69. INSERT INTO `cities` (`id`,`name`) VALUES ( 61,'Trabzon' );
  70. INSERT INTO `cities` (`id`,`name`) VALUES ( 62,'Tunceli' );
  71. INSERT INTO `cities` (`id`,`name`) VALUES ( 63,'Şanlıurfa' );
  72. INSERT INTO `cities` (`id`,`name`) VALUES ( 64,'Uşak' );
  73. INSERT INTO `cities` (`id`,`name`) VALUES ( 65,'Van' );
  74. INSERT INTO `cities` (`id`,`name`) VALUES ( 66,'Yozgat' );
  75. INSERT INTO `cities` (`id`,`name`) VALUES ( 67,'Zonguldak' );
  76. INSERT INTO `cities` (`id`,`name`) VALUES ( 68,'Aksaray' );
  77. INSERT INTO `cities` (`id`,`name`) VALUES ( 69,'Bayburt' );
  78. INSERT INTO `cities` (`id`,`name`) VALUES ( 70,'Karaman' );
  79. INSERT INTO `cities` (`id`,`name`) VALUES ( 71,'Kırıkkale' );
  80. INSERT INTO `cities` (`id`,`name`) VALUES ( 72,'Batman' );
  81. INSERT INTO `cities` (`id`,`name`) VALUES ( 73,'Şırnak' );
  82. INSERT INTO `cities` (`id`,`name`) VALUES ( 74,'Bartın' );
  83. INSERT INTO `cities` (`id`,`name`) VALUES ( 75,'Ardahan' );
  84. INSERT INTO `cities` (`id`,`name`) VALUES ( 76,'Iğdır' );
  85. INSERT INTO `cities` (`id`,`name`) VALUES ( 77,'Yalova' );
  86. INSERT INTO `cities` (`id`,`name`) VALUES ( 78,'Karabük' );
  87. INSERT INTO `cities` (`id`,`name`) VALUES ( 79,'Kilis' );
  88. INSERT INTO `cities` (`id`,`name`) VALUES ( 80,'Osmaniye' );
  89. INSERT INTO `cities` (`id`,`name`) VALUES ( 81,'Düzce' );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement