Letakkan berkas disini

SQL upload ( 0 ) x -

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
SELECT * FROM `pma__table_uiprefs` ORDER BY `prefs`  ASC
[ Edit dikotak ] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan ]
|
|
|
|
Saring baris:
Sort by key:
Teks penuh username db_name table_name prefs Menaik Menurun 1 last_update
Ubah Ubah Salin Salin Hapus 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`.`DESCRIPTION` ASC"...
2026-01-08 11:56:25
Ubah Ubah Salin Salin Hapus 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` = \'CHECK_CONSTRAINTS\'
 		root information_schema CHECK_CONSTRAINTS 
{"sorted_col":"`CHECK_CONSTRAINTS`.`CHECK_CLAUSE` ...
2026-01-08 11:55:47
Ubah Ubah Salin Salin Hapus 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`.`IS_DEFAULT` ASC"}
2026-01-08 12:03:36
Ubah Ubah Salin Salin Hapus 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` = \'COLLATION_CHARACTER_SET_APPLICABILITY\'
 		root information_schema COLLATION_CHARACTER_SET_APPLICABILITY 
{"sorted_col":"`COLLATION_CHARACTER_SET_APPLICABIL...
2026-01-08 10:48:18
Ubah Ubah Salin Salin Hapus 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` = \'COLUMNS\'
 		root information_schema COLUMNS 
{"sorted_col":"`COLUMNS`.`COLUMN_COMMENT`  ASC"}
2026-01-08 10:10:23
Ubah Ubah Salin Salin Hapus 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` = \'ENABLED_ROLES\'
 		root information_schema ENABLED_ROLES 
{"sorted_col":"`ENABLED_ROLES`.`ROLE_NAME`  ASC"}
2026-01-08 04:41:25
Ubah Ubah Salin Salin Hapus 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` = \'ENGINES\'
 		root information_schema ENGINES 
{"sorted_col":"`ENGINES`.`COMMENT`  ASC"}
2026-01-08 11:38:41
Ubah Ubah Salin Salin Hapus 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` = \'GLOBAL_STATUS\'
 		root information_schema GLOBAL_STATUS 
{"sorted_col":"`GLOBAL_STATUS`.`VARIABLE_VALUE`  D...
2026-01-08 06:53:32
Ubah Ubah Salin Salin Hapus 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` = \'GLOBAL_VARIABLES\'
 		root information_schema GLOBAL_VARIABLES 
{"sorted_col":"`GLOBAL_VARIABLES`.`VARIABLE_NAME` ...
2026-01-08 11:57:28
Ubah Ubah Salin Salin Hapus 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-01-08 11:05:39
Ubah Ubah Salin Salin Hapus 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\'
 		root information_schema INNODB_BUFFER_PAGE 
{"sorted_col":"`INNODB_BUFFER_PAGE`.`OLDEST_MODIFI...
2026-01-08 06:58:54
Ubah Ubah Salin Salin Hapus 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_POOL_STATS\'
 		root information_schema INNODB_BUFFER_POOL_STATS 
{"sorted_col":"`INNODB_BUFFER_POOL_STATS`.`POOL_ID...
2026-01-08 04:01:51
Ubah Ubah Salin Salin Hapus 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_CMPMEM_RESET\'
 		root information_schema INNODB_CMPMEM_RESET 
{"sorted_col":"`INNODB_CMPMEM_RESET`.`pages_used` ...
2026-01-08 07:09:10
Ubah Ubah Salin Salin Hapus 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_CMPMEM\'
 		root information_schema INNODB_CMPMEM 
{"sorted_col":"`INNODB_CMPMEM`.`relocation_ops`  A...
2026-01-08 06:48:20
Ubah Ubah Salin Salin Hapus 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_CMP_RESET\'
 		root information_schema INNODB_CMP_RESET 
{"sorted_col":"`INNODB_CMP_RESET`.`compress_ops_ok...
2026-01-08 08:43:45
Ubah Ubah Salin Salin Hapus 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_CMP\'
 		root information_schema INNODB_CMP 
{"sorted_col":"`INNODB_CMP`.`compress_ops`  ASC"}
2026-01-08 02:32:40
Ubah Ubah Salin Salin Hapus 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_FT_DEFAULT_STOPWORD\'
 		root information_schema INNODB_FT_DEFAULT_STOPWORD 
{"sorted_col":"`INNODB_FT_DEFAULT_STOPWORD`.`value...
2026-01-08 01:09:25
Ubah Ubah Salin Salin Hapus 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_METRICS\'
 		root information_schema INNODB_METRICS 
{"sorted_col":"`INNODB_METRICS`.`SUBSYSTEM` ASC"}
2026-01-08 11:43:42
Ubah Ubah Salin Salin Hapus 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_MUTEXES\'
 		root information_schema INNODB_MUTEXES 
{"sorted_col":"`INNODB_MUTEXES`.`NAME`  ASC"}
2026-01-08 07:15:17
Ubah Ubah Salin Salin Hapus 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_COLUMNS\'
 		root information_schema INNODB_SYS_COLUMNS 
{"sorted_col":"`INNODB_SYS_COLUMNS`.`POS`  ASC"}
2026-01-08 10:53:33
Ubah Ubah Salin Salin Hapus 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_DATAFILES\'
 		root information_schema INNODB_SYS_DATAFILES 
{"sorted_col":"`INNODB_SYS_DATAFILES`.`PATH`  ASC"...
2026-01-08 10:41:53
Ubah Ubah Salin Salin Hapus 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_FIELDS\'
 		root information_schema INNODB_SYS_FIELDS 
{"sorted_col":"`INNODB_SYS_FIELDS`.`POS`  ASC"}
2026-01-08 03:57:34
Ubah Ubah Salin Salin Hapus 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_INDEXES\'
 		root information_schema INNODB_SYS_INDEXES 
{"sorted_col":"`INNODB_SYS_INDEXES`.`TABLE_ID`  AS...
2026-01-08 10:17:43
Ubah Ubah Salin Salin Hapus 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_TABLESPACES\'
 		root information_schema INNODB_SYS_TABLESPACES 
{"sorted_col":"`INNODB_SYS_TABLESPACES`.`SPACE`  A...
2026-01-08 11:51:44
Ubah Ubah Salin Salin Hapus 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_TABLESTATS\'
 		root information_schema INNODB_SYS_TABLESTATS 
{"sorted_col":"`INNODB_SYS_TABLESTATS`.`STATS_INIT...
2026-01-08 11:57:44
Dengan pilihan: Dengan pilihan:
|
|
|
|
Saring baris:
Sort by key:
Operasi hasil kueri Cetak Cetak Salin ke clipboard Salin ke clipboard Ekspor Ekspor Tampilkan bagan Tampilkan bagan Buat tampilan Buat tampilan
Markahi kueri SQL ini Markahi kueri SQL ini