Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation 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
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `INNODB_SYS_COLUMNS` ORDER BY `MTYPE` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
TABLE_ID NAME POS MTYPE Descending Ascending 1 PRTYPE LEN
51 token 0 13 2949630 256
34 item_name 1 12 5439759 192
50 status 11 12 2949391 64
20 user 2 12 5443855 765
45 branch 19 12 2953231 320
27 master_table 1 12 5439759 192
35 username 1 12 5439759 192
50 direction 16 12 2949391 16
21 table_name 2 12 5439759 192
28 db_name 0 12 5439759 192
48 lap_time 5 12 2949135 96
36 col_name 1 12 5439759 192
50 vat_treatment 21 12 2949391 32
44 k 0 12 2953487 256
21 transformation_options 7 12 5443855 765
53 branch 5 12 2949391 192
46 posted_by 6 12 2953487 384
29 db_name 0 12 5439759 192
49 kart 2 12 2949391 128
36 col_extra 6 12 5443599 765
17 index_name 2 12 5439759 192
51 username 1 12 2953487 256
45 first 2 12 2953231 600
22 db 2 12 5439759 192
47 name 2 12 2953231 640
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query