Recent
`wp_cttesnieres`.`wp_term_relationships`
`guestres`.`roomimages`
`guestres`.`l_occasion`
`wp_cttesnieres`.`iup5tdt_tm_tasks`
`wp_cttesnieres`.`iup5tdt_duplicator_pro_packages`
`wp_cttesnieres`.`iup5tdt_wc_order_operational_data`
`wp_cttesnieres`.`iup5tdt_itsec_mutexes`
`wp_cttesnieres`.`iup5tdt_woocommerce_api_keys`
`wp_cttesnieres`.`iup5tdt_itsec_distributed_storage`
`mysql`.`gtid_slave_pos`
Favorites
There are no favorite tables.
New
guestres
information_schema
mdgexpress
mysql
performance_schema
phpmyadmin
test
wp_cttesnieres
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
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: wp_cttesnieres
Table: wp_term_relationships
Browse
Structure
(current)
SQL
Search
Insert
Export
Import
Privileges
Operations
Triggers
Console
Clear
History
Options
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 :
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
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Table structure
Relation view
Foreign key constraints
Actions
Constraint properties
Column
Creating a foreign key over a non-indexed column would automatically create an index on it. Alternatively, you can define an index below, before creating the foreign key.
Foreign key constraint (INNODB)
Database
Table
Column
ON DELETE
CASCADE
SET NULL
NO ACTION
RESTRICT
ON UPDATE
CASCADE
SET NULL
NO ACTION
RESTRICT
object_id
term_order
term_taxonomy_id
+ Add column
guestres
information_schema
mdgexpress
mysql
performance_schema
phpmyadmin
test
wp_cttesnieres
iup5tdt_actionscheduler_actions
iup5tdt_actionscheduler_claims
iup5tdt_actionscheduler_groups
iup5tdt_actionscheduler_logs
iup5tdt_ays_pb
iup5tdt_ays_pb_categories
iup5tdt_ays_pb_settings
iup5tdt_cleantalk_sfw_personal_temp
iup5tdt_commentmeta
iup5tdt_comments
iup5tdt_duplicator_pro_entities
iup5tdt_duplicator_pro_packages
iup5tdt_gf_addon_feed
iup5tdt_gf_draft_submissions
iup5tdt_gf_entry
iup5tdt_gf_entry_meta
iup5tdt_gf_entry_notes
iup5tdt_gf_form
iup5tdt_gf_form_meta
iup5tdt_gf_form_revisions
iup5tdt_gf_form_view
iup5tdt_gf_rest_api_keys
iup5tdt_giftvouchers_activity
iup5tdt_giftvouchers_list
iup5tdt_giftvouchers_setting
iup5tdt_giftvouchers_template
iup5tdt_itsec_bans
iup5tdt_itsec_dashboard_events
iup5tdt_itsec_dashboard_lockouts
iup5tdt_itsec_distributed_storage
iup5tdt_itsec_fingerprints
iup5tdt_itsec_firewall_rules
iup5tdt_itsec_geolocation_cache
iup5tdt_itsec_lockouts
iup5tdt_itsec_logs
iup5tdt_itsec_mutexes
iup5tdt_itsec_opaque_tokens
iup5tdt_itsec_temp
iup5tdt_itsec_user_groups
iup5tdt_itsec_vulnerabilities
iup5tdt_jetpack_sync_queue
iup5tdt_links
iup5tdt_options
iup5tdt_postmeta
iup5tdt_posts
iup5tdt_termmeta
iup5tdt_terms
iup5tdt_term_relationships
iup5tdt_term_taxonomy
iup5tdt_tm_taskmeta
iup5tdt_tm_tasks
iup5tdt_usermeta
iup5tdt_users
iup5tdt_wc_admin_notes
iup5tdt_wc_admin_note_actions
iup5tdt_wc_category_lookup
iup5tdt_wc_customer_lookup
iup5tdt_wc_download_log
iup5tdt_wc_email_unsubscribes
iup5tdt_wc_orders
iup5tdt_wc_orders_meta
iup5tdt_wc_order_addresses
iup5tdt_wc_order_coupon_lookup
iup5tdt_wc_order_operational_data
iup5tdt_wc_order_product_lookup
iup5tdt_wc_order_stats
iup5tdt_wc_order_tax_lookup
iup5tdt_wc_product_attributes_lookup
iup5tdt_wc_product_download_directories
iup5tdt_wc_product_meta_lookup
iup5tdt_wc_rate_limits
iup5tdt_wc_reserved_stock
iup5tdt_wc_tax_rate_classes
iup5tdt_wc_webhooks
iup5tdt_woocommerce_api_keys
iup5tdt_woocommerce_attribute_taxonomies
iup5tdt_woocommerce_downloadable_product_permissions
iup5tdt_woocommerce_log
iup5tdt_woocommerce_order_itemmeta
iup5tdt_woocommerce_order_items
iup5tdt_woocommerce_payment_tokenmeta
iup5tdt_woocommerce_payment_tokens
iup5tdt_woocommerce_sessions
iup5tdt_woocommerce_shipping_zones
iup5tdt_woocommerce_shipping_zone_locations
iup5tdt_woocommerce_shipping_zone_methods
iup5tdt_woocommerce_tax_rates
iup5tdt_woocommerce_tax_rate_locations
iup5tdt_wpfm_backup
iup5tdt_wpo_404_detector
iup5tdt_yoast_expiring_store
iup5tdt_yoast_indexable
iup5tdt_yoast_indexable_hierarchy
iup5tdt_yoast_migrations
iup5tdt_yoast_primary_term
iup5tdt_yoast_prominent_words
iup5tdt_yoast_seo_links
wp_commentmeta
wp_comments
wp_duplicator_pro_entities
wp_duplicator_pro_packages
wp_gf_draft_submissions
wp_gf_entry
wp_gf_entry_meta
wp_gf_entry_notes
wp_gf_form
wp_gf_form_meta
wp_gf_form_revisions
wp_gf_form_view
wp_gf_rest_api_keys
wp_links
wp_options
wp_postmeta
wp_posts
wp_termmeta
wp_terms
wp_term_relationships
wp_term_taxonomy
wp_usermeta
wp_users
+ Add constraint
Loading