Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: abcschool333
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 defaults

Customise default export options.

Quick
Custom
SQL

Customise default options.

Structure
Data
CodeGen

Customise default options.

CSV

Customise default options.

CSV
CSV for MS Excel
LaTeX

Customise default options.

Structure
Data
Microsoft Office

Customise default options.

Microsoft Word 2000
OpenDocument

Customise default options.

Open-Document Spreadsheet
Open-Document Text
Structure
Data
Texy! text

Customise default options

Data

Export templates:

New template:

Existing templates:

Export method:

Format:

Tables:

TablesStructureData
Select all
attendence_type
books
book_issues
categories
certificates
chat_messages
chat_users
classes
class_sections
class_teacher
complaint
complaint_type
contents
content_for
custom_fields
custom_field_values
department
disable_reason
dispatch_receive
email_config
enquiry
enquiry_type
events
exams
exam_groups
exam_group_class_batch_exams
exam_group_class_batch_exam_students
exam_group_class_batch_exam_subjects
exam_group_exam_connections
exam_group_exam_results
exam_group_students
exam_results
exam_schedules
expenses
expense_head
feecategory
feemasters
fees_discounts
fees_reminder
feetype
fee_groups
fee_groups_feetype
fee_receipt_no
fee_session_groups
follow_up
front_cms_media_gallery
front_cms_menus
front_cms_menu_items
front_cms_pages
front_cms_page_contents
front_cms_programs
front_cms_program_photos
front_cms_settings
general_calls
grades
homework
homework_evaluation
hostel
hostel_rooms
id_card
income
income_head
item
item_category
item_issue
item_stock
item_store
item_supplier
languages
leave_types
libarary_members
logs
messages
migrations
multi_class_students
notification_roles
notification_setting
onlineexam
onlineexam_attempts
onlineexam_questions
onlineexam_students
onlineexam_student_results
online_admissions
payment_settings
payslip_allowance
permission_category
permission_group
permission_parent
permission_student
print_headerfooter
questions
question_answers
question_options
read_notification
reference
roles
roles_permissions
room_types
school_houses
sch_settings
sections
send_notification
Defined aliases
Define new aliases

Output:

MiB

Format-specific options:

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

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