Recent
Favorites

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

Database structure

Choose which details to show in the database structure (list of tables).

Documentation Show or hide a column displaying the charset for all tables.
Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
Filters
Table Ascending Descending Replication Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
admission_intake   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 35 InnoDB latin1_swedish_ci 16 KiB -
attendance   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~187,465 InnoDB latin1_swedish_ci 31.6 MiB -
bus_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 48 InnoDB latin1_swedish_ci 16 KiB -
ci_sessions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 19 InnoDB latin1_swedish_ci 16 KiB -
courses   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,964 InnoDB latin1_swedish_ci 1.7 MiB -
course_allocation   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 11,385 InnoDB latin1_swedish_ci 3.8 MiB -
course_materials   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 303 InnoDB utf8_general_ci 64 KiB -
course_registration   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 17,899 InnoDB latin1_swedish_ci 1.8 MiB -
curriculum   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,113 InnoDB latin1_swedish_ci 288 KiB -
departments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 91 InnoDB latin1_swedish_ci 32 KiB -
employee_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,346 InnoDB latin1_swedish_ci 1.6 MiB -
employee_it_assessment   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~201,749 InnoDB latin1_swedish_ci 25.5 MiB -
employee_it_columns   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 85 InnoDB latin1_swedish_ci 16 KiB -
employee_other_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,216 InnoDB latin1_swedish_ci 384 KiB -
employee_salary_contributions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 12,620 InnoDB latin1_swedish_ci 1.8 MiB -
employee_salary_deductions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 10,163 InnoDB latin1_swedish_ci 1.8 MiB -
employee_salary_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 15,008 InnoDB latin1_swedish_ci 1.9 MiB -
employee_salary_recovery   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,332 InnoDB latin1_swedish_ci 640 KiB -
employee_salary_recovery_others   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9,565 InnoDB latin1_swedish_ci 1.7 MiB -
entrance_19   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 28,240 InnoDB utf8_general_ci 5.5 MiB -
fauclyit   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,455 InnoDB latin1_swedish_ci 368 KiB -
fee_amounts   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 22 InnoDB latin1_swedish_ci 64 KiB -
fee_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~62,482 InnoDB latin1_swedish_ci 18.1 MiB -
fee_structure_pg   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 242 InnoDB latin1_swedish_ci 112 KiB -
fee_structure_phd   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 66 InnoDB latin1_swedish_ci 64 KiB -
fellowships   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 44 InnoDB latin1_swedish_ci 16 KiB -
geocode   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 36 InnoDB latin1_swedish_ci 16 KiB -
grades   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16 InnoDB latin1_swedish_ci 32 KiB -
iqac_assessment   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,622 InnoDB latin1_swedish_ci 1.5 MiB -
iqac_evoluation   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 24,900 InnoDB latin1_swedish_ci 5.5 MiB -
iqac_student_evoluation   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 30,967 InnoDB latin1_swedish_ci 3.5 MiB -
marks   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~230,553 InnoDB latin1_swedish_ci 47.1 MiB -
number_definition   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 242 InnoDB latin1_swedish_ci 80 KiB -
other_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB latin1_swedish_ci 48 KiB -
pan_tmp   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 841 InnoDB latin1_swedish_ci 96 KiB -
payment_bill_desk   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~86,094 InnoDB latin1_swedish_ci 65.1 MiB -
payment_indian_bank   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,924 InnoDB latin1_swedish_ci 7.7 MiB -
phd_examiners   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,619 InnoDB latin1_swedish_ci 272 KiB -
programs   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 153 InnoDB latin1_swedish_ci 64 KiB -
registered_19   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 41,156 InnoDB utf8_general_ci 17.1 MiB -
registered_19_1   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 41,155 InnoDB utf8_general_ci 19.6 MiB -
research_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 8 InnoDB latin1_swedish_ci 64 KiB -
result   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 522 InnoDB latin1_swedish_ci 96 KiB -
scholarship_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 22 InnoDB utf8_general_ci 16 KiB -
schools   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 13 InnoDB latin1_swedish_ci 32 KiB -
settings   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 10 InnoDB latin1_swedish_ci 16 KiB -
students   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 15,282 InnoDB latin1_swedish_ci 4.7 MiB -
students_admitted_19   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,367 InnoDB utf8_general_ci 1.5 MiB -
students_admitted_19_1   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 326 InnoDB utf8_general_ci 112 KiB -
students_phd   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,592 InnoDB latin1_swedish_ci 704 KiB -
students_phd_registered   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 678 InnoDB latin1_swedish_ci 224 KiB -
student_activity   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~360,521 InnoDB latin1_swedish_ci 65.6 MiB -
student_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 15,206 InnoDB latin1_swedish_ci 9.4 MiB -
student_timeline   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 25,116 InnoDB latin1_swedish_ci 7.8 MiB -
system_messages   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 11 InnoDB latin1_swedish_ci 48 KiB -
time_slot   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 54 InnoDB latin1_swedish_ci 16 KiB -
users   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,973 InnoDB utf8_unicode_ci 1.7 MiB -
users_tmp   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,036 InnoDB latin1_swedish_ci 1.5 MiB -
user_activity   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~59,952 InnoDB latin1_swedish_ci 11.5 MiB -
user_details   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,229 InnoDB latin1_swedish_ci 608 KiB -
user_role   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 26 InnoDB latin1_swedish_ci 16 KiB -
61 tables Replication Sum ~1,533,180 InnoDB latin1_swedish_ci 372.2 MiB 0 B
With selected:

Print Print Data dictionary Data dictionary

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