Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: dischargesummaries
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (56367 total, Query took 0.0032 seconds.)
SELECT * FROM `dischargesummaries`

Full texts id mrno current_date patient_name opno admission_date ipno sex age_yr age_mm age_dd admit_doctor_name ward_desc room_desc bed_no discharge_doctor discharge_date discharge_reason follow_up created created_by modified modified_by locationname diag_le diag_re notes surgery va_le va_re surgery_date eye pre_va_le pre_va_re comp_codes follow_up_next admit_doctor_code p_hole_le p_hole_re
1 MR/18/000660 2018-02-06 Mrs MURTA DEVI OP/18/000664 2018-02-06 IP/18/000012 F 65 NULLNULLdr Anoop Mishra EYE GENRAL WARD FF ROOM A BED 05 DR0127-Dr Upendra Singh 2018-02-06 R 2018-02-14 2018-02-06 16:10:55 000167 2018-03-22 17:30:54 0 AEH Normal Normal CAT365 2018-02-06 left 1/2MFC 6/60 2018-03-09 DR0165
2 MR/18/000677 2018-02-07 Mrs SHYAMA DEVI OP/18/000681 2018-02-06 IP/18/000031 F 50 0 0 Dr Upendra Singh EYE GENRAL WARD FF ROOM A BED 09 DR0165-dr Anoop Mishra 2018-02-07 R 2018-02-15 2018-02-07 09:24:53 000167 2018-02-07 09:24:53 0 AEH Normal Normal 0000-00-00 6/12P 1/60FC 2018-03-10 DR0127
3 MR/18/000692 2018-02-07 Smt ANARA DEVI OP/18/000696 2018-02-06 IP/18/000024 F 70 NULLNULLDr Upendra Singh EYE GENRAL WARD FF ROOM C BED 01 DR0146-Dr Amit verma 2018-02-07 R 2018-02-15 2018-02-07 09:26:29 000167 2018-02-07 09:26:29 0 AEH Normal Normal IOL055 2018-02-06 left 3/60 1/60 2018-03-10 DR0127
4 MR/18/000678 2018-02-07 Mrs ANARA   OP/18/000682 2018-02-06 IP/18/000020 F 60 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 5 DR0165-dr Anoop Mishra 2018-02-07 R 2018-02-15 2018-02-07 09:27:14 000167 2018-02-07 09:27:14 0 AEH Normal Normal IOL055 2018-02-06 left 5/60 6/36 2018-03-10 DR0127
5 MR/18/000667 2018-02-07 Mr GAGANRAM   OP/18/000671 2018-02-06 IP/18/000025 M 55 NULLNULLDr Upendra Singh EYE GENRAL WARD FF ROOM C BED 02 DR0146-Dr Amit verma 2018-02-07 R 2018-02-15 2018-02-07 09:27:50 000167 2018-02-07 09:27:50 0 AEH Normal Normal IOL055 2018-02-06 right 5/60 3/60 2018-03-10 DR0127
6 MR/18/000674 2018-02-07 Mr PARTAP   OP/18/000678 2018-02-06 IP/18/000021 M 70 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 6 DR0146-Dr Amit verma 2018-02-07 R 2018-02-15 2018-02-07 09:28:17 000167 2018-02-07 09:28:17 0 AEH Normal Normal IOL055 2018-02-06 right 2/60 1/60 2018-03-10 DR0127
7 MR/18/000663 2018-02-07 Smt PIYARI        DEVI OP/18/000667 2018-02-06 IP/18/000023 F 70 NULLNULLDr Upendra Singh EYE GENRAL WARD FF ROOM B BED 07 DR0165-dr Anoop Mishra 2018-02-07 R 2018-02-15 2018-02-07 09:28:42 000167 2018-02-07 09:28:42 0 AEH Normal Normal IOL055 2018-02-06 left PL+PR 1/60 2018-03-10 DR0127
8 MR/18/000670 2018-02-07 Mrs VIDYA   OP/18/000674 2018-02-06 IP/18/000022 F 60 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 7 DR0165-dr Anoop Mishra 2018-02-07 R 2018-02-15 2018-02-07 09:29:22 000167 2018-02-07 09:29:22 0 AEH Normal Normal IOL055 2018-02-06 left PL PL+PR 2018-03-10 DR0127
9 MR/18/000676 2018-02-07 Mr DHANAU   OP/18/000680 2018-02-06 IP/18/000027 M 50 NULLNULLDr Upendra Singh EYE GENRAL WARD FF ROOM C BED 04 DR0127-Dr Upendra Singh 2018-02-07 R 2018-02-15 2018-02-07 09:30:33 000167 2018-02-07 09:30:33 0 AEH Normal Normal IOL055 2018-02-06 right 3/60 2/60 2018-03-10 DR0127
10 MR/18/000681 2018-02-07 Mr JAIRAM   OP/18/000685 2018-02-06 IP/18/000019 M 75 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 4 DR0146-Dr Amit verma 2018-02-07 R 2018-02-15 2018-02-07 09:31:12 000167 2018-02-07 09:31:12 0 AEH Normal Normal IOL055 2018-02-06 left 3/60 5/60 2018-03-10 DR0127
11 MR/18/000671 2018-02-07 Mrs PHOOLWATI   OP/18/000675 2018-02-06 IP/18/000028 F 65 NULLNULLDr Upendra Singh EYE GENRAL WARD FF ROOM C BED 05 DR0146-Dr Amit verma 2018-02-07 R 2018-02-15 2018-02-07 09:31:51 000167 2018-02-07 09:31:51 0 AEH Normal Normal IOL055 2018-02-06 right 6/36 2/60 2018-03-10 DR0127
12 MR/18/000696 2018-02-07 Mrs HAMID   OP/18/000700 2018-02-06 IP/18/000017 F 65 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 2 DR0165-dr Anoop Mishra 2018-02-07 R 2018-02-15 2018-02-07 09:32:16 000167 2018-02-07 09:32:16 0 AEH Normal Normal IOL055 2018-02-06 right 5/60 5/60 2018-03-10 DR0127
13 MR/18/000659 2018-02-07 Mr GYANMATI   OP/18/000663 2018-02-06 IP/18/000016 M 55 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 1 DR0146-Dr Amit verma 2018-02-07 R 2018-02-15 2018-02-07 09:32:40 000167 2018-02-07 09:32:40 0 AEH Normal Normal IOL055 2018-02-06 right 3/60 2/60 2018-03-10 DR0127
14 MR/18/000685 2018-02-07 Smt DAULA   OP/18/000689 2018-02-06 IP/18/000026 F 65 NULLNULLDr Upendra Singh EYE GENRAL WARD FF ROOM C BED 03 DR0146-Dr Amit verma 2018-02-07 R 2018-02-15 2018-02-07 09:33:06 000167 2018-02-07 09:33:06 0 AEH Normal Normal IOL055 2018-02-06 right 3/60 2/60 2018-03-10 DR0127
15 MR/18/000679 2018-02-07 Smt BHAGIRATI   OP/18/000683 2018-02-06 IP/18/000029 F 70 NULLNULLDr Upendra Singh EYE GENRAL WARD FF ROOM C BED 06 DR0146-Dr Amit verma 2018-02-07 R 2018-02-15 2018-02-07 09:33:36 000167 2018-02-07 09:33:36 0 AEH Normal Normal IOL055 2018-02-06 right 6/60 PL+PR 2018-03-10 DR0127
16 MR/18/000689 2018-02-07 Smt BELA DEVI OP/18/000693 2018-02-06 IP/18/000018 F 75 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 3 DR0165-dr Anoop Mishra 2018-02-07 R 2018-02-15 2018-02-07 09:34:27 000167 2018-02-07 09:34:27 0 AEH Normal Normal IOL055 2018-02-06 right 6/36 1/60 2018-03-10 DR0127
17 MR/18/000678 2018-02-07 Mrs ANARA   OP/18/000682 2018-02-06 IP/18/000020 F 60 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 5 2018-02-07 R 2018-02-15 2018-02-07 10:05:55 000136 2018-02-07 10:05:55 0 AEH Normal Normal IOL055 6/24 2018-02-06 left 5/60 6/36 2018-03-10 DR0127 6/9
18 MR/18/000667 2018-02-07 Mr GAGANRAM   OP/18/000671 2018-02-06 IP/18/000025 M 55 NULLNULLDr Upendra Singh EYE GENRAL WARD FF ROOM C BED 02 2018-02-07 R 2018-02-15 2018-02-07 10:15:20 000136 2018-02-07 10:15:20 0 AEH Normal Normal IOL055 6/36 2018-02-06 right 5/60 3/60 2018-03-10 DR0127 6/18
19 MR/18/000674 2018-02-07 Mr PARTAP   OP/18/000678 2018-02-06 IP/18/000021 M 70 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 6 2018-02-07 R 2018-02-15 2018-02-07 10:19:58 000136 2018-02-07 10:19:58 0 AEH Normal Normal IOL055 6/60 2018-02-06 right 2/60 1/60 2018-03-10 DR0127 6\12
20 MR/18/000663 2018-02-07 Smt PIYARI        DEVI OP/18/000667 2018-02-06 IP/18/000023 F 70 NULLNULLDr Upendra Singh EYE GENRAL WARD FF ROOM B BED 07 2018-02-07 R 2018-02-15 2018-02-07 10:24:07 000136 2018-02-07 10:24:07 0 AEH Normal Normal IOL055 6/60 2018-02-06 left PL+PR 1/60 2018-03-10 DR0127 6/36
21 MR/18/000670 2018-02-07 Mrs VIDYA   OP/18/000674 2018-02-06 IP/18/000022 F 60 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 7 2018-02-07 R 2018-02-15 2018-02-07 10:28:55 000136 2018-02-07 10:28:55 0 AEH Normal Normal IOL055 PL+PR++ 2018-02-06 left L PL+PR 2018-03-10 DR0127 NI
22 MR/18/000681 2018-02-07 Mr JAIRAM   OP/18/000685 2018-02-06 IP/18/000019 M 75 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 4 2018-02-07 R 2018-02-15 2018-02-07 10:33:05 000136 2018-02-07 10:33:05 0 AEH Normal Normal IOL055 6/60 2018-02-06 left 3/60 5/60 2018-03-10 DR0127 6/18
23 MR/18/000671 2018-02-07 Mrs PHOOLWATI   OP/18/000675 2018-02-06 IP/18/000028 F 65 NULLNULLDr Upendra Singh EYE GENRAL WARD FF ROOM C BED 05 2018-02-07 R 2018-02-15 2018-02-07 10:37:28 000136 2018-02-07 10:37:28 0 AEH Normal Normal IOL055 6/36 2018-02-06 right 6/36 2/60 2018-03-10 DR0127 6/18
24 MR/18/000696 2018-02-07 Mrs HAMID   OP/18/000700 2018-02-06 IP/18/000017 F 65 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 2 2018-02-07 R 2018-02-15 2018-02-07 10:41:06 000136 2018-02-07 10:41:06 0 AEH Normal Normal IOL055 6/12 2018-02-06 right 5/60 5/60 2018-03-10 DR0127 6/9
25 MR/18/000696 2018-02-07 Mrs HAMID   OP/18/000700 2018-02-06 IP/18/000017 F 65 NULLNULLDr Upendra Singh EYE GENRAL WARD FF CAMP 1 BED 2 2018-02-07 R 2018-02-15 2018-02-07 10:41:06 000136 2018-02-07 10:41:06 0 AEH Normal Normal IOL055 6/12 2018-02-06 right 5/60 5/60 2018-03-10 DR0127 6/9