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 "payitsea_jnablr" database

Export defaults
Customise 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
Customise 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
Customise default options.
CodeGen
Restore default value
CSV
Customise 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
Customise 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
Customise default options.
Microsoft Office
Microsoft Word 2000
Restore default value
Restore default value
Restore default value
OpenDocument
Customise default options.
OpenDocument
Open-Document Spreadsheet
Restore default value
Restore default value
Open-Document Text
Restore default value
Structure
Restore default value
Restore default value
Restore default value
Data
Restore default value
Restore default value
Texy! text
Customise 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
a01_set_locations
a01_set_school_code
a01_set_school_info
a02_set_academic_year
a03_set_institutiontype
a04_set_course_group
a05_set_course_r_batch
a06_set_course_section
a07_set_course_r_batch_start_date
a07_set_header_group
a08_set_header
a09_set_lang_compit_list
a09_set_templates
a10_set_template_module
a11_set_ltnwise_assign_template
a12_set_ltnwise_asign_exam_grp
a13_set_ltnwise_asign_course_sec_grp
a14_set_ltnwise_asign_header
a15_set_ltnwise_asign_exam_grade_grp
a15_set_ltnwise_asign_exam_grade_grp_part_b
a16_set_ltnwise_asign_fee_grp
a17_set_ltnwise_remove_mob_menu
a18_set_ltnwise_asign_school_info
aa01_payroll_shift
aa01_payroll_shift_cron
aa02_payroll_shift_details
aa03_payroll_shift_halfday_value
aa04_payroll_salary_group
aa05_payroll_salary_group_earnings
aa06_payroll_salary_group_earnings_value
aa07_payroll_salary_group_deductions
aa08_payroll_salary_group_deductions_value
aa09_payroll_salary_group_tax
aa10_payroll_salary_group_tax_value
aa11_payroll_salary_advance
aa12_payroll_basic_salary
aa13_payroll_public_holidays
aa14_payroll_leave_types
aa15_payroll_assign_shifts
aa16_payroll_emp_leave_details
aa17_payroll_date_settings
aa18_payroll_weekends
aa19_payroll_report_formats
add_new_occupation
app_settings
attendancelog
attendancelog_bck
attendance_login_details
attendance_logout_details
b01_set_exam_parta_group
b01_set_exam_parta_terms
b02_set_exam_parta_mainactivity
b03_set_exam_parta_mainsubject
b04_set_exam_parta_coresubject
b05_set_exam_parta_subactivity
b06_set_exam_partbcd_type
b07_set_exam_partb_subjects
b08_set_exam_partbcd_activity
b09_set_exam_grade_method
b09_set_exam_grade_method_part_b
b09_set_exam_grade_method_view
b10_set_exam_grade_details
b10_set_exam_grade_details_part_b
b10_set_exam_grade_details_view
b11_set_compit_exam_master
b12_set_class_timetable_subject
b12_set_timetable_exams
b12_set_timetable_exam_details
b12_set_timetable_exam_subject
b12_set_timetable_notes
c01_aca_student_abstract_certificate
c01_aca_student_basic_details
c01_aca_student_study_certificate
c01_aca_student_transfer_certificate
c02_aca_student_other_details
c03_aca_student_custom_details
c05_aca_student_attendance_device
c06_aca_student_attendance
c06_aca_student_attendance_settings
c07_aca_student_apply_leave
c08_aca_student_attendance_verify
c08_attendance_verify_calendar_employee
c08_attendance_verify_calendar_student
c10_aca_student_application
c10_aca_student_application_online
c10_aca_student_application_online_payment_details
c11_aca_student_application_fee
c12_aca_main_events
c12_aca_sub_events
c13_aca_homework
c13_aca_homework_chapters
c13_aca_homework_done_students
c13_aca_homework_subject
c14_aca_gallery_album
c14_aca_homework_merged_pdf
c14_aca_photo_gallery
c14_aca_video_gallery
c14_aca_video_gallery_youtube
c15_aca_circular
c16_aca_public_holidays
d01_exam_parta_marks_entry
d02_exam_partbcd_marks_entry
d03_exam_parta_absentees
d04_exam_partb_absentees
d05_exam_health_status
d05_exam_remarks_entry
d05_marks_entry_history
d05_student_achivements_entry
d05_student_achivement_levels
d05_student_achivement_place
d05_student_achivement_portfolio
d05_student_remarks_category
d05_student_remarks_entry
d06_exam_attendance_entry
da8_co_scholastic_subjects
da8_exam_group
da8_exam_type
da8_scholastic_subjects
devices
e01_set_online_fee_group
e02_set_fee_feecategory
e02_set_online_fee_mainfee
e03_set_online_fee_payout_accounts
e03_set_online_fee_payout_splitdetails
e03_set_online_fee_subfee
e04_set_online_fee_feecategory
e05_set_fee_monthly_fee
e06_set_fee_months
e07_set_fee_monthlyfee_master
e08_set_fee_hostelfee
e08_set_fee_hostel_min_day_calc
e09_set_fee_hostelfee_master
e10_assign_hostel_to_students
e10_set_hostel_master
e10_set_online_fee_hostelfee_std_allot
e11_set_fee_individual_fee
e13_set_fee_individual_fee_assign_class
e13_set_hostel_fee_assign_class
e13_set_monthly_fee_assign_class
e13_set_online_fee_assign_feeto_class
e14_set_fee_individaul_fee_std_allot
e15_set_online_fee_transport_group
e16_set_fee_transport_min_day_calc
e17_set_fee_transport_months
e18_set_online_fee_transport_area
e19_set_online_fee_transport_area_amount
e20_set_online_fee_transport_assign_student
e21_fee_transcations
e22_fee_concession
f01_set_aca_bloodgroup
f02_set_aca_gender
f03_set_aca_caste
f04_set_aca_sub_caste
f05_set_aca_caste_category
f07_set_aca_oldnew
f08_set_aca_nationality
f09_set_aca_religion
f10_set_aca_attendance_sessions
f10_set_aca_attendance_value
f11_set_aca_attendance_data_fetch_type
f12_set_aca_mobile_app_type
f12_set_aca_mobile_menu
f13_set_aca_set_mobile_assign_menu
g01_set_emp_category
g02_set_emp_position
g03_set_emp_department
h01_emp_basic_details
h01_emp_documnet_details
h01_emp_language_details
h02_emp_batch_sec_permition
h02_emp_office_details
h03_emp_attendance
h04_emp_attendance_sessions
h05_emp_attendance_verify
h06_aca_emp_apply_leave
h06_emp_apply_leave
i01_set_payroll_emp_lop_wdays
i02_set_payroll_leave_types
i03_set_payroll_calc_settings
i04_set_payroll_salary_category
i05_set_payroll_salary_components
i06_set_payroll_gross_salary
j01_set_sms_category
j02_set_sms_category_message
j03_set_sms_sender_id
j04_set_sms_gateway
j04_set_sms_menu_list
k01_send_sms_details
k01_send_sms_details_individual
k01_sms_delivery_status
m01_set_omr_1-10
m01_set_omr_2-10
m02_set_omr_11-15
m03_set_omr_16-20
main_menu
mandatory_field_settings
mobile_menu_permission
mobile_menu_user_permission
omr_omrsms
opay_upi_response
otp_verify
parent_menu
pdf_list
report_login
report_user_login
sample_table
sb_ca_academics_classinfo
sb_ca_accounts_fee_master
sb_ca_accounts_hostel_transport_receiptformat
sb_ca_account_feetransaction_receipt
sb_ca_class_schoolname
sb_ca_settings_syllabusmaster
send_sms_status_record
sms_history
sub_menu
tally
user_menu_permission
user_role
user_role_permission
whatsapp_history
y01_eclass_category
y01_eclass_class
y01_eclass_subject
y02_eclass_chapters
y03_eclass_chapters_video
y03_eclass_chapters_video_youtube
y04_eclass_chapters_notes
y05_eclass_chapters_textbook
y11_eclass_test_questions
y12_eclass_test_choices
zoomtoken
zoom_credentials
zoom_credentials_web
z_dashboard_flashcard_wishes
z_mobile_aboutus
z_mobile_app_feedback
z_mobile_class_timetable
z_mobile_class_timetable_periods
z_mobile_class_timetable_update
z_mobile_eclass_menu_permission
z_mobile_emp_basic_details
z_mobile_emp_submenu_permission
z_mobile_exam_category
z_mobile_exam_result
z_mobile_fee_agreegator
z_mobile_fee_cal_conyenacefee
z_mobile_fee_ccavenue_payment_details
z_mobile_fee_transcations
z_mobile_fee_transcations_sessions1
z_mobile_fee_transcations_settlement
z_mobile_fee_transcations_status
z_mobile_flash_screen
z_mobile_help
z_mobile_home_menu_permission
z_mobile_live_class_groups
z_mobile_live_class_group_participants
z_mobile_live_class_hosts
z_mobile_live_class_schedule
z_mobile_logout_details
z_mobile_logout_schedule_date
z_mobile_menu_permission
z_mobile_notification
z_mobile_notification_individuals
z_mobile_online_exam_assign_pdfpaper
z_mobile_online_exam_assign_qtns
z_mobile_online_exam_category
z_mobile_online_exam_master
z_mobile_online_exam_master_omr
z_mobile_online_exam_master_omr_new
z_mobile_online_exam_omr_subjects
z_mobile_online_exam_omr_subjects_master
z_mobile_online_exam_std_upload_anspdf
z_mobile_online_exam_std_upload_anspdf_omr
z_mobile_online_exam_std_upload_anspdf_omrtempalte
z_mobile_online_exam_student_ans
z_mobile_online_fee_remarks
z_mobile_online_fixed_fee
z_mobile_online_fixed_fee_bck
z_mobile_online_fixed_fee_discount
z_mobile_online_fixed_fee_other
z_mobile_online_fixed_fee_tmp
z_mobile_online_oem_recent
z_mobile_online_oem_recent_omr
z_mobile_online_paying_amount
z_mobile_online_sub_fee_amount
z_mobile_online_upi_qrcode_details
z_mobile_question_paper_assign_qtns
z_mobile_question_paper_exam_master
z_mobile_question_paper_main_questions
z_mobile_question_paper_questions
z_mobile_reports
z_mobile_reports_user_group
z_mobile_student_basic_details
z_mobile_student_feedback_category
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