* activity_log_id username date action

* user_id firstname middlename lastname username dep_name password user_added role

* answer_id quiz_question_id answer_text choices

* assignment_id floc fdatein fdesc teacher_id class_id fname

* id student_id student_name course batch subject faculty date status

* id date_of_lecture course_id semester branch_id sub_id reg_no faculty_id arrange_by submission_date camera_status

* id date_of_lecture course_id semester branch_id sub_id reg_no faculty_id arrange_by submission_date

* id attendance_time periods aadhar_no student_name father_name phone_no address attendance_status room_no course_name batch_name subjectname subjectcode semester faculty_assign attendance_date

* id mrp mfg_date exp_date

* id Student Gender stdno email fname fno mname mno DOB Address aim Board response flag

* id course_id Course branch_id branch_name brachint

* class_quiz_id teacher_class_id quiz_time quiz_id

* class_subject_overview_id teacher_class_id content

* id userId userName deptt semester branch

* content_id title content

* id course_id course_name dep_name college

* id english_name tel_number email_address gender age region

* id dep_id dep_name HOD

* COL 1 COL 2 COL 3 COL 4 COL 5 COL 6 COL 7 COL 8 COL 9 COL 10 COL 11 COL 12 COL 13 COL 14 COL 15 COL 16 COL 17 COL 18 COL 19 COL 20 COL 21 COL 22 COL 23 COL 24 COL 25 COL 26 COL 27 COL 28 COL 29 COL 30 COL 31 COL 32 COL 33 COL 34 COL 35 COL 36 COL 37 COL 38 COL 39

* event_id event_title teacher_class_id date_start date_end

* id exam_date exam_name course_id semester branch subject

* eid type eventname group courseid branchid sem regno credit submit_by submitdate

* feedback_id regno subject faculty_id course semester branch knowledge teaching_skills tech_skills ind_atten answerable speed classroom_sessions fac_behavior regularity date_submission other

* feedback_id regno subject faculty_id course semester branch knowledge teaching_skills tech_skills ind_atten answerable speed classroom_sessions fac_behavior regularity date_submission other

* feedback_id regno subject faculty_id course semester branch knowledge teaching_skills tech_skills ind_atten answerable speed classroom_sessions fac_behavior regularity date_submission other

* feedback_id regno subject faculty_id course semester branch knowledge teaching_skills tech_skills ind_atten answerable speed classroom_sessions fac_behavior regularity date_submission other

* feedback_id regno subject faculty_id course semester branch knowledge teaching_skills tech_skills ind_atten answerable speed classroom_sessions fac_behavior regularity date_submission other

* id dep_id faculty_id faculty_name abb dep_name faculty_mobile faculty_email faculty_desig faculty_status location about teacher_stat facultypass

* subject_id faculty_id period room_no

* id faculty_name subject_code course_name batch periods mon tue wed thu fri sat

* fdatein fname fdesc uploaded_by course_name

* id regno fname email mobile city query course date_time ip

* history_id date action data

* id name username password role dep_name

* uid att_date hostel_id hostel_name student_id status date_submission flag

* id hostel_name mess meal food reason room_condition toilet_condition other student_regno student_name date_time

* id hostel_id hostel_name hostel_type username pass warden

* student_id hostel_id roomno name fname course branch year mobile fmobile city remarks

* student_id hostel_id roomno name fname course branch year mobile fmobile city remarks

* student_id hostel_id roomno name fname course branch year mobile fmobile city remarks

* student_id hostel_id roomno name fname course branch year mobile fmobile city remarks

* student_id hostel_id roomno name fname course branch year mobile fmobile city remarks

* student_id hostel_id roomno name fname course branch year mobile fmobile city remarks

* id name address lat lng

* id teacher_class_id exam_name course_id branch_id semester faculty_id sub_id reg_no marks submission_date

* message_id reciever_id content date_sended sender_id reciever_name sender_name message_status

* message_sent_id reciever_id content date_sended sender_id reciever_name sender_name

* student_id hostel_id roomno name fname course branch year mobile fmobile city remarks gphone

* student_id hostel_id roomno name fname course branch year mobile fmobile city remarks gphone

* student_id hostel_id roomno name fname course branch year mobile fmobile city remarks gphone

* student_id hostel_id roomno name fname course branch year mobile fmobile city remarks gphone

* student_id hostel_id roomno name fname course branch year mobile fmobile city remarks gphone

* roomno name fname course branch year mobile fmobile city remarks

* regno name

* reg_id firstname lastname fname mname dob gender religion domicile course branch foccupation fphone gphone sphone pemail semail hostel category caddress paddress adm_mode rollno rank board_x subjects_x passed_year_x marks_x total_x percent_x division_x board_xii subjects_xii passed_year_xii marks_xii total_xii percent_xii division_xii board_dip subjects_dip passed_year_dip marks_dip total_dip percent_dip division_dip board_grad subjects_grad passed_year_grad marks_grad total_grad percent_grad division_grad intermediate_pcm fannual transportation reference refered_by submitted_date

* notification_id teacher_class_id notification date_of_notification link

* notification_read_id student_id student_read notification_id

* notification_read_teacher_id teacher_id student_read notification_id

* id course_id semester dep_id branch_id sub_id faculty_id faculty_name room_number camera_id camera_ip day start_time end_time duration

* id rpnum regno name fathername email mobile dob sex batch course branch tfees tpfees dfees ddfees soch_club sahayog_club aarogyam_club srijan_club balance_fees_date htfees hpfees hdfees hddfees Hostel_Required hostel Reporting_Status dor ip submit_date

* student_id hostel_id roomno name fname course branch year mobile fmobile city remarks

* id regno fname email mobile city query course date_time ip

* question_type_id question_type

* quiz_id quiz_title quiz_description date_added teacher_id

* quiz_question_id quiz_id question_text question_type_id points date_added answer

* regno firstname lastname fatherfirstname fatherlastname fatheroccupation DoB DoBM DoBY Gender contact contact1 contact2 address1 address2 addresscity addressstate addresszip email course category MOE country state city1 city2 city3 dor status

* regno

* id room_id room_name

* school_year_id school_year

* id date_of_lecture course_id semester branch_id sub_id reg_no faculty_id status flag response

* id regno enroll_no name dobdate dobmonth dobyear sex course branch batch semester fathername mothername caddress paddress State City hphone mphone email dorh hosteladd category photograph Ten_Rollno Ten_Percentage Ten_Passingyear Ten_Board Twelth_Rollno Twelth_Parcentage Twelth_Passingyear Twelth_Board

* id regno name fathername gender course branch batch password roomno

* student_assignment_id assignment_id floc assignment_fdatein fdesc fname student_id grade

* file_id floc fdatein fdesc student_id fname

* student_class_quiz_id class_quiz_id student_id student_quiz_time grade

* id regno enroll_no password dep_name course branch name fathername mothername dobdate hphone mphone gphone sex email category batch semester caddress paddress State City aadhar dorh hosteladd location Ten_Rollno Ten_Percentage Ten_Passingyear Ten_Board Twelth_Rollno Twelth_Parcentage Twelth_Passingyear Twelth_Board status_new dor ip Report_Date

* id regno enroll_no password course branch name fathername mothername dobdate hphone mphone gphone sex email category batch semester caddress paddress State City aadhar hosteladd Ten_Rollno Ten_Percentage Ten_Passingyear Ten_Board Twelth_Rollno Twelth_Parcentage Twelth_Passingyear Twelth_Board location status_new dor ip Report_Date

* id regno enroll_no password course branch name fathername mothername dobdate hphone mphone gphone sex email category batch semester caddress paddress State City aadhar dorh hosteladd location Ten_Rollno Ten_Percentage Ten_Passingyear Ten_Board Twelth_Rollno Twelth_Parcentage Twelth_Passingyear Twelth_Board status_new dor ip Report_Date

* id regno enroll_no password course branch name fathername mothername dobdate hphone mphone gphone sex email category batch semester caddress paddress State City aadhar dorh hosteladd location Ten_Rollno Ten_Percentage Ten_Passingyear Ten_Board Twelth_Rollno Twelth_Parcentage Twelth_Passingyear Twelth_Board status_new dor ip Report_Date

* id course_id semester dep_id sub_id room_id faculty_id

* id course_id semester dep_id sub_id faculty_id

* id course_id semester dep_id sub_id faculty_id

* id subcode subname credit_L credit_T credit_P Totalload Effectiveload

* id course_id course_name dep_id dep_name college batch sem subcode subname category unit faculty_name Totalload abb room is_active

* id course_id dep_id sem subcode subname category unit Pre_req description Max_Number Min_Number

* id course_id dep_id sem subcode subname category unit Pre_req description Max_Number Min_Number

* id user_id rate

* file_id floc fdatein fdesc teacher_id fname

* teacher_class_id teacher_id class_id branch_id sem subject_id thumbnails school_year subcode

* teacher_class_announcements_id content teacher_id teacher_class_id date

* teacher_class_student_id teacher_class_id student_id teacher_id

* teacher_notification_id teacher_class_id notification date_of_notification link student_id assignment_id

* teacher_shared_id teacher_id shared_teacher_id floc fdatein fdesc fname

* id name lastname email

* id name lastname email

* id dep_id semester subcode faculty_name room_id start_time end_time days

* id course_id dep_id semester subject_name faculty_id room_id day start_time end_time

* id course_id semester dep_id sub_id faculty_id day start_time end_time duration branch_id faculty_name room_number camera_id camera_ip

* id user_Id userName userEmail userPass mobile deptt date_added role

* id userId userName userEmail userPass mobile deptt date_added role course

* id username password

* id userId userName userEmail userPass mobile deptt date_added role course

* user_log_id username login_date logout_date user_id

select table activity_log admin_users answer assignment attendance attendance_master attendance_master_bk_04_17 attendenceregister barcode boarddata branch_master class_quiz class_subject_overview class_teacher content course_master data department_master dummy event exam_master extras faculty_feedback faculty_feedback_bk faculty_feedback_bk_jan faculty_feedback_feb faculty_feedback_tr faculty_master faculty_subject_assign faculty_time_table files googleppcenquiry history hods hostel_attendance hostel_feedback hostel_master kdbfirst kdbground kdbhawan kdbhawan2ndy kdbsecond kdbthree markers marks_submission message message_sent mlbfirst mlbground mlbhawan mlbsecond mlbthree mlhosteldetails newstudents new_admission notification notification_read notification_read_teacher old_time_table onlinereport2022 plbhawan popupenquiry question_type quiz quiz_question registration roll room_master school_year sms student5 studentdata student_assignment student_backpack student_class_quiz student_master student_master2 student_master_backup student_master_bbbbbbackup subject_allotment subject_allotment_11_06_2025 subject_allotment_old subject_code subject_master subject_master_old subject_master_tr tbl_rating teacher_backpack teacher_class teacher_class_announcements teacher_class_student teacher_notification teacher_shared test_mysql test_mysql_bak timetable_master time_table time_table_bk_16_14_2025 user users usersstd users_bak user_log . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table activity_log admin_users answer assignment attendance attendance_master attendance_master_bk_04_17 attendenceregister barcode boarddata branch_master class_quiz class_subject_overview class_teacher content course_master data department_master dummy event exam_master extras faculty_feedback faculty_feedback_bk faculty_feedback_bk_jan faculty_feedback_feb faculty_feedback_tr faculty_master faculty_subject_assign faculty_time_table files googleppcenquiry history hods hostel_attendance hostel_feedback hostel_master kdbfirst kdbground kdbhawan kdbhawan2ndy kdbsecond kdbthree markers marks_submission message message_sent mlbfirst mlbground mlbhawan mlbsecond mlbthree mlhosteldetails newstudents new_admission notification notification_read notification_read_teacher old_time_table onlinereport2022 plbhawan popupenquiry question_type quiz quiz_question registration roll room_master school_year sms student5 studentdata student_assignment student_backpack student_class_quiz student_master student_master2 student_master_backup student_master_bbbbbbackup subject_allotment subject_allotment_11_06_2025 subject_allotment_old subject_code subject_master subject_master_old subject_master_tr tbl_rating teacher_backpack teacher_class teacher_class_announcements teacher_class_student teacher_notification teacher_shared test_mysql test_mysql_bak timetable_master time_table time_table_bk_16_14_2025 user users usersstd users_bak user_log .	select column