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.0333 detik.) [village_district_code: 0000000... - 1101020...]
SELECT * FROM `location_village` ORDER BY `village_district_code`  ASC
[Edit dikotak] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan]
|
|
|
Jumlah baris:
Saring baris:
Sort by key:
Teks penuh village_idvillage_district_code Menaik Menurun 1village_codevillage_namevillage_postcode
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 69979 AND `location_village`.`village_code` = \'0000000000\'
69979 0000000 0000000000 - NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 90 AND `location_village`.`village_code` = \'1101010002\'
90 1101010 1101010002 LATIUNG NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 89 AND `location_village`.`village_code` = \'1101010001\'
89 1101010 1101010001 SUAK LAMATAN NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 91 AND `location_village`.`village_code` = \'1101010003\'
91 1101010 1101010003 LABUHAN BAJAU NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 92 AND `location_village`.`village_code` = \'1101010004\'
92 1101010 1101010004 ANA AO NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 94 AND `location_village`.`village_code` = \'1101010006\'
94 1101010 1101010006 PULAU BENGKALAK NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 93 AND `location_village`.`village_code` = \'1101010005\'
93 1101010 1101010005 LATALING NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 105 AND `location_village`.`village_code` = \'1101020012\'
105 1101020 1101020012 LEUBANG NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 95 AND `location_village`.`village_code` = \'1101020001\'
95 1101020 1101020001 MATAN URUNG NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 97 AND `location_village`.`village_code` = \'1101020003\'
97 1101020 1101020003 LANTING NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 100 AND `location_village`.`village_code` = \'1101020006\'
100 1101020 1101020006 NANCAWA NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 101 AND `location_village`.`village_code` = \'1101020007\'
101 1101020 1101020007 LABUAH NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 104 AND `location_village`.`village_code` = \'1101020010\'
104 1101020 1101020010 SITUBUK NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 103 AND `location_village`.`village_code` = \'1101020009\'
103 1101020 1101020009 BATU BATU NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 99 AND `location_village`.`village_code` = \'1101020005\'
99 1101020 1101020005 ABAIL NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 110 AND `location_village`.`village_code` = \'1101020017\'
110 1101020 1101020017 NANCALA NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 113 AND `location_village`.`village_code` = \'1101020020\'
113 1101020 1101020020 NAIBOS NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 107 AND `location_village`.`village_code` = \'1101020014\'
107 1101020 1101020014 LANTIK NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 111 AND `location_village`.`village_code` = \'1101020018\'
111 1101020 1101020018 MAUDIL NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 112 AND `location_village`.`village_code` = \'1101020019\'
112 1101020 1101020019 INOR NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 106 AND `location_village`.`village_code` = \'1101020013\'
106 1101020 1101020013 AWE SEBAL NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 108 AND `location_village`.`village_code` = \'1101020015\'
108 1101020 1101020015 AWE KECIL NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 109 AND `location_village`.`village_code` = \'1101020016\'
109 1101020 1101020016 SALUR NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 98 AND `location_village`.`village_code` = \'1101020004\'
98 1101020 1101020004 SIMPANG ABAIL NULL
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `location_village` WHERE `location_village`.`village_id` = 102 AND `location_village`.`village_code` = \'1101020008\'
102 1101020 1101020008 SUA SUA 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