Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: pu_sms_beta
Page-related settingsClick 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

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
admission_intake
attendance
bus_details
ci_sessions
courses
course_allocation
course_materials
course_registration
curriculum
departments
employee_details
employee_it_assessment
employee_it_columns
employee_other_payments
employee_salary_contributions
employee_salary_deductions
employee_salary_payments
employee_salary_recovery
employee_salary_recovery_others
entrance_19
fauclyit
fee_amounts
fee_details
fee_structure_pg
fee_structure_phd
fellowships
geocode
grades
iqac_assessment
iqac_evoluation
iqac_student_evoluation
marks
number_definition
other_details
pan_tmp
payment_bill_desk
payment_indian_bank
phd_examiners
programs
registered_19
registered_19_1
research_details
result
scholarship_details
schools
settings
students
students_admitted_19
students_admitted_19_1
students_phd
students_phd_registered
student_activity
student_details
student_timeline
system_messages
time_slot
users
users_tmp
user_activity
user_details
user_role
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

mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.