Recent
`prestashop`.`q2duq_attribute_group_lang`
`mysql`.`transaction_registry`
`prestashop`.`q2duq_cms_role`
`acsuin`.`aseguradora`
`prestashop`.`q2duq_quick_access`
`prestashop`.`q2duq_contact`
`prestashop`.`q2duq_psshipping_address_orders`
`asociacion_cge`.`cobros`
`egsystemit_acsuin`.`cobservaciones`
`prestashop`.`q2duq_group_reduction`
Favorites
There are no favorite tables.
New
acsuin
almuerzos_kepler
asociacion_cge
central_remates
creador_agentes
egsystemit_acsuin
eva_sistema
information_schema
mysql
performance_schema
phpmyadmin
prestashop
recargas
seeddms
sistema_escolar_ia
sms
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
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: prestashop
Table: q2duq_attribute_group_lang
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
id_attribute_group
id_lang
name
public_name
+ Add column
acsuin
almuerzos_kepler
asociacion_cge
central_remates
creador_agentes
egsystemit_acsuin
eva_sistema
information_schema
mysql
performance_schema
phpmyadmin
prestashop
recargas
seeddms
sistema_escolar_ia
sms
test
q2duq_access
q2duq_accessory
q2duq_address
q2duq_address_format
q2duq_admin_filter
q2duq_alias
q2duq_api_client
q2duq_attachment
q2duq_attachment_lang
q2duq_attribute
q2duq_attribute_group
q2duq_attribute_group_lang
q2duq_attribute_group_shop
q2duq_attribute_lang
q2duq_attribute_shop
q2duq_authorization_role
q2duq_blockwishlist_statistics
q2duq_carrier
q2duq_carrier_group
q2duq_carrier_lang
q2duq_carrier_shop
q2duq_carrier_tax_rules_group_shop
q2duq_carrier_zone
q2duq_cart
q2duq_cart_cart_rule
q2duq_cart_product
q2duq_cart_rule
q2duq_cart_rule_carrier
q2duq_cart_rule_combination
q2duq_cart_rule_compatible_types
q2duq_cart_rule_country
q2duq_cart_rule_group
q2duq_cart_rule_lang
q2duq_cart_rule_product_rule
q2duq_cart_rule_product_rule_group
q2duq_cart_rule_product_rule_value
q2duq_cart_rule_shop
q2duq_cart_rule_type
q2duq_cart_rule_type_lang
q2duq_category
q2duq_category_group
q2duq_category_lang
q2duq_category_product
q2duq_category_shop
q2duq_cms
q2duq_cms_category
q2duq_cms_category_lang
q2duq_cms_category_shop
q2duq_cms_lang
q2duq_cms_role
q2duq_cms_role_lang
q2duq_cms_shop
q2duq_configuration
q2duq_configuration_kpi
q2duq_configuration_kpi_lang
q2duq_configuration_lang
q2duq_connections
q2duq_connections_page
q2duq_connections_source
q2duq_contact
q2duq_contact_lang
q2duq_contact_shop
q2duq_country
q2duq_country_lang
q2duq_country_shop
q2duq_currency
q2duq_currency_lang
q2duq_currency_shop
q2duq_customer
q2duq_customer_group
q2duq_customer_message
q2duq_customer_message_sync_imap
q2duq_customer_session
q2duq_customer_thread
q2duq_customization
q2duq_customization_field
q2duq_customization_field_lang
q2duq_customized_data
q2duq_date_range
q2duq_delivery
q2duq_emailsubscription
q2duq_employee
q2duq_employee_account
q2duq_employee_session
q2duq_employee_shop
q2duq_eventbus_incremental_sync
q2duq_eventbus_job
q2duq_eventbus_live_sync
q2duq_eventbus_type_sync
q2duq_fb_category_match
q2duq_feature
q2duq_feature_flag
q2duq_feature_lang
q2duq_feature_product
q2duq_feature_shop
q2duq_feature_value
q2duq_feature_value_lang
q2duq_ganalytics
q2duq_ganalytics_data
q2duq_gender
q2duq_gender_lang
q2duq_group
q2duq_group_lang
q2duq_group_reduction
q2duq_group_shop
q2duq_gsitemap_sitemap
q2duq_guest
q2duq_homeslider
q2duq_homeslider_slides
q2duq_homeslider_slides_lang
q2duq_hook
q2duq_hook_alias
q2duq_hook_module
q2duq_hook_module_exceptions
q2duq_image
q2duq_image_lang
q2duq_image_shop
q2duq_image_type
q2duq_import_match
q2duq_info
q2duq_info_lang
q2duq_info_shop
q2duq_lang
q2duq_lang_shop
q2duq_layered_category
q2duq_layered_filter
q2duq_layered_filter_block
q2duq_layered_filter_shop
q2duq_layered_indexable_attribute_group
q2duq_layered_indexable_attribute_group_lang_value
q2duq_layered_indexable_attribute_lang_value
q2duq_layered_indexable_feature
q2duq_layered_indexable_feature_lang_value
q2duq_layered_indexable_feature_value_lang_value
q2duq_layered_price_index
q2duq_layered_product_attribute
q2duq_linksmenutop
q2duq_linksmenutop_lang
q2duq_link_block
q2duq_link_block_lang
q2duq_link_block_shop
q2duq_log
q2duq_mail
q2duq_mailalert_customer_oos
q2duq_manufacturer
q2duq_manufacturer_lang
q2duq_manufacturer_shop
q2duq_mbo_api_config
q2duq_memcached_servers
q2duq_message
q2duq_message_readed
q2duq_meta
q2duq_meta_lang
q2duq_module
q2duq_module_access
q2duq_module_carrier
q2duq_module_country
q2duq_module_currency
q2duq_module_group
q2duq_module_history
q2duq_module_preference
q2duq_module_shop
q2duq_mutation
q2duq_operating_system
q2duq_orders
q2duq_order_carrier
q2duq_order_cart_rule
q2duq_order_detail
q2duq_order_detail_tax
q2duq_order_history
q2duq_order_invoice
q2duq_order_invoice_payment
q2duq_order_invoice_tax
q2duq_order_message
q2duq_order_message_lang
q2duq_order_payment
q2duq_order_return
q2duq_order_return_detail
q2duq_order_return_state
q2duq_order_return_state_lang
q2duq_order_slip
q2duq_order_slip_detail
q2duq_order_state
q2duq_order_state_lang
q2duq_pack
q2duq_page
q2duq_pagenotfound
q2duq_page_type
q2duq_page_viewed
q2duq_product
q2duq_product_attachment
q2duq_product_attribute
q2duq_product_attribute_combination
q2duq_product_attribute_image
q2duq_product_attribute_lang
q2duq_product_attribute_shop
q2duq_product_carrier
q2duq_product_comment
q2duq_product_comment_criterion
q2duq_product_comment_criterion_category
q2duq_product_comment_criterion_lang
q2duq_product_comment_criterion_product
q2duq_product_comment_grade
q2duq_product_comment_report
q2duq_product_comment_usefulness
q2duq_product_country_tax
q2duq_product_download
q2duq_product_group_reduction_cache
q2duq_product_lang
q2duq_product_sale
q2duq_product_shop
q2duq_product_supplier
q2duq_product_tag
q2duq_profile
q2duq_profile_lang
q2duq_pscheckout_authorization
q2duq_pscheckout_capture
q2duq_pscheckout_cart
q2duq_pscheckout_customer
q2duq_pscheckout_funding_source
q2duq_pscheckout_order
q2duq_pscheckout_order_matrice
q2duq_pscheckout_payment_token
q2duq_pscheckout_purchase_unit
q2duq_pscheckout_refund
q2duq_pscheckout_tracking
q2duq_psgdpr_consent
q2duq_psgdpr_consent_lang
q2duq_psgdpr_log
q2duq_psreassurance
q2duq_psreassurance_lang
q2duq_psshipping_address
q2duq_psshipping_address_orders
q2duq_quick_access
q2duq_quick_access_lang
q2duq_range_price
q2duq_range_weight
q2duq_request_sql
q2duq_required_field
q2duq_risk
q2duq_risk_lang
q2duq_search_engine
q2duq_search_index
q2duq_search_word
q2duq_shipment
q2duq_shipment_product
q2duq_shop
q2duq_shop_group
q2duq_shop_url
q2duq_smarty_cache
q2duq_smarty_last_flush
q2duq_smarty_lazy_cache
q2duq_specific_price
q2duq_specific_price_priority
q2duq_specific_price_rule
q2duq_specific_price_rule_condition
q2duq_specific_price_rule_condition_group
q2duq_state
q2duq_statssearch
q2duq_stock
q2duq_stock_available
q2duq_stock_mvt
q2duq_stock_mvt_reason
q2duq_stock_mvt_reason_lang
q2duq_store
q2duq_store_lang
q2duq_store_shop
q2duq_supplier
q2duq_supplier_lang
q2duq_supplier_shop
q2duq_supply_order
q2duq_supply_order_detail
q2duq_supply_order_history
q2duq_supply_order_receipt_history
q2duq_supply_order_state
q2duq_supply_order_state_lang
q2duq_tab
q2duq_tab_lang
q2duq_tab_module_preference
q2duq_tag
q2duq_tag_count
q2duq_tax
q2duq_tax_lang
q2duq_tax_rule
q2duq_tax_rules_group
q2duq_tax_rules_group_shop
q2duq_timezone
q2duq_translation
q2duq_warehouse
q2duq_warehouse_carrier
q2duq_warehouse_product_location
q2duq_warehouse_shop
q2duq_webservice_account
q2duq_webservice_account_shop
q2duq_webservice_permission
q2duq_web_browser
q2duq_wishlist
q2duq_wishlist_product
q2duq_wishlist_product_cart
q2duq_zone
q2duq_zone_shop
+ Add constraint
Loading