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 :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Export Exporting tables from "cabello-enterprises" database

Export defaults
Customize default export options.
Export defaults
Restore default value
Quick
Restore default value
Restore default value
Custom
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
SQL
Customize default options.
SQL
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Structure
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Data
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
CodeGen
Customize default options.
CodeGen
Restore default value
CSV
Customize default options.
CSV
CSV
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
CSV for MS Excel
Restore default value
Restore default value
Restore default value
Restore default value
LaTeX
Customize default options.
LaTeX
Restore default value
Restore default value
Structure
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Data
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Microsoft Office
Customize default options.
Microsoft Office
Microsoft Word 2000
Restore default value
Restore default value
Restore default value
OpenDocument
Customize default options.
OpenDocument
OpenDocument Spreadsheet
Restore default value
Restore default value
OpenDocument Text
Restore default value
Structure
Restore default value
Restore default value
Restore default value
Data
Restore default value
Restore default value
Texy! text
Customize default options
Texy! text
Restore default value
Data
Restore default value
Restore default value
Export method:
Format:
Tables:
Tables Structure Data
Select all
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
Output:
  • The size is measured in MiB.
Format-specific options:

CodeGen

CSV

CSV for MS Excel

JSON

LaTeX

Dump table
Object creation options
Data dump options

MediaWiki Table

Dump table

Microsoft Word 2000

Dump table
Data dump options

OpenDocument Spreadsheet

OpenDocument Text

Dump table
Object creation options
Data dump options

PDF

Dump table

PHP array

This format has no options

SQL

Object creation options
  • Add statements:
Data creation options
  • Syntax to use when inserting data:

Texy! text

Dump table
Data dump options

XML

Object creation options (all are recommended)
Data dump options

YAML

This format has no options