SHARE
TWEET

Untitled

a guest Mar 15th, 2019 77 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE IF NOT EXISTS "Database_State_Sikirim" (
  2.     "id_kota" NUMERIC(4, 1),
  3.     "provinsi" TEXT,
  4.     "nama_kota" TEXT
  5. );
  6. INSERT INTO KOTA VALUES
  7.     (1,'Aceh','Banda Aceh'),
  8.     (2,'Aceh','Langsa'),
  9.     (3,'Aceh','Lhokseumawe'),
  10.     (4,'Aceh','Meulaboh'),
  11.     (5,'Aceh','Sabang'),
  12.     (6,'Aceh','Subulussalam'),
  13.     (7,'Bali','Denpasar'),
  14.     (8,'Bangka Belitung','Pangkalpinang'),
  15.     (9,'Banten','Cilegon'),
  16.     (10,'Banten','Serang'),
  17.     (11,'Banten','Tangerang Selatan'),
  18.     (12,'Banten','Tangerang'),
  19.     (13,'Bengkulu','Bengkulu'),
  20.     (14,'Gorontalo','Gorontalo'),
  21.     (15,'Jakarta','Kota Administrasi Jakarta Barat'),
  22.     (16,'Jakarta','Kota Administrasi Jakarta Pusat'),
  23.     (17,'Jakarta','Kota Administrasi Jakarta Selatan'),
  24.     (18,'Jakarta','Kota Administrasi Jakarta Timur'),
  25.     (19,'Jakarta','Kota Administrasi Jakarta Utara'),
  26.     (20,'Jambi','Sungai Penuh'),
  27.     (21,'Jambi','Jambi'),
  28.     (22,'Jawa Barat','Bandung'),
  29.     (23,'Jawa Barat','Bekasi'),
  30.     (24,'Jawa Barat','Bogor'),
  31.     (25,'Jawa Barat','Cimahi'),
  32.     (26,'Jawa Barat','Cirebon'),
  33.     (27,'Jawa Barat','Depok'),
  34.     (28,'Jawa Barat','Sukabumi'),
  35.     (29,'Jawa Barat','Tasikmalaya'),
  36.     (30,'Jawa Barat','Banjar'),
  37.     (31,'Jawa Tengah','Magelang'),
  38.     (32,'Jawa Tengah','Pekalongan'),
  39.     (33,'Jawa Tengah','Purwokerto'),
  40.     (34,'Jawa Tengah','Salatiga'),
  41.     (35,'Jawa Tengah','Semarang'),
  42.     (36,'Jawa Tengah','Surakarta'),
  43.     (37,'Jawa Tengah','Tegal'),
  44.     (38,'Jawa Timur','Batu'),
  45.     (39,'Jawa Timur','Blitar'),
  46.     (40,'Jawa Timur','Kediri'),
  47.     (41,'Jawa Timur','Madiun'),
  48.     (42,'Jawa Timur','Malang'),
  49.     (43,'Jawa Timur','Mojokerto'),
  50.     (44,'Jawa Timur','Pasuruan'),
  51.     (45,'Jawa Timur','Probolinggo'),
  52.     (46,'Jawa Timur','Surabaya'),
  53.     (47,'Kalimantan Barat','Pontianak'),
  54.     (48,'Kalimantan Barat','Singkawang'),
  55.     (49,'Kalimantan Selatan','Banjarbaru'),
  56.     (50,'Kalimantan Selatan','Banjarmasin'),
  57.     (51,'Kalimantan Tengah','Palangkaraya'),
  58.     (52,'Kalimantan Timur','Balikpapan'),
  59.     (53,'Kalimantan Timur','Bontang'),
  60.     (54,'Kalimantan Timur','Samarinda'),
  61.     (55,'Kalimantan Utara','Tarakan'),
  62.     (56,'Kepulauan Riau','Batam'),
  63.     (57,'Kepulauan Riau','Tanjungpinang'),
  64.     (58,'Lampung','Bandar Lampung'),
  65.     (59,'Lampung','Kotabumi'),
  66.     (60,'Lampung','Liwa'),
  67.     (61,'Lampung','Metro'),
  68.     (62,'Maluku Utara','Ternate'),
  69.     (63,'Maluku Utara','Tidore Kepulauan'),
  70.     (64,'Maluku','Ambon'),
  71.     (65,'Maluku','Tual'),
  72.     (66,'Nusa Tenggara Barat','Bima'),
  73.     (67,'Nusa Tenggara Barat','Mataram'),
  74.     (68,'Nusa Tenggara Timur','Kupang'),
  75.     (69,'Papua Barat','Sorong'),
  76.     (70,'Papua','Jayapura'),
  77.     (71,'Riau','Dumai'),
  78.     (72,'Riau','Pekanbaru'),
  79.     (73,'Sulawesi Selatan','Makassar'),
  80.     (74,'Sulawesi Selatan','Palopo'),
  81.     (75,'Sulawesi Selatan','Parepare'),
  82.     (76,'Sulawesi Tengah','Palu'),
  83.     (77,'Sulawesi Tenggara','Bau-Bau'),
  84.     (78,'Sulawesi Tenggara','Kendari'),
  85.     (79,'Sulawesi Utara','Bitung'),
  86.     (80,'Sulawesi Utara','Kotamobagu'),
  87.     (81,'Sulawesi Utara','Manado'),
  88.     (82,'Sulawesi Utara','Tomohon'),
  89.     (83,'Sumatera Barat','Bukittinggi'),
  90.     (84,'Sumatera Barat','Padang'),
  91.     (85,'Sumatera Barat','Padangpanjang'),
  92.     (86,'Sumatera Barat','Pariaman'),
  93.     (87,'Sumatera Barat','Payakumbuh'),
  94.     (88,'Sumatera Barat','Sawahlunto'),
  95.     (89,'Sumatera Barat','Solok'),
  96.     (90,'Sumatera Selatan','Lubuklinggau'),
  97.     (91,'Sumatera Selatan','Pagaralam'),
  98.     (92,'Sumatera Selatan','Palembang'),
  99.     (93,'Sumatera Selatan','Prabumulih'),
  100.     (94,'Sumatera Utara','Binjai'),
  101.     (95,'Sumatera Utara','Medan'),
  102.     (96,'Sumatera Utara','Padang Sidempuan'),
  103.     (97,'Sumatera Utara','Pematangsiantar'),
  104.     (98,'Sumatera Utara','Sibolga'),
  105.     (99,'Sumatera Utara','Tanjungbalai'),
  106.     (100,'Sumatera Utara','Tebingtinggi'),
  107.     (101,'Yogyakarta','Yogyakarta');
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top