ניתן להשליך קבצים לכאן

SQL upload ( 0 ) x -

הגדרות תלויות עמוד Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
ניפוי שגיאות SQL
Count
Execution order
Time taken
Order by:
שאילתות קבוצתיות
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
רענון
הוספה
אין סימניות
Add bookmark
אפשרויות
Set default
Collapse Expand Requery עריכה Explain Profiling Bookmark Query failed מסד נתונים: Queried time:
מצב עיון
התאמת מצב עיון.
מצב עיון
תיעוד Use only icons, only text or both. Restore default value
תיעוד Use only icons, only text or both. Restore default value
תיעוד Whether a user should be displayed a "show all (rows)" button. Restore default value
תיעוד Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
תיעוד SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
תיעוד הדגשת שורות עליהן סמן העכבר מצביע. Restore default value
תיעוד הדגשת השורות הנבחרות. Restore default value
תיעוד Restore default value
תיעוד Restore default value
תיעוד Repeat the headers every X cells, 0 deactivates this feature. Restore default value
תיעוד Maximum number of characters shown in any non-numeric column on browse view. Restore default value
תיעוד These are Edit, Copy and Delete links. Restore default value
תיעוד Whether to show row links even in the absence of a unique key. Restore default value
תיעוד Default sort order for tables with a primary key. Restore default value
תיעוד When browsing tables, the sorting of each table is remembered. Restore default value
תיעוד לאפשרויות תצוגה Restore default value
SELECT * FROM `INNODB_BUFFER_PAGE`
POOL_ID BLOCK_ID SPACE PAGE_NUMBER PAGE_TYPE FLUSH_TYPE FIX_COUNT IS_HASHED NEWEST_MODIFICATION OLDEST_MODIFICATION ACCESS_TIME TABLE_NAME INDEX_NAME NUMBER_RECORDS DATA_SIZE COMPRESSED_SIZE PAGE_STATE IO_FIX IS_OLD FREE_PAGE_CLOCK
0 0 0 7 SYSTEM 1 0 NO 9662394 0 8469 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 1 0 3 SYSTEM 0 0 NO 0 0 8470 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 2 0 2 INODE 1 0 NO 9662284 0 8470 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 3 0 4 IBUF_INDEX 0 0 NO 0 0 8471 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 4 0 11 INDEX 1 0 NO 9665631 0 8472 `SYS_INDEXES` CLUST_IND 83 5960 0 FILE_PAGE IO_NONE YES 0
0 5 0 1 IBUF_BITMAP 0 0 NO 0 0 8473 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 6 0 5 TRX_SYSTEM 0 0 NO 0 0 8473 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 7 0 6 SYSTEM 1 0 NO 9561764 0 8474 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 8 0 301 UNDO_LOG 1 0 NO 9561764 0 8475 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 9 0 469 UNDO_LOG 0 0 NO 0 0 8476 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 10 0 45 SYSTEM 1 0 NO 9561803 0 8476 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 11 0 306 UNDO_LOG 1 0 NO 9561803 0 8477 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 12 0 513 UNDO_LOG 0 0 NO 0 0 8478 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 13 0 46 SYSTEM 1 0 NO 9561842 0 8479 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 14 0 309 UNDO_LOG 1 0 NO 9561842 0 8483 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 15 0 470 UNDO_LOG 0 0 NO 0 0 8484 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 16 0 47 SYSTEM 1 0 NO 9561881 0 8485 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 17 0 310 UNDO_LOG 1 0 NO 9561881 0 8486 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 18 0 514 UNDO_LOG 0 0 NO 0 0 8486 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 19 0 48 SYSTEM 1 0 NO 9561920 0 8487 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 20 0 560 UNDO_LOG 1 0 NO 9561920 0 8488 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 21 0 471 UNDO_LOG 0 0 NO 0 0 8489 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 22 0 49 SYSTEM 1 0 NO 9561959 0 8489 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 23 0 312 UNDO_LOG 1 0 NO 9561959 0 8490 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
0 24 0 515 UNDO_LOG 0 0 NO 0 0 8491 NULL NULL 0 0 0 FILE_PAGE IO_NONE YES 0
הכנס שאילתת SQL זאת למועדפים הכנס שאילתת SQL זאת למועדפים