Letakkan berkas disini

SQL upload ( 0 ) x -

Server: localhost »Basis data: sidokar_db »Tabel: location_city
Pengaturan Terkait dengan Halaman Klik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueri Press Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan Buka Show trace Hide trace Jumlah Time taken
Bookmark
Segarkan
Tambah
Tidak ada penanda
Tambah bookmark
Opsi
Kembalikan nilai bawaan





Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data : Waktu eksekusi kueri :

Modus jelajah

Atur mode jelajah.

Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya.
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya.
Dokumentasi Whether a user should be displayed a "show all (rows)" button.
Dokumentasi Jumlah baris yang ditampilkan saat browsing hasil set. Jika hasil set berisi lebih dari satu baris, tautan "Previous" and "Next" akan ditampilkan.
Dokumentasi SMART - yaitu urutan untuk kolom jenis TIME, DATE, DATETIME dan TIMESTAMP, urutan ascending dan sebaliknya.
Dokumentasi Sorot baris yang ditunjuk dengan kursor mouse.
Dokumentasi Sorot baris terpilih.
Dokumentasi
Dokumentasi
Dokumentasi Ulangi header setiap X sel, 0 menonaktifkan fitur ini.
Dokumentasi Jumlah maksimum karakter yang ditunjukkan pada kolom non-angka pada mode jelajah.
Dokumentasi Berikut ini adalah tautan Edit, Salin, dan Hapus.
Dokumentasi Apakah untuk menampilkan link baris bahkan tanpa adanya unique key.
Dokumentasi Default sort order for tables with a primary key.
Dokumentasi Saat browsing tabel, penyortiran setiap tabel akan diingat.
Dokumentasi Untuk pengaturan tampilan
Menampilkan baris 0 - 24 (total 514, Pencarian dilakukan dalam 0.0007 detik.) [city_id: 1... - 25...]
SELECT * FROM `location_city` ORDER BY `city_id`  ASC
[Edit dikotak] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan]
|
|
|
Jumlah baris:
Saring baris:
Sort by key:
Teks penuh city_id Menaik Menurun 1city_province_codecity_province_namecity_codecity_name
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 1 AND `location_city`.`city_code` = \'1101\'
1 11 Aceh 1101 Simeulue
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 2 AND `location_city`.`city_code` = \'1102\'
2 11 Aceh 1102 Aceh Singkil
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 3 AND `location_city`.`city_code` = \'1103\'
3 11 Aceh 1103 Aceh Selatan
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 4 AND `location_city`.`city_code` = \'1104\'
4 11 Aceh 1104 Aceh Tenggara
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 5 AND `location_city`.`city_code` = \'1105\'
5 11 Aceh 1105 Aceh Timur
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 6 AND `location_city`.`city_code` = \'1106\'
6 11 Aceh 1106 Aceh Tengah
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 7 AND `location_city`.`city_code` = \'1107\'
7 11 Aceh 1107 Aceh Barat
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 8 AND `location_city`.`city_code` = \'1108\'
8 11 Aceh 1108 Aceh Besar
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 9 AND `location_city`.`city_code` = \'1109\'
9 11 Aceh 1109 Pidie
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 10 AND `location_city`.`city_code` = \'1110\'
10 11 Aceh 1110 Bireuen
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 11 AND `location_city`.`city_code` = \'1111\'
11 11 Aceh 1111 Aceh Utara
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 12 AND `location_city`.`city_code` = \'1112\'
12 11 Aceh 1112 Aceh Barat Daya
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 13 AND `location_city`.`city_code` = \'1113\'
13 11 Aceh 1113 Gayo Lues
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 14 AND `location_city`.`city_code` = \'1114\'
14 11 Aceh 1114 Aceh Tamiang
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 15 AND `location_city`.`city_code` = \'1115\'
15 11 Aceh 1115 Nagan Raya
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 16 AND `location_city`.`city_code` = \'1116\'
16 11 Aceh 1116 Aceh Jaya
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 17 AND `location_city`.`city_code` = \'1117\'
17 11 Aceh 1117 Bener Meriah
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 18 AND `location_city`.`city_code` = \'1118\'
18 11 Aceh 1118 Pidie Jaya
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 19 AND `location_city`.`city_code` = \'1171\'
19 11 Aceh 1171 Kota Banda Aceh
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 20 AND `location_city`.`city_code` = \'1172\'
20 11 Aceh 1172 Kota Sabang
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 21 AND `location_city`.`city_code` = \'1173\'
21 11 Aceh 1173 Kota Langsa
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 22 AND `location_city`.`city_code` = \'1174\'
22 11 Aceh 1174 Kota Lhoksumawe
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 23 AND `location_city`.`city_code` = \'1175\'
23 11 Aceh 1175 Kota Subulussalam
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 24 AND `location_city`.`city_code` = \'1201\'
24 12 Sumatera Utara 1201 Nias
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_city` WHERE `location_city`.`city_id` = 25 AND `location_city`.`city_code` = \'1202\'
25 12 Sumatera Utara 1202 Mandailing Natal
Dengan pilihan: Dengan pilihan:
|
|
|
Jumlah baris:
Saring baris:
Sort by key:
Operasi hasil kueriCetak CetakSalin ke clipboard Salin ke clipboardEkspor EksporTampilkan bagan Tampilkan baganBuat tampilan Buat tampilan

Markahi kueri SQL ini Markahi kueri SQL ini