Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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 defaults

Customize default export options.

Quick
Custom
SQL

Customize default options.

Structure
Data
CodeGen

Customize default options.

CSV

Customize default options.

CSV
CSV for MS Excel
LaTeX

Customize default options.

Structure
Data
Microsoft Office

Customize default options.

Microsoft Word 2000
OpenDocument

Customize default options.

OpenDocument Spreadsheet
OpenDocument Text
Structure
Data
Texy! text

Customize default options

Data

Export templates:

New template:

Existing templates:

Export method:

Format:

Tables:

TablesStructureData
Select all
abg_settings
acceptissues
acceptissue_details
account_groups
addictions
addresses
adiagnosis
adjustmenttypes
adjust_stocks
adjust_stock_batches
adjust_stock_items
allergies
alternatitemdetails
alternatitems
anesthesias
anesthesia_details
anesthesia_records
anesthesia_record_grids
anesthesia_timings
antenatal_cares
antenatal_care_clinicals
antenatal_care_instructions
anticoagulants
asset_issue
asset_issue_details
asset_return
asset_return_details
assigncounters
assign_checkup_counters
assign_roles
authorizationglobalremarks
authorizationremarks
authorizations
authorizationtests
baby_notes
baseunits
batchdetails
batchissues
batch_issue_accepts
bd_totalquantities
bedallocations
bedcharges
bedcharge_details
beds
bedtypes
bills
bill_classes
birthdetails
block_masters
bloodbanks
bloodcancellations
bloodcomponents
blooddonors
bloodgroups
bloodprofiles
bloodreceives
bloodrejects
bloodsdetails
bloodsecurities
bloodsugars
bloodsugar_details
booking_status
branditems
brandnames
breasons
buckets
businessparameters
camp_contacts
camp_masters
camp_types
cancelappointments
categories
categoryrates
category_masters
category_types
cervicalthorasics
cfpreferances
checklists
checkup_counters
chemistries
cities
clientvisitdetails
clinicalfindings
closecntreports
closecounters
cnssidetails
comparatives
comparative_details
complications
componentdetails
consentdetails
consultations
consumables
consumable_batch_details
consumable_batch_entries
consumable_entries
consumable_item_entries
counsellings
counter_masters
countries
country_masters
create_vendor_quotations
create_vendor_quotation_details
creditnotes
creditnote_details
cssd_issues
cssd_issue_items
cssd_issue_processes
cssd_issue_process_items
cssd_item_storages
cssd_process_maps
cssd_process_masters
cssd_requests
cssd_request_items
cssd_schedules
cssd_schedule_details
cssd_schedule_transactions
cssd_schedule_transaction_items
cssd_sets
cssd_set_items
cssd_status_masters
cssd_sterile_methods
cssd_tech_masters
cssd_type_masters
cssd_user_process_maps
currentmedications
current_medications
dailyappointments
dailybedcensus
dailyregistrations
dailyserviceorders
dappointments
day_care_pre_beds
day_care_pre_bed_slots
dcupdates
deathpostings
deaths
death_permanent_adds
death_police_cases
death_present_adds
death_responsible_adds
debitnotes
debitnote_details
department_masters
designations
designation_details
devtests
diagnoses
diagnsspreferances
diet_assessments
diet_assessment_details
diet_assessment_lab_details
diet_schedulers
diet_tickets
diet_ticket_details
dischargesummaries
discharge_medicines
disposable_items
districts
doctorcommisions
doctorcommision_details
doctorconsdetails
doctorconsultations
doctortypeforms
doctor_masters
doctor_progress_forms
documents
document_masters
donors
drgroups
drugissuebalanceitems
drugissueitems
drugissueothers
drugissues
drugissue_amounts
drugissue_batch_issues
drugissue_details
drugorders
drugorder_details
drugs
drug_administrations
drug_administration_details
dvoucherdetails
employees
employee_masters
emrnotes
emrs
emr_allergynotes
emr_anticoagulantnotes
emr_dietplans
emr_extranotes
emr_fhnotes
emr_generalnotes
emr_ivdailynotes
emr_problems
emr_ptatgnotes
ERwe
evaluation_masters
eye_operations
familyhistories
fbills
finalbills
finalbill_bed_details
finalbill_details
finalbill_doc_details
finalbill_rev_details
finalbill_voucher_details
fixedvalues
follicle_masters
followupreports
food_groups
food_item_masters
foreigners
forms
generalnotes
generalnoticeboards
general_payment_receipts
generics
grade_details
grade_masters
grouporganismlinks
grouporganismlink_details
group_masters
gynaecologies
gynaecology_instructions
homes
hourlyservices
ifirsts
indents
indent_details
input_output_tax_masters
insurances
insurance_details
insurance_masters
intakes
intake_details
intake_iv_masters
intake_masters
intrimbills
intubations
ipadmissionlists
ipadmissions
ipadmission_beds
ipadmission_numbers
ipbillheaders
ipdtreatments
ipd_bedcharges
ipd_house_keeping_remarks
ipd_nurse_notes
ipd_nurse_note_diagnoses
ipd_nurse_note_diagnose_logs
ipd_nurse_note_dialysis_diets
ipd_nurse_note_dialysis_diet_logs
ipd_nurse_note_indwellings
ipd_nurse_note_indwelling_logs
ipd_nurse_note_logs
ipd_nurse_note_surgeries
ipd_nurse_note_surgery_logs
ipd_nurse_note_vital_signs
ipd_nurse_note_vital_sign_logs
ipmanagements
ipservices
ip_bed_charge_postings
iseconds
issuebloodbanks
issueindents
issueindent_details
itembrands
itemdetails
itemforms
itemnames
items
itemtaxes
itemtypeforms
itemtypes
item_details
ithirds
ivf_cares
ivf_care_instructions
ivf_follicles
ivf_follicle_headers
ivf_follicle_options
jobsites
job_types
labgroups
laboratories
labour_checklists
labour_safety_checklists
labreports
labs
labtests
labtypes
lab_machine_masters
lab_method_masters
laundry_masters
laundry_master_details
laundry_receives
laundry_receive_details
laundry_washlines
laundry_washline_details
lenses
levels
level_schedules
level_schedule_details
level_schedule_entries
level_sections
level_section_mappings
linkservforms
locations
logcalerrors
log_ivf_cares
log_ivf_care_instructions
loundry_patient_requests
loundry_patient_request_details
loundry_rate_masters
loundry_receives
loundry_receive_details
loundry_schedules
loundry_schedule_details
lowerextremities
lservices
lumberspineevoluations
majerminer_masters
majors
manufacturers
map_vendors
map_vendor_details
master_anaesthesist_rates
master_captions
master_forms
master_instructions
master_resultformats
master_resultformat_options
master_vouchers
master_voucher_details
master_voucher_types
material_receipt_notes
material_receipt_note_batch_details
material_receipt_note_details
mbresulttryentries
mdpreferances
medicalhistories
medication_groups
medication_group_details
medicines
medicine_items
medicolegals
microbrentries
modules
monitorings
mpayment_details
mrdetails
mrsearches
msbs
msb_dependends
musculoskelevalutions
name_masters
nondisposable_items
nursemasters
nursenotes
nurse_progress_forms
obstetrical_histories
obstetrical_history_details
onlytest
opds
opd_vital_signs
opencounters
operationdetails
operationmasters
operationnotes
operations
operation_anesthesias
operation_anesthesiastypes
operation_procs
operation_surgeons
operation_techinicians
operation_timings
opiptestorders
OPS
opservices
opthal_masters
organizations
organization_details
orginisms
org_authorities
orthopfirstnotes
orthoponenotes
orthoprogressnotes
orthopthreenotes
orthoptwonotes
otbooks
otbook_slots
otexpenses
other_details
outpatients
outpatient_numbers
outpatient_refers
packages
package_doctor_visits
package_group_masters
package_laboratories
package_medicines
package_other_charges
package_other_services
package_payment_details
package_radiologies
package_rooms
package_services
package_surgeries
package_transfers
package_voucher_details
package_voucher_headers
pac_details
pages
pappointments
partpayments
partpreports
patientaccounts
patientdetails
patientdischarges
patientintakes
patientreactions
patienttransfers
patient_advances
patient_ot_schedules
paymentreversals
payment_details
payment_numbers
payment_procedures
payment_receipt_details
payment_receipt_transactions
payment_terms
payment_transfers
pay_outs
pay_out_cals
pay_out_cal_pays
pay_out_doctor_pay_outs
pay_out_ot_pay_outs
pay_out_radio_pay_outs
pay_out_service_pay_outs
pediatrics
pediatric_histories
pediatric_instructions
pomaterial_receipt_notes
pomaterial_receipt_note_batch_details
pomaterial_receipt_note_details
posta
postanesthesias
postopconditions
postopcondition_inouts
posts
ppreports
pptestreports
preanesthesias
prefixes
preflabtests
premedications
premedication_drugs
prenatal_or_antinatal_progresses
prenatal_progresses
prenatal_progress_details
preoperationorders
preoperative_checklists
preopnotes
prescriptions
prevanesthesias
prevhistories
prevmedications
pre_diseases
problems
profiletestlinks
profiletestlink_details
proftests
ptactnotes
purchase_orders
purchase_order_details
purchase_requisitions
purchase_requisition_details
purch_account_ledgers
purch_categories
purch_tds_classification_detail_masters
purch_tds_classification_masters
purch_tds_deducti_types
purch_vendor_contact_people
purch_vendor_general_details
purch_vendor_taxation_details
p_package_docs
p_package_doc_details
p_package_labs
p_package_lab_details
p_package_meds
p_package_med_details
p_package_others
p_package_other_details
p_package_procs
p_package_proc_details
p_package_radios
p_package_radio_details
p_package_regs
p_package_rooms
p_package_room_details
p_package_surgs
p_package_surg_details
radiologyresults
radiologytestpics
radiologytests
radiologytest_details
radiology_schedules
radreports
rates
reasons
refers
registrations
registration_numbers
registration_packages
registration_treatment_cost_n_estimations
regreports
regstatics
reports
requisitions
requisition_details
respaddresses
resulttryentries
resulttrytests
returntypes
reversaldetails
reversals
reversal_numbers
rolemasters
rolemaster_details
roles
rolestorelinks
rooms
ropresults
rosterdetails
rosterdetails_0910
rostermasters
rostermasters_0910
rpaneltests
rservices
salary_allowances
salary_deductions
salary_structures
samplecollections
samplectests
samples
sappointments
sequences
services
service_categories
settings
shifts
sitembrands
sitembrands_copy
sitemdetails
sitemdetails_copy
sitemheaders
sitemheaders_copy
slot_times
smajors
sorders
specilizations
srdetailreports
staff_fund_payouts
standardvalues
states
storebatchdetails
storecounters
storeitems
store_masters
strength_contents
subcodes
sub_group_masters
suppliermajors
suppliers
supplierstores
surgeonnotes
surgicalhistories
surgical_safety_checklists
symptoms
symptpreferances
tablename1
tax_masters
tax_masters_original
tax_master_services
test
testcsv
testorders
testpanels
testparameterlinks
testparameters
testreversals
tests
theaterdetails
theaters
theater_schedules
third_isolates
tpas
tpa_approvals
tpa_approval_details
tpa_approval_payments
tpa_approval_service_details
tpr_entries
transfusions
transporter_masters
treatments
treatment_clinical_findings
treatment_cost_n_estimations
treatment_cost_n_estimation_surgeries
treatment_diagnoses
treatment_final_diagnoses
treatment_medicines
treatment_medicine_others
treatment_symptoms
treatment_test_profiles
under_conditions
under_terms
unit_codes
uperextremities
user
userlabtests
userrolls
userrolls_nurse_sttns
user_locations
user_logs
user_payment_transfers
user_wise_queries
uwregistrations
vaccine_masters
vaccine_schedule_charts
vaccine_schedule_chart_details
vaccine_schedule_descriptions
vaccine_times
vacutainers
va_auto_refs
va_auto_refs_masters
va_checkups
va_diluted_accepts
va_diluted_masters
va_diseases
va_doctors
va_doctor_heads
va_doctor_vision_heads
va_entries
va_entry_details
va_entry_masters
va_medicals
va_refraction_masters
va_refrections
va_refrection_details
va_retinoscopies
va_retinoscopy_masters
vdetailreports
ventilators
ventilator_logs
vision_counter_masters
voucherlists
voucherreversals
voucher_details
voucher_diets
voucher_discounts
voucher_discount_approvals
voucher_discount_approval_details
voucher_headers
voucher_sequences
vprevreports
vrevreports
wards
wardtowardbatches
wardtowards
wardtowardstores
wdiagnosis
wings
z_log_acceptissue_details
z_log_addresses
z_log_assigncounters
z_log_batchdetails
z_log_bedcharges
z_log_bedcharge_details
z_log_beds
z_log_bedtransfers
z_log_birthdetails
z_log_categoryrates
z_log_closecounters
z_log_dischargesummaries
z_log_doctorconsdetails
z_log_doctorconsultations
z_log_drugissue_batch_issues
z_log_drugissue_details
z_log_finalbills
z_log_finalbill_details
z_log_ipadmissions
z_log_itemforms
z_log_mpayment_details
z_log_opservices
z_log_outpatients
z_log_packages
z_log_package_doctor_visits
z_log_package_laboratories
z_log_package_medicines
z_log_package_other_charges
z_log_package_radiologies
z_log_package_rooms
z_log_package_surgeries
z_log_partpayments
z_log_patientdischarges
z_log_paymentreversals
z_log_payment_details
z_log_payment_receipt_details
z_log_payment_receipt_transactions
z_log_registrations
z_log_storeitems
z_log_treatments
z_log_treatment_clinical_findings
z_log_treatment_cost_n_estimations
z_log_treatment_diagnoses
z_log_treatment_final_diagnoses
z_log_treatment_medicines
z_log_treatment_medicine_others
z_log_treatment_symptoms
z_log_treatment_test_profiles
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name

Output:

MiB

Format-specific options:

Scroll down to fill in the options for the selected format and ignore the options for other formats.

PDF

Dump table

CSV

CodeGen

LaTeX

Dump table

Object creation options

Data dump options

PHP array

This format has no options

SQL

Object creation options

  • Add statements:

Data creation options

  • Instead of INSERT statements, use:

  • Syntax to use when inserting data:

YAML

This format has no options

Microsoft Word 2000

Dump table

Data dump options

JSON

XML

Object creation options (all are recommended)

Data dump options

MediaWiki Table

Dump table

OpenDocument Text

Dump table

Object creation options

Data dump options

CSV for MS Excel

OpenDocument Spreadsheet

Texy! text

Dump table

Data dump options

Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): MySQL server has gone away

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'roles_mapping\' ORDER BY Name ASC',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'roles_mapping\' ORDER BY Name ASC',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'roles_mapping\' ORDER BY Name ASC',
NULL,
integer 0,
boolean false,
)
./libraries/DatabaseInterface.class.php#570: PMA_DatabaseInterface->fetchResult(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'roles_mapping\' ORDER BY Name ASC',
array,
NULL,
NULL,
)
./libraries/Table.class.php#321: PMA_DatabaseInterface->getTablesFull(
string 'mysql',
string 'roles_mapping',
)
./libraries/controllers/DatabaseStructureController.class.php#294: PMA_Table->getStatusInfo(
NULL,
boolean true,
)
./db_structure.php#54: PMA\Controllers\DatabaseStructureController->indexAction()
Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): Error reading result set's header

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'roles_mapping\' ORDER BY Name ASC',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'roles_mapping\' ORDER BY Name ASC',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'roles_mapping\' ORDER BY Name ASC',
NULL,
integer 0,
boolean false,
)
./libraries/DatabaseInterface.class.php#570: PMA_DatabaseInterface->fetchResult(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'mysql\') AND t.`TABLE_NAME` COLLATE utf8_bin = \'roles_mapping\' ORDER BY Name ASC',
array,
NULL,
NULL,
)
./libraries/Table.class.php#321: PMA_DatabaseInterface->getTablesFull(
string 'mysql',
string 'roles_mapping',
)
./libraries/controllers/DatabaseStructureController.class.php#294: PMA_Table->getStatusInfo(
NULL,
boolean true,
)
./db_structure.php#54: PMA\Controllers\DatabaseStructureController->indexAction()
Warning in ./libraries/dbi/DBIMysqli.class.php#261
Error while sending QUERY packet. PID=351465

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string ' SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = \'mysql\' AND table_name = \'roles_mapping\' ORDER BY version DESC',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string ' SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = \'mysql\' AND table_name = \'roles_mapping\' ORDER BY version DESC',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#94: PMA_DatabaseInterface->tryQuery(
string ' SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = \'mysql\' AND table_name = \'roles_mapping\' ORDER BY version DESC',
object,
integer 0,
boolean false,
)
./libraries/relation.lib.php#38: PMA_DatabaseInterface->query(
string ' SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = \'mysql\' AND table_name = \'roles_mapping\' ORDER BY version DESC',
object,
integer 0,
boolean false,
)
./libraries/Tracker.class.php#143: PMA_queryAsControlUser(string ' SELECT tracking_active FROM `phpmyadmin`.`pma__tracking` WHERE db_name = \'mysql\' AND table_name = \'roles_mapping\' ORDER BY version DESC')
./libraries/controllers/DatabaseStructureController.class.php#447: PMA_Tracker::isTracked(
string 'mysql',
string 'roles_mapping',
)
./db_structure.php#54: PMA\Controllers\DatabaseStructureController->indexAction()