Letakkan berkas disini

SQL upload ( 0 ) x -

Server: localhost »Basis data: sidokar_db »Tabel: location_village
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 70556, Pencarian dilakukan dalam 0.0393 detik.) [village_postcode: ... - ...]
SELECT * FROM `location_village` ORDER BY `village_postcode`  ASC
[Edit dikotak] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan]
|
|
|
Jumlah baris:
Saring baris:
Sort by key:
Teks penuh village_idvillage_district_codevillage_codevillage_namevillage_postcode Menaik Menurun 1
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 70577 AND `location_village`.`village_code` = \'6203004003\'
70577 6203004 6203004003 SEI PASAH NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 15 AND `location_village`.`village_code` = \'1103020005\'
15 1103020 1103020005 UJUNG PULO RAYEUK NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 16 AND `location_village`.`village_code` = \'1103020006\'
16 1103020 1103020006 PASI SEUBADEH NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 17 AND `location_village`.`village_code` = \'1103020007\'
17 1103020 1103020007 LADANG RIMBA NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 18 AND `location_village`.`village_code` = \'1103020008\'
18 1103020 1103020008 SIMPANG NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 19 AND `location_village`.`village_code` = \'1103020009\'
19 1103020 1103020009 SAWAH TINGKEUM NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 20 AND `location_village`.`village_code` = \'1103020010\'
20 1103020 1103020010 SEULEUKAT NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 21 AND `location_village`.`village_code` = \'1103020011\'
21 1103020 1103020011 SENEUBOK ALUR BULAH NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 22 AND `location_village`.`village_code` = \'1103020012\'
22 1103020 1103020012 UJUNG TANOH NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 23 AND `location_village`.`village_code` = \'1103020013\'
23 1103020 1103020013 UJUNG GUNUNG CUT NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 24 AND `location_village`.`village_code` = \'1103020014\'
24 1103020 1103020014 UJUNG PADANG NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 25 AND `location_village`.`village_code` = \'1103020015\'
25 1103020 1103020015 KMP DRIEN NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 14 AND `location_village`.`village_code` = \'1103020004\'
14 1103020 1103020004 UJUNG PULO CUT NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 13 AND `location_village`.`village_code` = \'1103020003\'
13 1103020 1103020003 KAMPUNG BARU NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 2 AND `location_village`.`village_code` = \'1103010022\'
2 1103010 1103010022 PINTO RIMBA NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 3 AND `location_village`.`village_code` = \'1103010023\'
3 1103010 1103010023 KRUNG LUAS NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 4 AND `location_village`.`village_code` = \'1103010024\'
4 1103010 1103010024 JAMBO DALEM NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 5 AND `location_village`.`village_code` = \'1103010025\'
5 1103010 1103010025 KAPAI SEUSAK NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 6 AND `location_village`.`village_code` = \'1103010026\'
6 1103010 1103010026 UPT I SNB PUSAKA NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 7 AND `location_village`.`village_code` = \'1103010027\'
7 1103010 1103010027 UPT II PD HARAPAN NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 8 AND `location_village`.`village_code` = \'1103010028\'
8 1103010 1103010028 UPT III COT BAYU NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 9 AND `location_village`.`village_code` = \'1103010029\'
9 1103010 1103010029 UPT IV IE JEUREUNEH NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 10 AND `location_village`.`village_code` = \'1103010030\'
10 1103010 1103010030 SEUNABOK JAYA (EX UPT V) NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 11 AND `location_village`.`village_code` = \'1103020001\'
11 1103020 1103020001 UJUNG MANGKI NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 12 AND `location_village`.`village_code` = \'1103020002\'
12 1103020 1103020002 KEUDE BAKONGAN NULL
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