Letakkan berkas disini

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Basis data: phpmyadmin »Tabel: pma__table_uiprefs"Tables' UI preferences"
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 100, Pencarian dilakukan dalam 0,0036 detik.) [prefs: [BLOB - 61 B]... - [BLOB - 47 B]...]
SELECT * FROM `pma__table_uiprefs` ORDER BY `prefs`  ASC
[Edit dikotak] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan]
|
|
|
|
Jumlah baris:
Saring baris:
Sort by key:
Teks penuh usernamedb_nametable_nameprefs Menaik Menurun 1last_update
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'information_schema\' AND `pma__table_uiprefs`.`table_name` = \'CHARACTER_SETS\'
root information_schema CHARACTER_SETS 
{"sorted_col":"`CHARACTER_SETS`.`DEFAULT_COLLATE_N...
2026-05-11 00:51:54
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'information_schema\' AND `pma__table_uiprefs`.`table_name` = \'COLLATIONS\'
root information_schema COLLATIONS 
{"sorted_col":"`COLLATIONS`.`CHARACTER_SET_NAME`  ...
2026-05-11 00:24:25
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'information_schema\' AND `pma__table_uiprefs`.`table_name` = \'INNODB_BUFFER_PAGE_LRU\'
root information_schema INNODB_BUFFER_PAGE_LRU 
{"sorted_col":"`INNODB_BUFFER_PAGE_LRU`.`IO_FIX`  ...
2026-05-11 00:30:02
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'information_schema\' AND `pma__table_uiprefs`.`table_name` = \'INNODB_SYS_FOREIGN_COLS\'
root information_schema INNODB_SYS_FOREIGN_COLS 
{"sorted_col":"`INNODB_SYS_FOREIGN_COLS`.`REF_COL_...
2026-05-10 23:58:34
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'information_schema\' AND `pma__table_uiprefs`.`table_name` = \'PARTITIONS\'
root information_schema PARTITIONS 
{"sorted_col":"`PARTITIONS`.`TABLE_ROWS`  ASC"}
2026-05-10 23:45:07
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'information_schema\' AND `pma__table_uiprefs`.`table_name` = \'PROCESSLIST\'
root information_schema PROCESSLIST 
{"sorted_col":"`PROCESSLIST`.`INFO`  ASC"}
2026-05-10 23:45:21
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'information_schema\' AND `pma__table_uiprefs`.`table_name` = \'REFERENTIAL_CONSTRAINTS\'
root information_schema REFERENTIAL_CONSTRAINTS 
{"sorted_col":"`REFERENTIAL_CONSTRAINTS`.`CONSTRAI...
2026-05-11 00:19:16
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'information_schema\' AND `pma__table_uiprefs`.`table_name` = \'SCHEMATA\'
root information_schema SCHEMATA 
{"sorted_col":"`SCHEMATA`.`SQL_PATH`  DESC"}
2026-05-21 08:21:31
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'information_schema\' AND `pma__table_uiprefs`.`table_name` = \'STATISTICS\'
root information_schema STATISTICS 
{"sorted_col":"`STATISTICS`.`INDEX_TYPE`  ASC"}
2026-05-10 23:45:19
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mtsalfaaizun\' AND `pma__table_uiprefs`.`table_name` = \'buku_induk\'
root mtsalfaaizun buku_induk 
{"sorted_col":"`buku_induk`.`wn_ibu`  ASC"}
2026-05-11 00:17:01
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mtsalfaaizun\' AND `pma__table_uiprefs`.`table_name` = \'cbt_bank_soal\'
root mtsalfaaizun cbt_bank_soal 
{"sorted_col":"`cbt_bank_soal`.`bobot_jodohkan`  A...
2026-05-11 00:29:46
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mtsalfaaizun\' AND `pma__table_uiprefs`.`table_name` = \'cbt_jadwal\'
root mtsalfaaizun cbt_jadwal 
{"sorted_col":"`cbt_jadwal`.`id_bank`  ASC"}
2026-05-11 00:16:46
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mtsalfaaizun\' AND `pma__table_uiprefs`.`table_name` = \'cbt_nilai\'
root mtsalfaaizun cbt_nilai 
{"sorted_col":"`cbt_nilai`.`id_jadwal`  ASC"}
2026-05-11 00:17:16
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mtsalfaaizun\' AND `pma__table_uiprefs`.`table_name` = \'cbt_rekap_nilai\'
root mtsalfaaizun cbt_rekap_nilai 
{"sorted_col":"`cbt_rekap_nilai`.`id_smt`  ASC"}
2026-05-11 00:30:08
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mtsalfaaizun\' AND `pma__table_uiprefs`.`table_name` = \'cbt_rekap\'
root mtsalfaaizun cbt_rekap 
{"sorted_col":"`cbt_rekap`.`id_jenis`  ASC"}
2026-05-11 00:30:30
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mtsalfaaizun\' AND `pma__table_uiprefs`.`table_name` = \'cbt_sesi_siswa\'
root mtsalfaaizun cbt_sesi_siswa 
{"sorted_col":"`cbt_sesi_siswa`.`kelas_id`  ASC"}
2026-05-11 00:08:03
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mtsalfaaizun\' AND `pma__table_uiprefs`.`table_name` = \'cbt_soal_siswa\'
root mtsalfaaizun cbt_soal_siswa 
{"sorted_col":"`cbt_soal_siswa`.`soal_end`  ASC"}
2026-05-11 00:25:39
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mtsalfaaizun\' AND `pma__table_uiprefs`.`table_name` = \'cbt_soal\'
root mtsalfaaizun cbt_soal 
{"sorted_col":"`cbt_soal`.`tipe_file`  ASC"}
2026-05-11 00:30:42
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mysql\' AND `pma__table_uiprefs`.`table_name` = \'db\'
root mysql db 
{"sorted_col":"`db`.`Create_priv`  ASC"}
2026-05-11 02:11:53
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mis_ale\' AND `pma__table_uiprefs`.`table_name` = \'e_absenwalas\'
root mis_ale e_absenwalas 
{"sorted_col":"`e_absenwalas`.`absen_berat`  ASC"}
2026-05-11 00:06:22
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mis_cabalu\' AND `pma__table_uiprefs`.`table_name` = \'e_absenwalas\'
root mis_cabalu e_absenwalas 
{"sorted_col":"`e_absenwalas`.`absen_i`  ASC"}
2026-05-10 23:43:07
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mis_congko\' AND `pma__table_uiprefs`.`table_name` = \'e_absenwalas\'
root mis_congko e_absenwalas 
{"sorted_col":"`e_absenwalas`.`absen_i`  ASC"}
2026-05-10 23:40:39
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mis_congko\' AND `pma__table_uiprefs`.`table_name` = \'e_binaekstra\'
root mis_congko e_binaekstra 
{"sorted_col":"`e_binaekstra`.`guru_id`  ASC"}
2026-05-11 00:16:15
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mis_lemoape\' AND `pma__table_uiprefs`.`table_name` = \'e_binaekstra\'
root mis_lemoape e_binaekstra 
{"sorted_col":"`e_binaekstra`.`semester_id`  ASC"}
2026-05-11 00:06:43
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `pma__table_uiprefs` WHERE `pma__table_uiprefs`.`username` = \'root\' AND `pma__table_uiprefs`.`db_name` = \'mis_congko\' AND `pma__table_uiprefs`.`table_name` = \'e_extrasiswa\'
root mis_congko e_extrasiswa 
{"sorted_col":"`e_extrasiswa`.`kelas_id`  ASC"}
2026-05-11 00:08:04
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