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_TABLES` ORDER BY `N_COLS` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
TABLE_ID NAME FLAG N_COLS Descending Ascending 1 SPACE ROW_FORMAT ZIP_PAGE_SIZE SPACE_TYPE
74 osticket_db/ost_staff 33 37 59 Dynamic 0 Single
83 osticket_db/ost_ticket 33 30 68 Dynamic 0 Single
56 osticket_db/ost_email_account 33 25 41 Dynamic 0 Single
80 osticket_db/ost_thread_entry 33 22 65 Dynamic 0 Single
68 osticket_db/ost_help_topic 33 22 53 Dynamic 0 Single
53 osticket_db/ost_department 33 21 38 Dynamic 0 Single
67 osticket_db/ost_schedule_entry 33 19 52 Dynamic 0 Single
86 osticket_db/ost_thread_event 33 17 71 Dynamic 0 Single
95 osticket_db/ost_queue 33 17 80 Dynamic 0 Single
57 osticket_db/ost_filter 33 16 42 Dynamic 0 Single
91 osticket_db/ost_task 33 16 76 Dynamic 0 Single
48 osticket_db/ost_form_field 33 14 33 Dynamic 0 Single
51 osticket_db/ost_list 33 13 36 Dynamic 0 Single
62 osticket_db/ost_file 33 13 47 Dynamic 0 Single
102 osticket_db/ost_translation 33 13 87 Dynamic 0 Single
96 osticket_db/ost_queue_column 33 13 81 Dynamic 0 Single
47 osticket_db/ost_form 33 13 32 Dynamic 0 Single
105 osticket_db/ost_user_account 33 13 90 Dynamic 0 Single
30 phpmyadmin/pma__tracking 33 13 15 Dynamic 0 Single
55 osticket_db/ost_email 33 13 40 Dynamic 0 Single
21 phpmyadmin/pma__column_info 33 13 6 Dynamic 0 Single
41 osticket_db/ost_faq 33 12 26 Dynamic 0 Single
72 osticket_db/ost_note 33 12 57 Dynamic 0 Single
39 osticket_db/ost_api_key 33 12 24 Dynamic 0 Single
88 osticket_db/ost_ticket_status 33 12 73 Dynamic 0 Single
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