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_FOREIGN` ORDER BY `N_COLS` ASC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
ID FOR_NAME REF_NAME N_COLS Ascending Descending 1 TYPE
eselidik_pro/fk_views_survey eselidik_pro/survey_views eselidik_pro/surveys 1 1
seminar_system/whatsapp_logs_registration_id_forei... seminar_system/whatsapp_logs seminar_system/registrations 1 2
kenderaan_db/drivers_user_id_foreign kenderaan_db/drivers kenderaan_db/users 1 2
muzium_manuskrip/carts_manuscript_id_foreign muzium_manuskrip/carts muzium_manuskrip/manuscripts 1 1
muzium_manuskrip/orders_visitor_profile_id_foreign muzium_manuskrip/orders muzium_manuskrip/visitor_profiles 1 1
aduan_integriti/jmm_actions_complaint_id_foreign aduan_integriti/jmm_actions aduan_integriti/complaints 1 1
seminar_system/attendances_registration_id_foreign seminar_system/attendances seminar_system/registrations 1 1
eselidik_pro/fk_sections_survey eselidik_pro/sections eselidik_pro/surveys 1 1
seminar_system/ticket_types_event_id_foreign seminar_system/ticket_types seminar_system/events 1 1
kenderaan_db/drivers_default_vehicle_id_foreign kenderaan_db/drivers kenderaan_db/vehicles 1 2
kenderaan_db/vehicle_request_histories_vehicle_req... kenderaan_db/vehicle_request_histories kenderaan_db/vehicle_requests 1 1
muzium_manuskrip/orders_approved_by_foreign muzium_manuskrip/orders muzium_manuskrip/users 1 2
aduan_integriti/complaints_created_by_admin_id_for... aduan_integriti/complaints aduan_integriti/users 1 2
seminar_system/attendances_event_session_id_foreig... seminar_system/attendances seminar_system/event_sessions 1 1
eselidik_pro/fk_responses_survey eselidik_pro/responses eselidik_pro/surveys 1 1
seminar_system/registrations_ticket_type_id_foreig... seminar_system/registrations seminar_system/ticket_types 1 2
kenderaan_db/departments_head_user_id_foreign kenderaan_db/departments kenderaan_db/users 1 2
kenderaan_db/vehicle_requests_vehicle_id_foreign kenderaan_db/vehicle_requests kenderaan_db/vehicles 1 2
muzium_manuskrip/model_has_roles_role_id_foreign muzium_manuskrip/model_has_roles muzium_manuskrip/roles 1 1
seminar_system/attendances_checked_in_by_foreign seminar_system/attendances seminar_system/users 1 2
seminar_system/registrations_participant_id_foreig... seminar_system/registrations seminar_system/participants 1 1
esijil_online/fk_participants_event esijil_online/participants esijil_online/events 1 1
kenderaan_db/vehicle_requests_driver_id_foreign kenderaan_db/vehicle_requests kenderaan_db/drivers 1 2
muzium_manuskrip/model_has_permissions_permission_... muzium_manuskrip/model_has_permissions muzium_manuskrip/permissions 1 1
muzium_manuskrip/role_has_permissions_role_id_fore... muzium_manuskrip/role_has_permissions muzium_manuskrip/roles 1 1
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