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 :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `instituteperformance`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id institute_id percentage_research_projects_completed_on_time num_national_international_collaborative_projects total_num_degrees_guided grant_received_other_than_CCRAS num_national_international_programs_organized num_policies_regulations_contributed has_accreditation_other_than_statutory num_awards_received total_num_startups_incubated num_commissioned_reports_prepared num_new_research_fields_impacting_society num_technologies_targeted_to_sdg_national_programs num_reports_new_designs_products facilities_opened_for_testing patient_services_footfall_drug_testing average_bed_occupancy num_speciality_opds num_copyrights_trademarks_patents num_technologies_transferred_domestic_international num_new_products_services_in_market num_publications_in_peer_reviewed_journals num_citations_in_last_three_years num_collaborative_project_publications percentage_publications_in_indexed_journals num_books_ebooks_monographs num_audio_visual_materials_produced adopted_digital_technologies_ai website_is_accessible_and_secure percentage_budget_returned_unutilized percentage_budget_on_rnd_to_overall_budget total_annual_earnings percentage_permanent_scientists_contractual_researchers percentage_young_women_scientists_researchers support_for_women_young_scientists_training num_scientists_deputed_for_training num_skill_development_programs num_training_workshops_cmes num_persons_attended_skill_development_training num_officers_trained_in_advanced_areas num_iec_awareness_programs num_hindi_activities num_swachata_action_plan num_days_weeks_celebrations celebrates_national_international_days conducts_regular_review_meetings completed_activities_as_per_calendar total_count status created_at updated_at
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 1
1 22 2 3 0 0 0.5 0 1 1 0 2 3 0 0 2 3 1 1 0 0 0 1 3 0 2 0 2 0 0 3 1 0.5 0.5 1 1 1 0.25 1 1 0 1 2 2 1 0 1 2 46.75 ACTIVE 2024-11-28 14:37:41 2024-11-28 14:37:41
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 2
2 13 2 1 0 0 2 0 2 0 0 0 1 0 0 0 2 1 1 0 0 0 2 1 0 1 1 1 1 0 3 1 0.5 0.25 1 1 1 1 0.5 0.25 1 1 2 2 1 1 1 2 39 ACTIVE 2024-11-28 14:53:43 2024-11-28 14:53:43
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 3
3 12 2 1 1 0 0.5 0 1 2 0 0 0 0 0 0.5 3 1 1 0 0 0 2 3 0 2 1 1 0 0 3 0.05 1 0.5 1 1 0 0 2 0.25 0.25 1 2 1 1 0 1 2 38.55 ACTIVE 2024-11-28 15:01:02 2024-11-28 15:01:02
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 4
4 20 2 1 0 0 2 2 3 0.5 1 0.5 3 0.5 0 0.5 1 0 1 1 1 0 2 3 0 2 0 2 1 0 3 1 0.5 0.5 1 1 0.5 0.25 1 0.5 0 1 2 2 1 1 1 2 48.75 ACTIVE 2024-11-28 15:25:50 2024-11-28 15:25:50
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 5
5 27 0 0 0 0 0.5 0 1 0 0 0 1 0 0 2 0 0 0 0 0 0 2 3 0 2 1 0 0 0 3 1 0.5 1 0.5 1 0.5 0 0.5 1 0 0 2 1 1 1 1 2 29.5 ACTIVE 2024-11-28 15:36:09 2024-11-28 15:36:09
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 6
6 28 2 1 0 0 0 0 0 0 0 0 0 0 0 0 3 1 0 0 0 0 1 3 0 2 0 1 0 0 3 1 0.5 0.5 1 1 1 0 0 0 0 0.5 2 1 1 1 1 2 30 ACTIVE 2024-11-28 15:41:55 2024-11-28 15:41:55
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 7
7 14 2 1 0 1 0.5 0 0 0.5 0 0 0 0 0 0 2 0.66 0 0 0 0 1 0 0 2 1 0 0 0 3 1 0.5 0.5 0.5 1 0 1 0.5 0.25 0 1 2 2 1 1 1 2 29.91 ACTIVE 2024-11-28 15:51:34 2024-11-28 15:51:34
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 8
8 6 2 2 0 1 0.5 0.5 2 1 0 0 0 0 0 0 3 0 0 1 0 0 1 3 0 2 0 2 0 0 0 1 0.5 0.5 0.5 0.5 0 0 0 0 0 1 1 1 1 0 1 0 29 ACTIVE 2024-11-28 15:56:56 2024-11-28 15:56:56
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 9
9 10 2 1 0 0 0.5 0 2 2 0 0 0 0 0 0 2 2 1 0 0 0 2 3 0 2 1 2 0 0 3 1 0.5 0.5 1 1 0 0.25 1 1 0 1 2 1 1 1 1 2 40.75 ACTIVE 2024-11-28 16:01:55 2024-11-28 16:01:55
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 10
10 19 2 1 0 0 0.5 0 1 0.5 0 0 0 0 0 0 1 0 0 0 0 0 1 1 0 2 0 1 0 0 1 1 0 0.25 1 1 0 0 1 0 0 1 2 1 1 0 1 1 22.75 ACTIVE 2024-11-28 16:06:16 2024-11-28 16:06:16
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 11
11 8 2 3 0 0 2 0 0 0.5 0 0 0 0 0 0 3 0 2 0 0 0 1 3 0 0 1 0 0 0 0 1 1 1 1 1 0 0 0 0.25 0 1 2 1 1 1 0 1 29.75 ACTIVE 2024-11-28 16:16:47 2024-11-28 16:16:47
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 12
12 4 2 3 1 1 2 0 4 2 0 0 0 0 0 2 3 1 1 0 0 0 5 3 1 2 4 2 0 0 2 1 0.5 0.5 0.5 1 1 0 1 0.5 0 1 2 2 1 1 1 1 55.5 ACTIVE 2024-11-28 16:20:59 2024-11-28 16:20:59
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 13
13 18 2 0 0 0 2 0 2 0 0 0 0 0 0 0.5 3 1 1 0 0 0 1 0 0 2 0 2 0 0 3 1 0.5 0.5 1 1 1 1 2 0.5 0 1 2 1 1 1 1 2 37 ACTIVE 2024-11-28 16:40:07 2024-11-28 16:40:07
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 14
14 29 2 1 0 1 2 0 0 1 0 0 1 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 2 1 0.5 0.5 1 0 0 0 2 0.25 0 1 2 1 1 1 0 0 22.75 ACTIVE 2024-11-28 16:45:24 2024-11-28 16:45:24
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 15
15 21 2 2 3 1 2 2 5 0.5 0 2 3 0.5 0 2 2 0 0 0 0 0 5 3 0 2 4 2 1 0 3 1 2 1 1 1 0 0.25 2 0.25 0 1 1 1 1 1 1 2 63.5 ACTIVE 2024-11-28 17:00:11 2024-11-28 17:00:11
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 16
16 9 2 2 0 0 0 0 2 0.5 0 0.5 2 1 0.5 0.5 2 0.5 1 0 0 0 1 3 1 2 0 2 1 0 3 1 0.5 0.25 0.25 1 0.5 0.5 2 0.25 0 1 2 1 1 1 1 2 42.75 ACTIVE 2024-11-28 17:07:09 2024-11-28 17:07:10
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 17
17 17 2 0 0 1 0.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 3 1 1.5 4 0 0 0 0 1 0.5 0.5 1 0.5 0 0.25 0.5 0 0 1 1 2 1 1 1 1 29.25 ACTIVE 2024-11-28 17:10:57 2024-11-28 17:10:57
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 18
18 23 1 2 0 0 2 0.5 0 0 0 0.5 2 2 0.5 1 3 0 0 1 0 0 3 0 2 2 1 2 1 1 1 1 0.5 1 0.5 1 0.25 0.25 1 0.25 0.25 1 2 2 1 1 1 0 42.5 ACTIVE 2024-11-28 17:16:28 2024-11-28 17:16:28
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 19
19 7 2 2 3 1 2 0 4 2 0 0 0 0 0 2 2 0.5 1 0 0 0 5 3 0 2 4 2 1 0 3 1 0.5 0.5 0.5 1 0.5 1 2 0.5 0 1 2 2 1 1 1 2 58.5 ACTIVE 2024-11-28 17:21:35 2024-11-28 17:21:35
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 20
20 15 2 1 0 1 2 0 2 0 0 0 0 0 0 2 2 1 1 0 0 0 3 1 1 2 1 0 0 0 2 1 0.5 0.5 0 0 0 0.25 1 0.25 0 1 2 2 1 1 1 2 37 ACTIVE 2024-11-28 17:26:11 2024-11-28 17:26:11
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 21
21 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 0 2 0 1 0 0 1 0 0 0.5 1 1 1 1 2 0.25 0 1 1 1 1 1 1 2 20.75 ACTIVE 2024-11-28 17:29:29 2024-11-28 17:29:29
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 22
22 16 2 0 0 1 0.5 0 1 0 0 0 0 0 0 0 1 0 0 0 0 0 1 1 0 0 0 1 0 0 3 1 0 0.5 1 1 0 0 0.5 0.25 0 1 2 1 1 1 0 2 22.25 ACTIVE 2024-11-28 17:34:21 2024-11-28 17:34:21
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 23
23 30 0 1 0 1 0.5 0 2 0.5 0 0 0 0 0 1 3 1 1 0 0 0 1 3 0 0 0 2 1 0 2 0.5 0.5 1 1 1 1 1 2 0.5 0 1 2 1 1 1 1 2 37 ACTIVE 2024-11-28 17:38:13 2024-11-28 17:38:13
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 24
24 1 2 3 3 0 0.5 0 2 1 0 2 3 0 0 2 3 1 2 1 0 0 3 3 0 1 3 2 0 1 3 1 0.5 0.5 1 1 1 0.25 2 1 0 1 2 2 1 1 2 2 60.25 ACTIVE 2024-11-28 17:43:24 2024-11-28 17:43:24
Edit Edit Copy Copy Delete Delete
DELETE FROM instituteperformance WHERE `instituteperformance`.`id` = 25
25 2 2 3 1 1 2 0.5 4 2 1 0.5 3 0.5 0.5 2 3 2 2 1 1 1 5 3 0 2 3 2 1 0 3 1 3 0.5 1 1 1 1 2 1 1 1 2 1 1 1 1 2 73 ACTIVE 2024-11-28 17:49:55 2024-11-28 17:49:55
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query