Recent
`mysql`.`plugin`
`moodle_iher`.`mdl_competency_usercompplan`
`phpmyadmin`.`pma__pdf_pages`
`moodle_iher`.`mdl_analytics_models_log`
`phpmyadmin`.`pma__column_info`
`phpmyadmin`.`pma__tracking`
`moodle_iher`.`mdl_competency_usercomp`
`moodle_iher`.`mdl_course_format_options`
`phpmyadmin`.`pma__table_info`
`moodle_iher`.`mdl_course_request`
Favorites
There are no favorite tables.
New
information_schema
moodle_iher
mysql
performance_schema
phpmyadmin
sys
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: moodle_iher
Structure
SQL
Search
Query
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
(current)
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
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
Label:
Target database:
Share this bookmark
OK
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Untracked tables
Table
Action
mdl_adminpresets
Track table
mdl_adminpresets_app
Track table
mdl_adminpresets_app_it
Track table
mdl_adminpresets_app_it_a
Track table
mdl_adminpresets_app_plug
Track table
mdl_adminpresets_it
Track table
mdl_adminpresets_it_a
Track table
mdl_adminpresets_plug
Track table
mdl_ai_action_generate_image
Track table
mdl_ai_action_generate_text
Track table
mdl_ai_action_register
Track table
mdl_ai_action_summarise_text
Track table
mdl_ai_policy_register
Track table
mdl_analytics_indicator_calc
Track table
mdl_analytics_models
Track table
mdl_analytics_models_log
Track table
mdl_analytics_predictions
Track table
mdl_analytics_prediction_actions
Track table
mdl_analytics_predict_samples
Track table
mdl_analytics_train_samples
Track table
mdl_analytics_used_analysables
Track table
mdl_analytics_used_files
Track table
mdl_assign
Track table
mdl_assignfeedback_comments
Track table
mdl_assignfeedback_editpdf_annot
Track table
mdl_assignfeedback_editpdf_cmnt
Track table
mdl_assignfeedback_editpdf_quick
Track table
mdl_assignfeedback_editpdf_rot
Track table
mdl_assignfeedback_file
Track table
mdl_assignsubmission_file
Track table
mdl_assignsubmission_onlinetext
Track table
mdl_assign_grades
Track table
mdl_assign_overrides
Track table
mdl_assign_plugin_config
Track table
mdl_assign_submission
Track table
mdl_assign_user_flags
Track table
mdl_assign_user_mapping
Track table
mdl_auth_lti_linked_login
Track table
mdl_auth_oauth2_linked_login
Track table
mdl_backup_controllers
Track table
mdl_backup_courses
Track table
mdl_backup_logs
Track table
mdl_badge
Track table
mdl_badge_alignment
Track table
mdl_badge_backpack
Track table
mdl_badge_backpack_oauth2
Track table
mdl_badge_criteria
Track table
mdl_badge_criteria_met
Track table
mdl_badge_criteria_param
Track table
mdl_badge_endorsement
Track table
mdl_badge_external
Track table
mdl_badge_external_backpack
Track table
mdl_badge_external_identifier
Track table
mdl_badge_issued
Track table
mdl_badge_manual_award
Track table
mdl_badge_related
Track table
mdl_bigbluebuttonbn
Track table
mdl_bigbluebuttonbn_logs
Track table
mdl_bigbluebuttonbn_recordings
Track table
mdl_block
Track table
mdl_block_instances
Track table
mdl_block_positions
Track table
mdl_block_recentlyaccesseditems
Track table
mdl_block_recent_activity
Track table
mdl_block_rss_client
Track table
mdl_blog_association
Track table
mdl_blog_external
Track table
mdl_book
Track table
mdl_book_chapters
Track table
mdl_cache_filters
Track table
mdl_cache_flags
Track table
mdl_capabilities
Track table
mdl_chat
Track table
mdl_chat_messages
Track table
mdl_chat_messages_current
Track table
mdl_chat_users
Track table
mdl_choice
Track table
mdl_choice_answers
Track table
mdl_choice_options
Track table
mdl_cohort
Track table
mdl_cohort_members
Track table
mdl_comments
Track table
mdl_communication
Track table
mdl_communication_customlink
Track table
mdl_communication_user
Track table
mdl_competency
Track table
mdl_competency_coursecomp
Track table
mdl_competency_coursecompsetting
Track table
mdl_competency_evidence
Track table
mdl_competency_framework
Track table
mdl_competency_modulecomp
Track table
mdl_competency_plan
Track table
mdl_competency_plancomp
Track table
mdl_competency_relatedcomp
Track table
mdl_competency_template
Track table
mdl_competency_templatecohort
Track table
mdl_competency_templatecomp
Track table
mdl_competency_usercomp
Track table
mdl_competency_usercompcourse
Track table
mdl_competency_usercompplan
Track table
mdl_competency_userevidence
Track table
mdl_competency_userevidencecomp
Track table
mdl_config
Track table
mdl_config_log
Track table
mdl_config_plugins
Track table
mdl_contentbank_content
Track table
mdl_context
Track table
mdl_context_temp
Track table
mdl_course
Track table
mdl_course_categories
Track table
mdl_course_completions
Track table
mdl_course_completion_aggr_methd
Track table
mdl_course_completion_criteria
Track table
mdl_course_completion_crit_compl
Track table
mdl_course_completion_defaults
Track table
mdl_course_format_options
Track table
mdl_course_modules
Track table
mdl_course_modules_completion
Track table
mdl_course_modules_viewed
Track table
mdl_course_published
Track table
mdl_course_request
Track table
mdl_course_sections
Track table
mdl_customfield_category
Track table
mdl_customfield_data
Track table
mdl_customfield_field
Track table
mdl_data
Track table
mdl_data_content
Track table
mdl_data_fields
Track table
mdl_data_records
Track table
mdl_editor_atto_autosave
Track table
mdl_enrol
Track table
mdl_enrol_flatfile
Track table
mdl_enrol_lti_app_registration
Track table
mdl_enrol_lti_context
Track table
mdl_enrol_lti_deployment
Track table
mdl_enrol_lti_lti2_consumer
Track table
mdl_enrol_lti_lti2_context
Track table
mdl_enrol_lti_lti2_nonce
Track table
mdl_enrol_lti_lti2_resource_link
Track table
mdl_enrol_lti_lti2_share_key
Track table
mdl_enrol_lti_lti2_tool_proxy
Track table
mdl_enrol_lti_lti2_user_result
Track table
mdl_enrol_lti_resource_link
Track table
mdl_enrol_lti_tools
Track table
mdl_enrol_lti_tool_consumer_map
Track table
mdl_enrol_lti_users
Track table
mdl_enrol_lti_user_resource_link
Track table
mdl_enrol_paypal
Track table
mdl_event
Track table
mdl_events_handlers
Track table
mdl_events_queue
Track table
mdl_events_queue_handlers
Track table
mdl_event_subscriptions
Track table
mdl_external_functions
Track table
mdl_external_services
Track table
mdl_external_services_functions
Track table
mdl_external_services_users
Track table
mdl_external_tokens
Track table
mdl_favourite
Track table
mdl_feedback
Track table
mdl_feedback_completed
Track table
mdl_feedback_completedtmp
Track table
mdl_feedback_item
Track table
mdl_feedback_sitecourse_map
Track table
mdl_feedback_template
Track table
mdl_feedback_value
Track table
mdl_feedback_valuetmp
Track table
mdl_files
Track table
mdl_files_reference
Track table
mdl_file_conversion
Track table
mdl_filter_active
Track table
mdl_filter_config
Track table
mdl_folder
Track table
mdl_forum
Track table
mdl_forum_digests
Track table
mdl_forum_discussions
Track table
mdl_forum_discussion_subs
Track table
mdl_forum_grades
Track table
mdl_forum_posts
Track table
mdl_forum_queue
Track table
mdl_forum_read
Track table
mdl_forum_subscriptions
Track table
mdl_forum_track_prefs
Track table
mdl_glossary
Track table
mdl_glossary_alias
Track table
mdl_glossary_categories
Track table
mdl_glossary_entries
Track table
mdl_glossary_entries_categories
Track table
mdl_glossary_formats
Track table
mdl_grade_categories
Track table
mdl_grade_categories_history
Track table
mdl_grade_grades
Track table
mdl_grade_grades_history
Track table
mdl_grade_import_newitem
Track table
mdl_grade_import_values
Track table
mdl_grade_items
Track table
mdl_grade_items_history
Track table
mdl_grade_letters
Track table
mdl_grade_outcomes
Track table
mdl_grade_outcomes_courses
Track table
mdl_grade_outcomes_history
Track table
mdl_grade_settings
Track table
mdl_gradingform_guide_comments
Track table
mdl_gradingform_guide_criteria
Track table
mdl_gradingform_guide_fillings
Track table
mdl_gradingform_rubric_criteria
Track table
mdl_gradingform_rubric_fillings
Track table
mdl_gradingform_rubric_levels
Track table
mdl_grading_areas
Track table
mdl_grading_definitions
Track table
mdl_grading_instances
Track table
mdl_groupings
Track table
mdl_groupings_groups
Track table
mdl_groups
Track table
mdl_groups_members
Track table
mdl_h5p
Track table
mdl_h5pactivity
Track table
mdl_h5pactivity_attempts
Track table
mdl_h5pactivity_attempts_results
Track table
mdl_h5p_contents_libraries
Track table
mdl_h5p_libraries
Track table
mdl_h5p_libraries_cachedassets
Track table
mdl_h5p_library_dependencies
Track table
mdl_imscp
Track table
mdl_infected_files
Track table
mdl_label
Track table
mdl_lesson
Track table
mdl_lesson_answers
Track table
mdl_lesson_attempts
Track table
mdl_lesson_branch
Track table
mdl_lesson_grades
Track table
mdl_lesson_overrides
Track table
mdl_lesson_pages
Track table
mdl_lesson_timer
Track table
mdl_license
Track table
mdl_lock_db
Track table
mdl_log
Track table
mdl_logstore_standard_log
Track table
mdl_log_display
Track table
mdl_log_queries
Track table
mdl_lti
Track table
mdl_ltiservice_gradebookservices
Track table
mdl_lti_access_tokens
Track table
mdl_lti_coursevisible
Track table
mdl_lti_submission
Track table
mdl_lti_tool_proxies
Track table
mdl_lti_tool_settings
Track table
mdl_lti_types
Track table
mdl_lti_types_categories
Track table
mdl_lti_types_config
Track table
mdl_matrix_room
Track table
mdl_message
Track table
mdl_messageinbound_datakeys
Track table
mdl_messageinbound_handlers
Track table
mdl_messageinbound_messagelist
Track table
mdl_messages
Track table
mdl_message_airnotifier_devices
Track table
mdl_message_contacts
Track table
mdl_message_contact_requests
Track table
mdl_message_conversations
Track table
mdl_message_conversation_actions
Track table
mdl_message_conversation_members
Track table
mdl_message_email_messages
Track table
mdl_message_popup
Track table
mdl_message_popup_notifications
Track table
mdl_message_processors
Track table
mdl_message_providers
Track table
mdl_message_read
Track table
mdl_message_users_blocked
Track table
mdl_message_user_actions
Track table
mdl_mnetservice_enrol_courses
Track table
mdl_mnetservice_enrol_enrolments
Track table
mdl_mnet_application
Track table
mdl_mnet_host
Track table
mdl_mnet_host2service
Track table
mdl_mnet_log
Track table
mdl_mnet_remote_rpc
Track table
mdl_mnet_remote_service2rpc
Track table
mdl_mnet_rpc
Track table
mdl_mnet_service
Track table
mdl_mnet_service2rpc
Track table
mdl_mnet_session
Track table
mdl_mnet_sso_access_control
Track table
mdl_modules
Track table
mdl_moodlenet_share_progress
Track table
mdl_my_pages
Track table
mdl_notifications
Track table
mdl_oauth2_access_token
Track table
mdl_oauth2_endpoint
Track table
mdl_oauth2_issuer
Track table
mdl_oauth2_refresh_token
Track table
mdl_oauth2_system_account
Track table
mdl_oauth2_user_field_mapping
Track table
mdl_page
Track table
mdl_paygw_paypal
Track table
mdl_payments
Track table
mdl_payment_accounts
Track table
mdl_payment_gateways
Track table
mdl_portfolio_instance
Track table
mdl_portfolio_instance_config
Track table
mdl_portfolio_instance_user
Track table
mdl_portfolio_log
Track table
mdl_portfolio_mahara_queue
Track table
mdl_portfolio_tempdata
Track table
mdl_post
Track table
mdl_profiling
Track table
mdl_qtype_ddimageortext
Track table
mdl_qtype_ddimageortext_drags
Track table
mdl_qtype_ddimageortext_drops
Track table
mdl_qtype_ddmarker
Track table
mdl_qtype_ddmarker_drags
Track table
mdl_qtype_ddmarker_drops
Track table
mdl_qtype_essay_options
Track table
mdl_qtype_match_options
Track table
mdl_qtype_match_subquestions
Track table
mdl_qtype_multichoice_options
Track table
mdl_qtype_ordering_options
Track table
mdl_qtype_randomsamatch_options
Track table
mdl_qtype_shortanswer_options
Track table
mdl_question
Track table
mdl_question_answers
Track table
mdl_question_attempts
Track table
mdl_question_attempt_steps
Track table
mdl_question_attempt_step_data
Track table
mdl_question_bank_entries
Track table
mdl_question_calculated
Track table
mdl_question_calculated_options
Track table
mdl_question_categories
Track table
mdl_question_datasets
Track table
mdl_question_dataset_definitions
Track table
mdl_question_dataset_items
Track table
mdl_question_ddwtos
Track table
mdl_question_gapselect
Track table
mdl_question_hints
Track table
mdl_question_multianswer
Track table
mdl_question_numerical
Track table
mdl_question_numerical_options
Track table
mdl_question_numerical_units
Track table
mdl_question_references
Track table
mdl_question_response_analysis
Track table
mdl_question_response_count
Track table
mdl_question_set_references
Track table
mdl_question_statistics
Track table
mdl_question_truefalse
Track table
mdl_question_usages
Track table
mdl_question_versions
Track table
mdl_quiz
Track table
mdl_quizaccess_seb_quizsettings
Track table
mdl_quizaccess_seb_template
Track table
mdl_quiz_attempts
Track table
mdl_quiz_feedback
Track table
mdl_quiz_grades
Track table
mdl_quiz_grade_items
Track table
mdl_quiz_overrides
Track table
mdl_quiz_overview_regrades
Track table
mdl_quiz_reports
Track table
mdl_quiz_sections
Track table
mdl_quiz_slots
Track table
mdl_quiz_statistics
Track table
mdl_rating
Track table
mdl_registration_hubs
Track table
mdl_reportbuilder_audience
Track table
mdl_reportbuilder_column
Track table
mdl_reportbuilder_filter
Track table
mdl_reportbuilder_report
Track table
mdl_reportbuilder_schedule
Track table
mdl_repository
Track table
mdl_repository_instances
Track table
mdl_repository_instance_config
Track table
mdl_repository_onedrive_access
Track table
mdl_resource
Track table
mdl_resource_old
Track table
mdl_role
Track table
mdl_role_allow_assign
Track table
mdl_role_allow_override
Track table
mdl_role_allow_switch
Track table
mdl_role_allow_view
Track table
mdl_role_assignments
Track table
mdl_role_capabilities
Track table
mdl_role_context_levels
Track table
mdl_role_names
Track table
mdl_scale
Track table
mdl_scale_history
Track table
mdl_scorm
Track table
mdl_scorm_aicc_session
Track table
mdl_scorm_attempt
Track table
mdl_scorm_element
Track table
mdl_scorm_scoes
Track table
mdl_scorm_scoes_data
Track table
mdl_scorm_scoes_value
Track table
mdl_scorm_seq_mapinfo
Track table
mdl_scorm_seq_objective
Track table
mdl_scorm_seq_rolluprule
Track table
mdl_scorm_seq_rolluprulecond
Track table
mdl_scorm_seq_rulecond
Track table
mdl_scorm_seq_ruleconds
Track table
mdl_search_index_requests
Track table
mdl_search_simpledb_index
Track table
mdl_sessions
Track table
mdl_sms_gateways
Track table
mdl_sms_messages
Track table
mdl_stats_daily
Track table
mdl_stats_monthly
Track table
mdl_stats_user_daily
Track table
mdl_stats_user_monthly
Track table
mdl_stats_user_weekly
Track table
mdl_stats_weekly
Track table
mdl_stored_progress
Track table
mdl_subsection
Track table
mdl_survey
Track table
mdl_survey_analysis
Track table
mdl_survey_answers
Track table
mdl_survey_questions
Track table
mdl_tag
Track table
mdl_tag_area
Track table
mdl_tag_coll
Track table
mdl_tag_correlation
Track table
mdl_tag_instance
Track table
mdl_task_adhoc
Track table
mdl_task_log
Track table
mdl_task_scheduled
Track table
mdl_tiny_autosave
Track table
mdl_tool_brickfield_areas
Track table
mdl_tool_brickfield_cache_acts
Track table
mdl_tool_brickfield_cache_check
Track table
mdl_tool_brickfield_checks
Track table
mdl_tool_brickfield_content
Track table
mdl_tool_brickfield_errors
Track table
mdl_tool_brickfield_process
Track table
mdl_tool_brickfield_results
Track table
mdl_tool_brickfield_schedule
Track table
mdl_tool_brickfield_summary
Track table
mdl_tool_cohortroles
Track table
mdl_tool_customlang
Track table
mdl_tool_customlang_components
Track table
mdl_tool_dataprivacy_category
Track table
mdl_tool_dataprivacy_contextlist
Track table
mdl_tool_dataprivacy_ctxexpired
Track table
mdl_tool_dataprivacy_ctxinstance
Track table
mdl_tool_dataprivacy_ctxlevel
Track table
mdl_tool_dataprivacy_ctxlst_ctx
Track table
mdl_tool_dataprivacy_purpose
Track table
mdl_tool_dataprivacy_purposerole
Track table
mdl_tool_dataprivacy_request
Track table
mdl_tool_dataprivacy_rqst_ctxlst
Track table
mdl_tool_mfa
Track table
mdl_tool_mfa_auth
Track table
mdl_tool_mfa_secrets
Track table
mdl_tool_monitor_events
Track table
mdl_tool_monitor_history
Track table
mdl_tool_monitor_rules
Track table
mdl_tool_monitor_subscriptions
Track table
mdl_tool_policy
Track table
mdl_tool_policy_acceptances
Track table
mdl_tool_policy_versions
Track table
mdl_tool_recyclebin_category
Track table
mdl_tool_recyclebin_course
Track table
mdl_tool_usertours_steps
Track table
mdl_tool_usertours_tours
Track table
mdl_upgrade_log
Track table
mdl_url
Track table
mdl_user
Track table
mdl_user_devices
Track table
mdl_user_enrolments
Track table
mdl_user_info_category
Track table
mdl_user_info_data
Track table
mdl_user_info_field
Track table
mdl_user_lastaccess
Track table
mdl_user_password_history
Track table
mdl_user_password_resets
Track table
mdl_user_preferences
Track table
mdl_user_private_key
Track table
mdl_wiki
Track table
mdl_wiki_links
Track table
mdl_wiki_locks
Track table
mdl_wiki_pages
Track table
mdl_wiki_subwikis
Track table
mdl_wiki_synonyms
Track table
mdl_wiki_versions
Track table
mdl_workshop
Track table
mdl_workshopallocation_scheduled
Track table
mdl_workshopeval_best_settings
Track table
mdl_workshopform_accumulative
Track table
mdl_workshopform_comments
Track table
mdl_workshopform_numerrors
Track table
mdl_workshopform_numerrors_map
Track table
mdl_workshopform_rubric
Track table
mdl_workshopform_rubric_config
Track table
mdl_workshopform_rubric_levels
Track table
mdl_workshop_aggregations
Track table
mdl_workshop_assessments
Track table
mdl_workshop_grades
Track table
mdl_workshop_submissions
Track table
mdl_xapi_states
Track table
Check all
With selected:
Track table