Drop files here

SQL upload ( 0 ) x -

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 :
Customize edit mode.
Edit mode
Documentation Disallow BLOB and BINARY columns from editing. Restore default value
Documentation Display the function fields in edit/insert mode. Restore default value
Documentation Defines whether or not type fields should be initially displayed in edit/insert mode. Restore default value
Documentation How many rows can be inserted at one time. Restore default value
Documentation Sort order for items in a foreign-key dropdown box; content is the referenced data, id is the key value. Restore default value
Documentation A dropdown will be used if fewer items are present. Restore default value
Customize text input fields.
Text fields
Documentation Defines which type of editing controls should be used for CHAR and VARCHAR columns; input - allows limiting of input length, textarea - allows newlines in columns. Restore default value
Documentation Defines the minimum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Defines the maximum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Number of columns for CHAR/VARCHAR textareas. Restore default value
Documentation Number of rows for CHAR/VARCHAR textareas. Restore default value
Documentation Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2). Restore default value
Documentation Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2). Restore default value
Documentation Double size of textarea for LONGTEXT columns. Restore default value
Column Type Function Null Value
id bigint(20) unsigned
institute_id bigint(20) unsigned
year year(4)
total_staffs int(11) 0
total_budget decimal(8,2) 0.00
total_score decimal(8,2) 0.00
score_by_staff decimal(8,2) 0.00
score_by_budget decimal(8,2) 0.00
weighted_score decimal(8,2) 0.00
percentage_research_projects_completed_on_time decimal(8,2) 0.00
num_national_international_collaborative_projects decimal(8,2) 0.00
total_num_degrees_guided decimal(8,2) 0.00
grant_received_other_than_CCRAS decimal(8,2) 0.00
num_national_international_programs_organized decimal(8,2) 0.00
num_policies_regulations_contributed decimal(8,2) 0.00
has_accreditation_other_than_statutory decimal(8,2) 0.00
num_awards_received decimal(8,2) 0.00
total_num_startups_incubated decimal(8,2) 0.00
num_commissioned_reports_prepared decimal(8,2) 0.00
num_new_research_fields_impacting_society decimal(8,2) 0.00
num_technologies_targeted_to_sdg_national_programs decimal(8,2) 0.00
num_reports_new_designs_products decimal(8,2) 0.00
facilities_opened_for_testing decimal(8,2) 0.00
patient_services_footfall_drug_testing decimal(8,2) 0.00
average_bed_occupancy decimal(8,2) 0.00
num_speciality_opds decimal(8,2) 0.00
num_copyrights_trademarks_patents decimal(8,2) 0.00
num_technologies_transferred_domestic_international decimal(8,2) 0.00
num_new_products_services_in_market decimal(8,2) 0.00
num_publications_in_peer_reviewed_journals decimal(8,2) 0.00
num_citations_in_last_three_years decimal(8,2) 0.00
num_collaborative_project_publications decimal(8,2) 0.00
percentage_publications_in_indexed_journals decimal(8,2) 0.00
num_books_ebooks_monographs decimal(8,2) 0.00
num_audio_visual_materials_produced decimal(8,2) 0.00
adopted_digital_technologies_ai decimal(8,2) 0.00
website_is_accessible_and_secure decimal(8,2) 0.00
percentage_budget_returned_unutilized decimal(8,2) 0.00
percentage_budget_on_rnd_to_overall_budget decimal(8,2) 0.00
total_annual_earnings decimal(8,2) 0.00
percentage_permanent_scientists_contractual_researchers decimal(8,2) 0.00
percentage_young_women_scientists_researchers decimal(8,2) 0.00
support_for_women_young_scientists_training decimal(8,2) 0.00
num_scientists_deputed_for_training decimal(8,2) 0.00
num_skill_development_programs decimal(8,2) 0.00
num_training_workshops_cmes decimal(8,2) 0.00
num_persons_attended_skill_development_training decimal(8,2) 0.00
num_officers_trained_in_advanced_areas decimal(8,2) 0.00
num_iec_awareness_programs decimal(8,2) 0.00
num_hindi_activities decimal(8,2) 0.00
num_swachata_action_plan decimal(8,2) 0.00
num_days_weeks_celebrations decimal(8,2) 0.00
celebrates_national_international_days decimal(8,2) 0.00
conducts_regular_review_meetings decimal(8,2) 0.00
completed_activities_as_per_calendar decimal(8,2) 0.00
total_count decimal(8,2) 0.00
status enum -- active
created_at timestamp
updated_at timestamp
percentage_research_projects_completed_on_time_page_no varchar(255)
num_national_international_collaborative_projects_page_no varchar(255)
total_num_degrees_guided_page_no varchar(255)
grant_received_other_than_CCRAS_page_no varchar(255)
num_national_international_programs_organized_page_no varchar(255)
num_policies_regulations_contributed_page_no varchar(255)
has_accreditation_other_than_statutory_page_no varchar(255)
num_awards_received_page_no varchar(255)
total_num_startups_incubated_page_no varchar(255)
num_commissioned_reports_prepared_page_no varchar(255)
num_new_research_fields_impacting_society_page_no varchar(255)
num_technologies_targeted_to_sdg_national_programs_page_no varchar(255)
num_reports_new_designs_products_page_no varchar(255)
facilities_opened_for_testing_page_no varchar(255)
patient_services_footfall_drug_testing_page_no varchar(255)
average_bed_occupancy_page_no varchar(255)
num_speciality_opds_page_no varchar(255)
num_copyrights_trademarks_patents_page_no varchar(255)
num_technologies_transferred_domestic_international_page_no varchar(255)
num_new_products_services_in_market_page_no varchar(255)
num_publications_in_peer_reviewed_journals_page_no varchar(255)
num_citations_in_last_three_years_page_no varchar(255)
num_collaborative_project_publications_page_no varchar(255)
percentage_publications_in_indexed_journals_page_no varchar(255)
num_books_ebooks_monographs_page_no varchar(255)
num_audio_visual_materials_produced_page_no varchar(255)
adopted_digital_technologies_ai_page_no varchar(255)
website_is_accessible_and_secure_page_no varchar(255)
percentage_budget_returned_unutilized_page_no varchar(255)
percentage_budget_on_rnd_to_overall_budget_page_no varchar(255)
total_annual_earnings_page_no varchar(255)
percentage_permanent_scientists_contractual_researchers_page_no varchar(255)
percentage_young_women_scientists_researchers_page_no varchar(255)
support_for_women_young_scientists_training_page_no varchar(255)
num_scientists_deputed_for_training_page_no varchar(255)
num_skill_development_programs_page_no varchar(255)
num_training_workshops_cmes_page_no varchar(255)
num_persons_attended_skill_development_training_page_no varchar(255)
num_officers_trained_in_advanced_areas_page_no varchar(255)
num_iec_awareness_programs_page_no varchar(255)
num_hindi_activities_page_no varchar(255)
num_swachata_action_plan_page_no varchar(255)
num_days_weeks_celebrations_page_no varchar(255)
celebrates_national_international_days_page_no varchar(255)
conducts_regular_review_meetings_page_no varchar(255)
completed_activities_as_per_calendar_page_no varchar(255)


Column Type Function Null Value
id bigint(20) unsigned
institute_id bigint(20) unsigned
year year(4)
total_staffs int(11) 0
total_budget decimal(8,2) 0.00
total_score decimal(8,2) 0.00
score_by_staff decimal(8,2) 0.00
score_by_budget decimal(8,2) 0.00
weighted_score decimal(8,2) 0.00
percentage_research_projects_completed_on_time decimal(8,2) 0.00
num_national_international_collaborative_projects decimal(8,2) 0.00
total_num_degrees_guided decimal(8,2) 0.00
grant_received_other_than_CCRAS decimal(8,2) 0.00
num_national_international_programs_organized decimal(8,2) 0.00
num_policies_regulations_contributed decimal(8,2) 0.00
has_accreditation_other_than_statutory decimal(8,2) 0.00
num_awards_received decimal(8,2) 0.00
total_num_startups_incubated decimal(8,2) 0.00
num_commissioned_reports_prepared decimal(8,2) 0.00
num_new_research_fields_impacting_society decimal(8,2) 0.00
num_technologies_targeted_to_sdg_national_programs decimal(8,2) 0.00
num_reports_new_designs_products decimal(8,2) 0.00
facilities_opened_for_testing decimal(8,2) 0.00
patient_services_footfall_drug_testing decimal(8,2) 0.00
average_bed_occupancy decimal(8,2) 0.00
num_speciality_opds decimal(8,2) 0.00
num_copyrights_trademarks_patents decimal(8,2) 0.00
num_technologies_transferred_domestic_international decimal(8,2) 0.00
num_new_products_services_in_market decimal(8,2) 0.00
num_publications_in_peer_reviewed_journals decimal(8,2) 0.00
num_citations_in_last_three_years decimal(8,2) 0.00
num_collaborative_project_publications decimal(8,2) 0.00
percentage_publications_in_indexed_journals decimal(8,2) 0.00
num_books_ebooks_monographs decimal(8,2) 0.00
num_audio_visual_materials_produced decimal(8,2) 0.00
adopted_digital_technologies_ai decimal(8,2) 0.00
website_is_accessible_and_secure decimal(8,2) 0.00
percentage_budget_returned_unutilized decimal(8,2) 0.00
percentage_budget_on_rnd_to_overall_budget decimal(8,2) 0.00
total_annual_earnings decimal(8,2) 0.00
percentage_permanent_scientists_contractual_researchers decimal(8,2) 0.00
percentage_young_women_scientists_researchers decimal(8,2) 0.00
support_for_women_young_scientists_training decimal(8,2) 0.00
num_scientists_deputed_for_training decimal(8,2) 0.00
num_skill_development_programs decimal(8,2) 0.00
num_training_workshops_cmes decimal(8,2) 0.00
num_persons_attended_skill_development_training decimal(8,2) 0.00
num_officers_trained_in_advanced_areas decimal(8,2) 0.00
num_iec_awareness_programs decimal(8,2) 0.00
num_hindi_activities decimal(8,2) 0.00
num_swachata_action_plan decimal(8,2) 0.00
num_days_weeks_celebrations decimal(8,2) 0.00
celebrates_national_international_days decimal(8,2) 0.00
conducts_regular_review_meetings decimal(8,2) 0.00
completed_activities_as_per_calendar decimal(8,2) 0.00
total_count decimal(8,2) 0.00
status enum -- active
created_at timestamp
updated_at timestamp
percentage_research_projects_completed_on_time_page_no varchar(255)
num_national_international_collaborative_projects_page_no varchar(255)
total_num_degrees_guided_page_no varchar(255)
grant_received_other_than_CCRAS_page_no varchar(255)
num_national_international_programs_organized_page_no varchar(255)
num_policies_regulations_contributed_page_no varchar(255)
has_accreditation_other_than_statutory_page_no varchar(255)
num_awards_received_page_no varchar(255)
total_num_startups_incubated_page_no varchar(255)
num_commissioned_reports_prepared_page_no varchar(255)
num_new_research_fields_impacting_society_page_no varchar(255)
num_technologies_targeted_to_sdg_national_programs_page_no varchar(255)
num_reports_new_designs_products_page_no varchar(255)
facilities_opened_for_testing_page_no varchar(255)
patient_services_footfall_drug_testing_page_no varchar(255)
average_bed_occupancy_page_no varchar(255)
num_speciality_opds_page_no varchar(255)
num_copyrights_trademarks_patents_page_no varchar(255)
num_technologies_transferred_domestic_international_page_no varchar(255)
num_new_products_services_in_market_page_no varchar(255)
num_publications_in_peer_reviewed_journals_page_no varchar(255)
num_citations_in_last_three_years_page_no varchar(255)
num_collaborative_project_publications_page_no varchar(255)
percentage_publications_in_indexed_journals_page_no varchar(255)
num_books_ebooks_monographs_page_no varchar(255)
num_audio_visual_materials_produced_page_no varchar(255)
adopted_digital_technologies_ai_page_no varchar(255)
website_is_accessible_and_secure_page_no varchar(255)
percentage_budget_returned_unutilized_page_no varchar(255)
percentage_budget_on_rnd_to_overall_budget_page_no varchar(255)
total_annual_earnings_page_no varchar(255)
percentage_permanent_scientists_contractual_researchers_page_no varchar(255)
percentage_young_women_scientists_researchers_page_no varchar(255)
support_for_women_young_scientists_training_page_no varchar(255)
num_scientists_deputed_for_training_page_no varchar(255)
num_skill_development_programs_page_no varchar(255)
num_training_workshops_cmes_page_no varchar(255)
num_persons_attended_skill_development_training_page_no varchar(255)
num_officers_trained_in_advanced_areas_page_no varchar(255)
num_iec_awareness_programs_page_no varchar(255)
num_hindi_activities_page_no varchar(255)
num_swachata_action_plan_page_no varchar(255)
num_days_weeks_celebrations_page_no varchar(255)
celebrates_national_international_days_page_no varchar(255)
conducts_regular_review_meetings_page_no varchar(255)
completed_activities_as_per_calendar_page_no varchar(255)

and then
Use TAB key to move from value to value, or CTRL+arrows to move anywhere.

Continue insertion with rows