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 :
Atur mode jelajah.
Modus jelajah
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya. Kembalikan nilai bawaan
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya. Kembalikan nilai bawaan
Dokumentasi Whether a user should be displayed a "show all (rows)" button. Kembalikan nilai bawaan
Dokumentasi Jumlah baris yang ditampilkan saat browsing hasil set. Jika hasil set berisi lebih dari satu baris, tautan "Previous" and "Next" akan ditampilkan. Kembalikan nilai bawaan
Dokumentasi SMART - yaitu urutan untuk kolom jenis TIME, DATE, DATETIME dan TIMESTAMP, urutan ascending dan sebaliknya. Kembalikan nilai bawaan
Dokumentasi Sorot baris yang ditunjuk dengan kursor mouse. Kembalikan nilai bawaan
Dokumentasi Sorot baris terpilih. Kembalikan nilai bawaan
Dokumentasi Kembalikan nilai bawaan
Dokumentasi Kembalikan nilai bawaan
Dokumentasi Ulangi header setiap X sel, 0 menonaktifkan fitur ini. Kembalikan nilai bawaan
Dokumentasi Jumlah maksimum karakter yang ditunjukkan pada kolom non-angka pada mode jelajah. Kembalikan nilai bawaan
Dokumentasi Berikut ini adalah tautan Edit, Salin, dan Hapus. Kembalikan nilai bawaan
Dokumentasi Apakah untuk menampilkan link baris bahkan tanpa adanya unique key. Kembalikan nilai bawaan
Dokumentasi Default sort order for tables with a primary key. Kembalikan nilai bawaan
Dokumentasi Saat browsing tabel, penyortiran setiap tabel akan diingat. Kembalikan nilai bawaan
Dokumentasi Untuk pengaturan tampilan Kembalikan nilai bawaan 
SELECT * FROM `SYSTEM_VARIABLES` ORDER BY `SESSION_VALUE` DESC
[ Edit dikotak ] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan ]
|
|
|
|
Saring baris:
VARIABLE_NAME SESSION_VALUE Menurun Menaik 1 GLOBAL_VALUE GLOBAL_VALUE_ORIGIN DEFAULT_VALUE VARIABLE_SCOPE VARIABLE_TYPE VARIABLE_COMMENT NUMERIC_MIN_VALUE NUMERIC_MAX_VALUE NUMERIC_BLOCK_SIZE ENUM_VALUE_LIST READ_ONLY COMMAND_LINE_ARGUMENT
UPDATABLE_VIEWS_WITH_LIMIT YES YES COMPILE-TIME YES SESSION ENUM YES = Don't issue an error message (warning only) ... NULL NULL NULL NO,YES NO REQUIRED
COLLATION_DATABASE utf8_general_ci utf8mb4_general_ci COMPILE-TIME utf8mb4_general_ci SESSION ENUM The collation of the database character set NULL NULL NULL NULL NO NULL
COLLATION_CONNECTION utf8mb4_unicode_ci utf8mb4_general_ci COMPILE-TIME utf8mb4_general_ci SESSION ENUM The collation of the connection character set NULL NULL NULL NULL NO NULL
COLLATION_SERVER utf8mb4_general_ci utf8mb4_general_ci COMPILE-TIME utf8mb4_general_ci SESSION ENUM The server default collation NULL NULL NULL NULL NO NULL
CHARACTER_SET_SERVER utf8mb4 utf8mb4 COMPILE-TIME utf8mb4 SESSION ENUM The default character set NULL NULL NULL NULL NO NULL
CHARACTER_SET_CONNECTION utf8mb4 utf8mb4 COMPILE-TIME utf8mb4 SESSION ENUM The character set used for literals that do not ha... NULL NULL NULL NULL NO NULL
CHARACTER_SET_RESULTS utf8mb4 utf8mb4 COMPILE-TIME utf8mb4 SESSION ENUM The character set used for returning query results... NULL NULL NULL NULL NO NULL
CHARACTER_SET_CLIENT utf8mb4 utf8mb4 COMPILE-TIME utf8mb4 SESSION ENUM The character set for statements that arrive from ... NULL NULL NULL NULL NO NULL
CHARACTER_SET_DATABASE utf8 utf8mb4 COMPILE-TIME utf8mb4 SESSION ENUM The character set used by the default database NULL NULL NULL NULL NO NULL
TIME_ZONE SYSTEM SYSTEM COMPILE-TIME SYSTEM SESSION VARCHAR The current time zone, used to initialize the time... NULL NULL NULL NULL NO NULL
LOG_SLOW_DISABLED_STATEMENTS sp sp COMPILE-TIME sp SESSION SET Don't log certain types of statements to slow log NULL NULL NULL admin,call,slave,sp NO REQUIRED
LOG_DISABLED_STATEMENTS sp sp COMPILE-TIME sp SESSION SET Don't log certain types of statements to general l... NULL NULL NULL slave,sp NO REQUIRED
TX_ISOLATION REPEATABLE-READ REPEATABLE-READ COMPILE-TIME REPEATABLE-READ SESSION ENUM Default transaction isolation level NULL NULL NULL READ-UNCOMMITTED,READ-COMMITTED,REPEATABLE-READ,SE... NO NULL
USE_STAT_TABLES PREFERABLY_FOR_QUERIES PREFERABLY_FOR_QUERIES COMPILE-TIME PREFERABLY_FOR_QUERIES SESSION ENUM Specifies how to use system statistics tables NULL NULL NULL NEVER,COMPLEMENTARY,PREFERABLY,COMPLEMENTARY_FOR_Q... NO REQUIRED
SQL_BIG_SELECTS ON ON COMPILE-TIME OFF SESSION BOOLEAN If set to 0, MariaDB will not perform large SELECT... NULL NULL NULL OFF,ON NO NULL
LOG_SLOW_SLAVE_STATEMENTS ON ON COMPILE-TIME ON SESSION BOOLEAN Log slow statements executed by slave thread to th... NULL NULL NULL OFF,ON NO OPTIONAL
STANDARD_COMPLIANT_CTE ON ON COMPILE-TIME ON SESSION BOOLEAN Allow only CTEs compliant to SQL standard NULL NULL NULL OFF,ON NO OPTIONAL
INNODB_STRICT_MODE ON ON COMPILE-TIME ON SESSION BOOLEAN Use strict mode when evaluating create options. NULL NULL NULL OFF,ON NO OPTIONAL
SQL_LOG_BIN ON ON COMPILE-TIME ON SESSION BOOLEAN If set to 0 (1 is the default), no logging to the ... NULL NULL NULL OFF,ON NO NULL
LOG_SLOW_ADMIN_STATEMENTS ON ON COMPILE-TIME ON SESSION BOOLEAN Log slow OPTIMIZE, ANALYZE, ALTER and other admini... NULL NULL NULL OFF,ON NO OPTIONAL
CHECK_CONSTRAINT_CHECKS ON ON COMPILE-TIME ON SESSION BOOLEAN check_constraint_checks NULL NULL NULL OFF,ON NO NULL
SQL_NOTES ON ON COMPILE-TIME ON SESSION BOOLEAN If set to 1, the default, warning_count is increme... NULL NULL NULL OFF,ON NO NULL
INNODB_FT_ENABLE_STOPWORD ON ON COMPILE-TIME ON SESSION BOOLEAN Create FTS index with stopword. NULL NULL NULL OFF,ON NO OPTIONAL
UNIQUE_CHECKS ON ON COMPILE-TIME ON SESSION BOOLEAN If set to 1, the default, secondary indexes in Inn... NULL NULL NULL OFF,ON NO NULL
FOREIGN_KEY_CHECKS ON ON COMPILE-TIME ON SESSION BOOLEAN If set to 1 (the default) foreign key constraints ... NULL NULL NULL OFF,ON NO NULL
|
|
|
|
Saring baris:
Operasi hasil kueri Salin ke clipboard Salin ke clipboard Ekspor Ekspor Tampilkan bagan Tampilkan bagan Buat tampilan Buat tampilan
Markahi kueri SQL ini Markahi kueri SQL ini