Recent
Favorites

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sams
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 Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 166 InnoDB latin1_swedish_ci 32 KiB -
affliated_colleges Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 125 InnoDB latin1_swedish_ci 16 KiB -
affliated_programs Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 333 InnoDB latin1_swedish_ci 48 KiB -
affliated_results Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,119 InnoDB latin1_swedish_ci 2.5 MiB -
attendance Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~427,353 InnoDB latin1_swedish_ci 115.8 MiB -
billdesk Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 288 InnoDB utf8_general_ci 80 KiB -
bus_details Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 48 InnoDB latin1_swedish_ci 16 KiB -
campus_connect Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,251 InnoDB utf8_general_ci 416 KiB -
ci_sessions Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 464 InnoDB latin1_swedish_ci 208 KiB -
cont_emp Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 79 InnoDB latin1_swedish_ci 16 KiB -
courses Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,543 InnoDB latin1_swedish_ci 1.7 MiB -
course_allocation Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 23,687 InnoDB latin1_swedish_ci 11 MiB -
course_materials Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 501 InnoDB utf8_general_ci 96 KiB -
course_registration Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 31,788 InnoDB latin1_swedish_ci 3 MiB -
covid_info Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 10,468 InnoDB latin1_swedish_ci 2.5 MiB -
curriculum Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,326 InnoDB latin1_swedish_ci 784 KiB -
departments Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 114 InnoDB latin1_swedish_ci 32 KiB -
employee_details Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,512 InnoDB latin1_swedish_ci 1.6 MiB -
employee_it_assessment Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~694,867 InnoDB latin1_swedish_ci 106.2 MiB -
employee_it_columns Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 361 InnoDB latin1_swedish_ci 112 KiB -
employee_it_columns_pbr Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 359 InnoDB latin1_swedish_ci 96 KiB -
employee_other_payments Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 27,466 InnoDB latin1_swedish_ci 4 MiB -
employee_salary_contributions Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~51,217 InnoDB latin1_swedish_ci 6 MiB -
employee_salary_deductions Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 44,903 InnoDB latin1_swedish_ci 5 MiB -
employee_salary_payments Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~64,246 InnoDB latin1_swedish_ci 8 MiB -
employee_salary_recovery Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 24,679 InnoDB latin1_swedish_ci 3 MiB -
employee_salary_recovery_others Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 38,802 InnoDB latin1_swedish_ci 6 MiB -
emptable Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 929 InnoDB latin1_swedish_ci 128 KiB -
emp_detail_may23 Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 896 InnoDB latin1_swedish_ci 128 KiB -
emp_emmail Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 306 InnoDB latin1_swedish_ci 96 KiB -
entrance Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 34,652 InnoDB latin1_swedish_ci 7.5 MiB -
entrance_19 Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 28,240 InnoDB utf8_general_ci 5.5 MiB -
feedform Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,046 InnoDB latin1_swedish_ci 432 KiB -
fee_amounts Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 30 InnoDB latin1_swedish_ci 64 KiB -
fee_details Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~151,342 InnoDB latin1_swedish_ci 40.1 MiB -
fee_structure_pg Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 511 InnoDB latin1_swedish_ci 144 KiB -
fee_structure_pg_revised_2020 Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 242 InnoDB latin1_swedish_ci 112 KiB -
fee_structure_phd Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 95 InnoDB latin1_swedish_ci 64 KiB -
fellowships Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 45 InnoDB latin1_swedish_ci 16 KiB -
file_details Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 740 InnoDB latin1_swedish_ci 112 KiB -
file_movement Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 20,735 InnoDB latin1_swedish_ci 2 MiB -
folio Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~76,042 InnoDB utf8_general_ci 5.5 MiB -
geocode Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 36 InnoDB latin1_swedish_ci 16 KiB -
grades Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16 InnoDB latin1_swedish_ci 32 KiB -
hostel_fee_amounts Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB latin1_swedish_ci 64 KiB -
iqac_assessment Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,719 InnoDB latin1_swedish_ci 2.5 MiB -
iqac_evoluation Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~72,215 InnoDB latin1_swedish_ci 7.5 MiB -
iqac_student_evoluation Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~231,109 InnoDB latin1_swedish_ci 20.5 MiB -
marks Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~474,973 InnoDB latin1_swedish_ci 99.2 MiB -
monthly_attendance Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,500 InnoDB latin1_swedish_ci 1.5 MiB -
number_definition Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 377 InnoDB latin1_swedish_ci 96 KiB -
otherpay_apr23_1 Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 78 InnoDB latin1_swedish_ci 16 KiB -
other_details Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB latin1_swedish_ci 48 KiB -
payment_bill_desk Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~220,780 InnoDB latin1_swedish_ci 184.2 MiB -
payment_indian_bank Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,924 InnoDB latin1_swedish_ci 7.7 MiB -
pension Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 303 InnoDB latin1_swedish_ci 64 KiB -
pension_details Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 447 InnoDB latin1_swedish_ci 256 KiB -
phd_examiners Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,999 InnoDB utf8_general_ci 2.5 MiB -
programs Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 176 InnoDB latin1_swedish_ci 112 KiB -
pu_results Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9,157 InnoDB utf8_general_ci 3.2 MiB -
ration_details Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 338 InnoDB utf8_general_ci 80 KiB -
registered Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 47,830 InnoDB utf8_general_ci 17.5 MiB -
registered_20 Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 30,953 InnoDB latin1_swedish_ci 25.6 MiB -
research_details Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 64 KiB -
result Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,120 InnoDB latin1_swedish_ci 144 KiB -
scholarship_details Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,499 InnoDB utf8_general_ci 112 KiB -
schools Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 13 InnoDB latin1_swedish_ci 32 KiB -
settings Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9 InnoDB latin1_swedish_ci 16 KiB -
sms_template Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 10 InnoDB latin1_swedish_ci 16 KiB -
society_details Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 697 InnoDB latin1_swedish_ci 64 KiB -
students Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 26,298 InnoDB latin1_swedish_ci 11.8 MiB -
students_phd Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,248 InnoDB latin1_swedish_ci 1.9 MiB -
student_activity Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~2,153,646 InnoDB latin1_swedish_ci 385.9 MiB -
student_details Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 26,223 InnoDB latin1_swedish_ci 27.6 MiB -
student_timeline Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~63,895 InnoDB latin1_swedish_ci 15 MiB -
system_messages Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 45 InnoDB latin1_swedish_ci 64 KiB -
tbldesig Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 937 InnoDB latin1_swedish_ci 128 KiB -
time_slot Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 123 InnoDB latin1_swedish_ci 16 KiB -
tmp_deptdesg Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 896 InnoDB latin1_swedish_ci 128 KiB -
tst_fieldwork Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 47,628 InnoDB utf8_general_ci 7.5 MiB -
tst_fieldwork_even Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 21,801 InnoDB utf8_general_ci 3.5 MiB -
uploads Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 73 InnoDB utf8mb4_general_ci 16 KiB -
users Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,761 InnoDB utf8_unicode_ci 1.9 MiB -
user_activity Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~476,884 InnoDB latin1_swedish_ci 85.6 MiB -
user_details Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,280 InnoDB latin1_swedish_ci 1.7 MiB -
user_role Replicated   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 30 InnoDB latin1_swedish_ci 16 KiB -
86 tables Replication Sum ~5,733,969 InnoDB utf8_general_ci 1.2 GiB 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.