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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





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

Export Exporting tables from "rajkamal_crm_schema_backup_20260919" 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 templates:
New template:
Existing templates:
Export method:
Format:
Tables:
Tables Structure Data
Select all
alert_logs
api_student
audit_logs
auth_group
auth_group_permissions
auth_login_otps
auth_permission
auth_user
auth_user_aliases
auth_user_groups
auth_user_user_permissions
bank_master
call_followup_master
caste_category
cnc_jobs
cnc_job_parts
cnc_production_gallery_files
cnc_production_gallery_files_backup_20260818-214821
cnc_production_gallery_files_backup_20260818_171615
cnc_production_gallery_files_backup_20260818_172626
contra_vouchers
coupon_limits
coupon_redemptions
crm_brochure_queue
crm_customer_role
crm_enquiry_links_old)
crm_leads
crm_lead_sources
crm_lead_stages
crm_quotations
crm_service_details
crm_service_types
crm_tasks
crm_tickets
crm_tickets_exchange_machine_details
crm_ticket_sales
crm_ticket_service
crm_ticket_status
crm_ticket_status_old
crm_visits
customer_segment
customer_tracking_locations
daily_financial_summary
daily_ledger_balance
daily_ledger_movement
dashboard_monthly_summary
dashboard_summary_snapshot
dashboard_yearly_summary
date_range_filters
discount_calculation_sheets
discount_calculation_sheet_rows
discount_categories
discount_credit_note_entries
discount_credit_note_entry_items
discount_rebate_approvals
discount_rebate_approval_rules
discount_rebate_claims
discount_rebate_claim_events
discount_rebate_claim_number_series
discount_rebate_config_audit
discount_rebate_credit_allocations
discount_rebate_credit_note_cancellations
discount_rebate_credit_note_cancellation_events
discount_rebate_credit_note_links
discount_rebate_customer_agreements
discount_rebate_document_reviews
discount_rebate_gst_credit_note_generations
discount_rebate_gst_hsn_plan_lines
discount_rebate_gst_plan_runs
discount_rebate_gst_posting_plan_lines
discount_rebate_gst_posting_runs
discount_rebate_gst_posting_run_lines
discount_rebate_gst_reversal_compliance
discount_rebate_gst_reversal_compliance_events
discount_rebate_gst_source_trace
discount_rebate_invoice_allocations
discount_rebate_itc_evidence
discount_rebate_itc_tracking
discount_rebate_itc_tracking_audit
discount_rebate_posting_runs
discount_rebate_posting_run_lines
discount_rebate_reversal_allocation_lines
discount_rebate_reversal_events
discount_rebate_reversal_outstanding_lines
discount_rebate_reversal_periods
discount_rebate_reversal_period_events
discount_rebate_reversal_runs
discount_rebate_reversal_run_lines
discount_rebate_reversal_settings
discount_rebate_schemes
discount_rebate_scheme_slabs
discount_rebate_scheme_targets
discount_rebate_settings
discount_rebate_tax_allocations
discount_rule_targets
dispatch_details
django_admin_log
django_content_type
django_migrations
django_session
dynamic_pricing_source_cache
dynamic_sales_price_competitor_prices
dynamic_sales_price_competitor_rules
dynamic_sales_price_configs
dynamic_sales_price_discounts
dynamic_sales_price_margin_rules
dynamic_sales_price_rules_v2
dynamic_sales_price_rule_audit_v2
einvoices_eway_bill
einvoices_eway_log
einvoice_eway_cancellation
email_scraper_documents
email_scraper_invoices
email_scraper_messages
email_scraper_profiles
email_scraper_users
email_smtp_settings
employees
employee_location_points
employee_tracking_capture_policy
employee_tracking_commands
employee_tracking_sessions
employee_tracking_settings
employee_tracking_test_allowlist
employee_visit_tracking
exchange_items
exchange_items_value
expense_entries
expense_entry_items
expense_invoice_discounts
expense_voucher
expense_voucher_allocations
expense_voucher_allocations_deleted
e_invoice_details
final_ledger_balance
final_ledger_balance_del
financial_years
gst_api_credentials
gst_authcode
gst_registration_types
invoice_inbox_accounts
invoice_outstanding
invoice_print_settings
invoice_settings
items
items_branchwise_details
items_brands
items_category
items_category_discounts_map
items_company
items_delivery_sources
items_discount_categories
items_discount_types
items_godowns
items_hsn_sac_deleted
items_opening_stock
items_scheme_discounts
items_stock_ledger
items_stock_summary
items_tax_hsn_sac
items_uom
item_batch_daily_movement
item_daily_movement
item_daily_movement_dirty
item_daily_movement_rebuild_log
item_effective_pricing
item_stock_summary
item_transactions
journal_vouchers
journal_voucher_lines
ledger_bank_accounts
ledger_contact_details
ledger_details
ledger_entries_cash
ledger_groups
ledger_keys
ledger_opening_balances
ledger_party_shipping_details
ledger_postings
ledger_postings_audit
ledger_shipping_details
ledger_transactions
ledger_types_deleted
mastergst_tokens
message_queue
mobile_api_auth_attempts
mobile_api_devices
mobile_api_sessions
mobile_crm_ticket_links
mobile_customer_statement_shares
mobile_field_operations
mobile_field_operation_attachments
mobile_notification_reads
monthly_financial_summary
parts
parts_backup_20260818_170943
parts_backup_20260818_172626
parts_backup_20260818_173857
party_comments
party_type
payment_details_draft
payment_followup
payment_followup_status
payment_purchase_mapping
payment_types
payment_vouchers
payment_voucher_allocations
plant_details
postings_audit_log
posting_audit_log
posting_control
posting_period_control
pricing_recompute_queue
purchase_entries
purchase_entries_old
purchase_entry_items
purchase_entry_items_old
purchase_invoice_discounts
purchase_orders
purchase_order_items
purchase_received_details_deleted
purchase_reorder_vendor_mapping
purchase_returns
purchase_return_items
purchase_return_items_old
purchase_return_old
qr_payment
qr_payment_callback
quotation_entries
quotation_entry_items
receipt_sales_mapping
receipt_vouchers
receipt_voucher_allocations
report_data_entries
sales_cancelled_entries
sales_entries
sales_entry_items
sales_invoice_discounts
sales_invoice_exchange
sales_invoice_other_discounts
sales_invoice_subsidy
sales_returns
sales_return_items
sales_return_reasons
sales_settings
sales_targets
sample_table
setting_allowed_ips
setting_branch_details
setting_countries
setting_district
setting_main_menu
setting_states
setting_sub_menu
stock_movement
stock_movement_items
stock_po_requisitions
stock_po_requisition_items
stock_po_vendor_allocations
stock_po_vendor_item_rates
subsidy_receipt_vouchers
subsidy_receipt_voucher_allocations
subsidy_schemes
subsidy_scheme_application_form
subsidy_scheme_documents
subsidy_scheme_general_caste_rule
subsidy_scheme_items
subsidy_scheme_items_amount
sub_item
tally_posted_rows
tally_posting_issues
tally_source_batches
tally_source_raw10
tally_source_typed
tally_transactions
tds_cumulative
tds_deductions
tds_master
telephony_calls
telephony_call_events
topbar_order_backup_20260823_120047
transaction_additional_charges
transaction_drafts
transaction_draft_components
transaction_draft_items
transaction_expenditure_categories
transaction_expenditure_vouchers
transaction_idempotency_keys
transaction_payment_vouchers_expense
transaction_receipt_vouchers_old
transaction_safety_events
universal_discount_rules
users_del
user_branches
user_details
user_favorites
user_financial_years
user_permissions
user_roles
voucher_additional_charges
voucher_numbering_config
voucher_series_master
voucher_series_master_old
voucher_taxes
voucher_types
voucher_types_old
voucher_type_ledger_mappings
whatsapp_settings
yearly_financial_summary
z_bak_cleanup_20260905_b1fy13_att
z_bak_cleanup_20260905_b1fy13_ops
z_bak_mcrm_20260905_operations
z_bak_mcrm_20260905_sales
z_bak_mcrm_20260905_service
z_bak_mcrm_20260905_tickets
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