Recent
`cabello-enterprises`.`llx_localtax`
`cabello-enterprises_exp`.`llx_localtax`
`cabello-enterprises`.`llx_c_availability`
`sys`.`x$statements_with_full_table_scans`
`cabecab4_abanq`.`co_asientos`
`aaa_fabricas_pruebas`.`mat_fab`
`cabecab4_abanq`.`articulostarifas`
`cabello-enterprises`.`llx_paiement_facture`
`contabilidad`.`tpv_2t_2024`
`cabello-enterprises`.`llx_events`
Favorites
There are no favorite tables.
X
New
aaa
aaa
aaa_fabricas_pruebas
abanq
abanq_23
abanq_23 experimental
articulos
autocompleta
azulejoscabello.com
azulejoscabello.com
azulejoscabello.com_tienda
azulejoscabello_com
book_sc
cabecab4
cabecab4_abanq
cabecab4_abanq230
cabecab4_abanq240
joomla_3_9
cabecab4_joomla_3_9_11_helix
cabecab4_joomla_3_9_11_helix_exp
cabecab4_pamesa_filter
cabecab4_web
cabello-enterprises
cabello-enterprises
cabello-enterprises_exp
contabilidad
datatablesv03
durstone
eneboo
grespania
information_schema
intermediaria_online
jplist
keraben
letodms
letodms experimental
magazine
mydms
mydms experimental
mysql
pamesa_filter
performance_schema
php_producto
php_producto
php_producto_prueba
sys
tutorial
wordpress
wordpress
wordpress_desarrollo
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: localhost
Database: cabello-enterprises
Table: llx_localtax
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
amount
datep
datev
entity
fk_bank
fk_user_creat
fk_user_modif
label
localtaxtype
note
rowid
tms
+ Add column
aaa
aaa_fabricas_pruebas
abanq_23
abanq_23 experimental
articulos
autocompleta
azulejoscabello.com
azulejoscabello.com_tienda
azulejoscabello_com
book_sc
cabecab4_abanq
cabecab4_abanq230
cabecab4_abanq240
cabecab4_joomla_3_9_11_helix
cabecab4_joomla_3_9_11_helix_exp
cabecab4_pamesa_filter
cabecab4_web
cabello-enterprises
cabello-enterprises_exp
contabilidad
datatablesv03
durstone
eneboo
grespania
information_schema
intermediaria_online
jplist
keraben
letodms
letodms experimental
magazine
mydms
mydms experimental
mysql
pamesa_filter
performance_schema
php_producto
php_producto_prueba
sys
tutorial
wordpress
wordpress_desarrollo
llx_accounting_account
llx_accounting_bookkeeping
llx_accounting_bookkeeping_tmp
llx_accounting_fiscalyear
llx_accounting_journal
llx_accounting_system
llx_actioncomm
llx_actioncomm_extrafields
llx_actioncomm_reminder
llx_actioncomm_resources
llx_adherent
llx_adherent_extrafields
llx_adherent_type
llx_adherent_type_extrafields
llx_adherent_type_lang
llx_advtargetemailing
llx_asset
llx_asset_extrafields
llx_asset_type
llx_asset_type_extrafields
llx_bank
llx_bank_account
llx_bank_account_extrafields
llx_bank_categ
llx_bank_class
llx_bank_url
llx_blockedlog
llx_blockedlog_authority
llx_bom_bom
llx_bom_bomline
llx_bom_bomline_extrafields
llx_bom_bom_extrafields
llx_bookmark
llx_bordereau_cheque
llx_boxes
llx_boxes_def
llx_budget
llx_budget_lines
llx_categorie
llx_categories_extrafields
llx_categorie_account
llx_categorie_actioncomm
llx_categorie_contact
llx_categorie_fournisseur
llx_categorie_lang
llx_categorie_member
llx_categorie_product
llx_categorie_project
llx_categorie_societe
llx_categorie_user
llx_categorie_warehouse
llx_categorie_website_page
llx_chargesociales
llx_commande
llx_commandedet
llx_commandedet_extrafields
llx_commande_extrafields
llx_commande_fournisseur
llx_commande_fournisseurdet
llx_commande_fournisseurdet_extrafields
llx_commande_fournisseur_dispatch
llx_commande_fournisseur_dispatch_extrafields
llx_commande_fournisseur_extrafields
llx_commande_fournisseur_log
llx_comment
llx_const
llx_contrat
llx_contratdet
llx_contratdet_extrafields
llx_contratdet_log
llx_contrat_extrafields
llx_cronjob
llx_c_accounting_category
llx_c_actioncomm
llx_c_action_trigger
llx_c_availability
llx_c_barcode_type
llx_c_chargesociales
llx_c_civility
llx_c_country
llx_c_currencies
llx_c_departements
llx_c_ecotaxe
llx_c_effectif
llx_c_email_senderprofile
llx_c_email_templates
llx_c_exp_tax_cat
llx_c_exp_tax_range
llx_c_field_list
llx_c_format_cards
llx_c_forme_juridique
llx_c_holiday_types
llx_c_hrm_department
llx_c_hrm_function
llx_c_hrm_public_holiday
llx_c_incoterms
llx_c_input_method
llx_c_input_reason
llx_c_lead_status
llx_c_paiement
llx_c_paper_format
llx_c_payment_term
llx_c_price_expression
llx_c_price_global_variable
llx_c_price_global_variable_updater
llx_c_propalst
llx_c_prospectlevel
llx_c_regions
llx_c_revenuestamp
llx_c_shipment_mode
llx_c_shipment_package_type
llx_c_socialnetworks
llx_c_stcomm
llx_c_ticket_category
llx_c_ticket_resolution
llx_c_ticket_severity
llx_c_ticket_type
llx_c_tva
llx_c_typent
llx_c_type_contact
llx_c_type_container
llx_c_type_fees
llx_c_type_resource
llx_c_units
llx_c_ziptown
llx_default_values
llx_deplacement
llx_document_model
llx_don
llx_don_extrafields
llx_ecm_directories
llx_ecm_files
llx_element_contact
llx_element_element
llx_element_resources
llx_emailcollector_emailcollector
llx_emailcollector_emailcollectoraction
llx_emailcollector_emailcollectorfilter
llx_entrepot
llx_entrepot_extrafields
llx_establishment
llx_events
llx_event_element
llx_expedition
llx_expeditiondet
llx_expeditiondet_batch
llx_expeditiondet_extrafields
llx_expedition_extrafields
llx_expedition_package
llx_expensereport
llx_expensereport_det
llx_expensereport_extrafields
llx_expensereport_ik
llx_expensereport_rules
llx_export_compta
llx_export_model
llx_extrafields
llx_facture
llx_facturedet
llx_facturedet_extrafields
llx_facturedet_rec
llx_facturedet_rec_extrafields
llx_facture_extrafields
llx_facture_fourn
llx_facture_fourn_det
llx_facture_fourn_det_extrafields
llx_facture_fourn_extrafields
llx_facture_rec
llx_facture_rec_extrafields
llx_fichinter
llx_fichinterdet
llx_fichinterdet_extrafields
llx_fichinterdet_rec
llx_fichinter_extrafields
llx_fichinter_rec
llx_holiday
llx_holiday_config
llx_holiday_extrafields
llx_holiday_logs
llx_holiday_users
llx_import_model
llx_inventory
llx_inventorydet
llx_links
llx_livraison
llx_livraisondet
llx_livraisondet_extrafields
llx_livraison_extrafields
llx_loan
llx_loan_schedule
llx_localtax
llx_mailing
llx_mailing_cibles
llx_mailing_unsubscribe
llx_menu
llx_mrp_mo
llx_mrp_mo_extrafields
llx_mrp_production
llx_multicurrency
llx_multicurrency_rate
llx_notify
llx_notify_def
llx_notify_def_object
llx_oauth_state
llx_oauth_token
llx_object_lang
llx_onlinesignature
llx_opensurvey_comments
llx_opensurvey_formquestions
llx_opensurvey_sondage
llx_opensurvey_user_formanswers
llx_opensurvey_user_studs
llx_overwrite_trans
llx_paiement
llx_paiementcharge
llx_paiementfourn
llx_paiementfourn_facturefourn
llx_paiement_facture
llx_payment_donation
llx_payment_expensereport
llx_payment_loan
llx_payment_salary
llx_payment_salary_extrafields
llx_payment_various
llx_pos_cash_fence
llx_prelevement_bons
llx_prelevement_facture
llx_prelevement_facture_demande
llx_prelevement_lignes
llx_prelevement_rejet
llx_printing
llx_product
llx_product_association
llx_product_attribute
llx_product_attribute_combination
llx_product_attribute_combination2val
llx_product_attribute_value
llx_product_batch
llx_product_customer_price
llx_product_customer_price_log
llx_product_extrafields
llx_product_fournisseur_price
llx_product_fournisseur_price_extrafields
llx_product_fournisseur_price_log
llx_product_lang
llx_product_lot
llx_product_lot_extrafields
llx_product_price
llx_product_pricerules
llx_product_price_by_qty
llx_product_stock
llx_product_warehouse_properties
llx_projet
llx_projet_extrafields
llx_projet_task
llx_projet_task_extrafields
llx_projet_task_time
llx_propal
llx_propaldet
llx_propaldet_extrafields
llx_propal_extrafields
llx_propal_merge_pdf_product
llx_reception
llx_reception_extrafields
llx_resource
llx_resource_extrafields
llx_rights_def
llx_societe
llx_societe_account
llx_societe_address
llx_societe_commerciaux
llx_societe_contacts
llx_societe_extrafields
llx_societe_prices
llx_societe_remise
llx_societe_remise_except
llx_societe_remise_supplier
llx_societe_rib
llx_socpeople
llx_socpeople_extrafields
llx_stock_mouvement
llx_subscription
llx_supplier_proposal
llx_supplier_proposaldet
llx_supplier_proposaldet_extrafields
llx_supplier_proposal_extrafields
llx_takepos_floor_tables
llx_ticket
llx_ticket_extrafields
llx_tva
llx_user
llx_usergroup
llx_usergroup_extrafields
llx_usergroup_rights
llx_usergroup_user
llx_user_alert
llx_user_clicktodial
llx_user_employment
llx_user_extrafields
llx_user_param
llx_user_rib
llx_user_rights
llx_website
llx_website_extrafields
llx_website_page
llx_zapier_hook
llx_zapier_hook_extrafields
+ Add constraint
Loading